Microsoft Access Tutorials

Each of the Access tutorials is designed as two Modules. In the first Module, you'll learn how to create a database and enter data. In the second Module you'll learn how to manipulate the database. The individual areas, covered in each Module, are furnished below. All of the tutorials follow the same theme - creating a Personnel database. This is purposeful. It was felt that, as a person progressed to newer versions of Access, having the same tutorial theme would make them more comfortable with learning the material. Each succeeding tutorial is enhanced to incorporate new features in Access and respond to added features requested by users.

Module 1

Introduction (Menu bars, buttons, toolbars, moving around Access)
Designing Databases
Creating Tables
Creating and Using Forms
Working with Tables

Module 2

Working with Table Information (Adding, Editing, Deleting, Sorting and Finding Records)
Creating Select Queries (Selecting Tables and Fields)
Working with Select Queries (Adding, Deleting, Inserting and Moving Fields, Wildcard characters, Multiple Criteria)
Creating and Using Reports
Enhancing Forms and Reports

Access 2007 Introductory Tutorial
(Click-on the above link to download a 2.8 MB - 51 Page Word Document)

Access 2003 Introductory Tutorial
(Click-on the above link to download a 1.1 MB - 40 Page Word Document)

Access 2002/XP Introductory Tutorial
(Click-on the above link to download a 559 KB - 35 Page Word Document)

Access 2000 Introductory Tutorial
(Click-on the above link to download a 445 KB - 34 Page Word Document)

Databases Created by Tutorials

The individual databases, created by each tutorial, are furnished below if you would like to download them.

Please note: Depending on your computer setup and security programs, you may receive an alert that indicates that your system will not allow Access Databases to be opened for security reasons. You should see a menu screen that asks you if you desire to save these below databases to your system. If you want to review the databases created by the tutorials, you will have to save them to your computer and then open them as you would any other file.

Access 2007 Database
(Click-on the above link to download a 2.6 MB database file)

Access 2003 Database
(Click-on the above link to download a 1.1 MB database file)

Access 2002/XP Database
(Click-on the above link to download a 336 KB database file)

Access 2000 Database
(Click-on the above link to download a 336 KB database file)

Return to Office Tutorials Homepage