5 Free Access Workshop Training Tutorials

Level 1 Classes: beginning topics designed to develop basic application skills.  
Level 2 Classes: intermediate topics that assume users have some working knowledge and experience with the application.
Level 3 Classes: advanced topics that assume the users have strong knowledge and experience but wish to extend their skills.Topics:

Level 1 

Introduction to Access Training Manual

The first in the series for building a relational database, this workshop provides the foundation for beginning to create a database and start storing data.   Tables are the basis of each database, and we begin here by learning how to plan and design tables. 

Topics:           
  » Planning Your Database and Tables
  » Designing Tables
  » Field Properties
  » Data Entry

Now that your data is stored, you might want to find a way to view it according to certain criteria, or view certain data.  Queries allow you to pull specified records for viewing or editing.  In this workshop you will learn how to design the queries and understand what they are used for.

Topics:           
  » Types of Queries
  » Designing a New Query
  » Running Queries
  » Using Criteria
  » Creating  Parameter Queries
Sample Database File

Level 2 

Creating Relationships in Access Training Manual

Access is designed for relational databases so that separate tables of information can share data. 

Topics:
  » Understanding Relationships
  » Primary Keys
  » Creating Relationships
  » Working with Subdatasheets
Sample Database File

Access Forms and Reports Training Manual

Forms give you a way to create a more user friendly interface for data entry and data viewing.  Reports provide a printout of complete or summarized data.  Learn how to create and format both.

Topics:           
  » Creating a New Form
  » Using a Form
  » Using the Form Wizard
  » Creating a New Report
  »  Editing a Report
Sample Database File

Level 3:

Access Switchboards Training Manual

Creating switchboards for your Access Database gives users a friendly environment to use for data entry, viewing records, pulling reports, and more.  The switchboard can become the center of operations for using the objects in your database and provides an element of security as well.

Topics:
  » Creating a Switchboard
  » Using Command Buttons
  » Using Macros
  » Security Options
Sample Database File