Microsoft Access 2007, 2010 and 2013 Tutorial

1 Introduction to the MS Access 2007/2010/2013 Tutorial

Welcome to the MS Access tutorial. This tutorial is designed to get the user up and running with MS Access (henceforth simply “Access”) in a rapid fashion. The four basic modules of Access are demonstrated: Tables, Forms, Reports and Queries. A business example is discussed first which provides a background for developing a simple database.

It is assumed that users of this tutorial are proficient in working with Microsoft Windows XP/Vista/Win7 and with MS Excel. This includes the use of the keyboard and mouse. The tutorial is based on Microsoft Access which is part of the Microsoft Office Professional suite that also includes MS Excel, MS Word and MS Powerpoint.

This tutorial covers MS Access 2007, 2010 and 2013 which have a common interface (the “ribbon bar” across the top) that is different from earlier versions. If you are interested in working with MS Access ’97 or 2000, please visit the Microsoft Access Tutorial – Covering MS Access ’97 and 2000 web page.

The tutorial begins with a brief overview of Relational Databases. The majority of database management systems in use today are based on what is called the relational database model. Access is a relational database management system. We then describe a business example and give an outline for the database and applications we wish to develop. In the sections that follow, we give step-by-step instructions for creating the tables, data entry forms, reports and queries for the application.

1.1 Intended Audience

This tutorial is intended for students just getting started with the MS Access database management system.

1.2 Pre-Requisite Knowledge

This tutorial assumes the student is familiar with the basic operation of a personal computer and Windows 2000, Windows XP, Windows Vista or Windows 7. Specific skills required for this tutorial are:

  • Use of the mouse and keyboard
  • Opening and saving files on the hard disk and on USB memory stick (thumb drive) for example
  • Managing files in general including the difference between drive letters, hard disk, etc.
  • Running programs from the Windows Start menu
  • Minimizing, maximizing and resizing windows

The student should have a USB memory stick (thumb drive) or other portable memory device available to store their files that will be created during this tutorial.

1.3 Running Microsoft Access on a Apple Mac

One issue that may face some students is the fact that MS Access only runs under the Windows operating system (such as Windows XP, Vista or Windows 7). If you have a MacBook, iMac or other Apple system running MacOS that uses an Intel CPU, there are a few possible alternatives you can try. Many modern Apple computers that use Intel CPU can run the Windows operating system. Note that you will need a legally licensed copy of Windows operating system to do this. There are two main ways to accomplish this:

  • You can set up your Mac to “Dual Boot” both MacOS X and Windows. One product that can enable this is Apple BootCamp software.
  • You can run Windows OS “side by side” with Mac OS X using a “virtual” computer such as VirtualBox

Table of Contents

Tags: , , , , , , , , , ,

9 Responses to “Microsoft Access 2007, 2010 and 2013 Tutorial”

  1. Hi,
    I am pretty much know the basic MS Access, my number one goal is how to kearn its property applications in filed and customs.
    See what I want to compose is a simple Q/A tables, wher you can click on the tab button and it will show you either the answer is “right” or “wrong”
    Example

    How much apple?
    A) 1
    B) 2
    C) 3
    D) 4
    “RightAnswer” (“1″)
    So when I click A it will give me “RightAnswer” then I can go to the next question and so on, now if I click the others also should shows “WrongAnswer” or try Again.
    I can be able to connect for all the wronganswer but having problem to connect the right value field or text for all the rightanswer, I hope you guys can I advice me and I am willing to attend training for it.

    Thank you,
    Richard

    October 9, 2013 at 8:49 pm
    • Hi
      I think it is important to get the right table structure for this. Assuming you did this all in one table:
      – The question number
      – The question text
      – Answer A
      – Answer B
      – Answer C
      – Answer D
      – CorrectAnswer

      So you would show the user the first 6 items (the CorrectAnswer would be on the form but hidden). Then when they indicate an answer, compare what they put in with the value in the CorrectAnswer field. If they match then you can move to the next question (which should be your next record in your questions table). If they do not match then you can pop up a window or show a message asking them to try again.

      Cheers,
      Rich H.

      October 10, 2013 at 7:18 am

Trackbacks/Pingbacks

  1. Advanced Database Table Design in MS Access 2010 and 2013 | Holowczak.com - May 20, 2013

    […] place. If you are just getting starting with Microsoft Access, I suggest you first go through my MS Access 2007/2010 Tutorial as it provides instructions on all of the basic Access components (Tables, Queries, Forms, Reports […]

  2. Advanced Microsoft Acess Tutorials – Table Design | Holowczak.com - May 20, 2013

    […] Microsoft Acess Tutorials – Table Design Folks Did you enjoy my Microsoft Access 2007/2010 Tutorial but wanted to learn more advanced topics and techniques? If so, then I am happy to announce a set […]

  3. Advanced Forms Design in Microsoft Access 2010 and 2013 | Holowczak.com - June 3, 2013

    […] place. If you are just getting starting with Microsoft Access, I suggest you first go through my MS Access 2007/2010 Tutorial as it provides instructions on all of the basic Access components (Tables, Queries, Forms, Reports […]

  4. Advanced Microsoft Access – Forms | Holowczak.com - June 3, 2013

    […] tutorial picks up where my Introduction to Microsoft Access Tutorial leaves off by taking an in-depth look into forms design, properties, fields, macros, VBA […]

  5. Microsoft Access ’97 and 2000 Tutorial | Holowczak.com - July 5, 2013

    […] you have a later version of MS Access such as Access 2007 or Access 2010, you may wish to visit the Microsoft Access 2007/2010 Tutorial web […]

  6. Introduction to Access | Access to Computing 2013 - October 3, 2013

    […] http://holowczak.com/microsoft-access-2007-and-2010-tutorial/ […]

  7. Working with Structured Query Language (SQL) using Microsoft Access 2010 and 2013 | Holowczak.com - October 21, 2013

    […] in this brief tutorial are based on the simple Customer and Accounts tables created as part of my Microsoft Access 2007, 2010 and 2013 Tutorial. You may wish to first run through that tutorial (or at least the first few sections) to create the […]

Leave a Reply

You must be logged in to post a comment.