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

Tutorials

Access 97 Introductory Tutorial
(Click-on the above link to download a 292 KB - 25 Page Word Document)

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

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

Access 2003 Introductory Tutorial
(Click-on the above link to download a 1.1 MB - 40 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:  

Attached are ZIP files for the Person 97, 2000, XP/2002 and 2003 Access databases.  Access databases are a huge source of worms and viruses and most systems block .mdb and .accdb files.  That is why you may have had problems downloading them from the website previously.  We have now converted all of the .mdb and files to ZIP files.  When you open the attached ZIP file, you will notice, is a .txt (text) file - which your system should allow.  Save the Person 97, 2000, XP/2002 and 2003.txt file somewhere on your computer.  Then, right click on the file and choose Rename.  Change the txt to mdb– (e.g. Person 97.txt to Person 97. mdb).  This will make it a 97, 2000, XP/2002 or 2003 Access file and you should be able to open the file in Access 97, 2000, XP/2002 or 2003.  Recently, several folks have indicated that they could not do this.  Our staff feels that it is because of the additional SPAM protection that many organizations have added to their systems. 

If you have trouble downloading this file, please e-mail the address below and we will send you the file.  If this still does not work, we'll mail you the Office Tutorial CD which contains the Access files.

Access 97 database
(Click-on the above link to download a 344 KB database file)

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

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

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

If you have any questions or comments, please don't hesitate to contact murray.t@lynchburg.edu

Return to Office Tutorials Homepage

Resources for Access Database

Introductory:

Microsoft Press Quick Course in Access 97
Microsoft Press Quick Course in Access 2000
Microsoft Press Access Version 2002 Plain and Simple
Microsoft Press Access Version 2003 Step by Step

Advanced

Microsoft Press Running Microsoft Access 97
Microsoft Press Running Microsoft Access 2000
Microsoft Press Access Version 2002 Inside Out
Microsoft Press Access Version 2003 Inside Out