Microsoft Access Training Manuals

10 Times Faster
10 Times Easier
10 Times the Comprehension

MS Access Training & Assignments

This hands-on, experiential, student-based manual is a highly visual step-by-step approach to creating applied technological or business database examples. It assumes that the student has no experience or background with MS Access software or databases. The intent is to leave the student with a solid foundational core to use and to build upon. It is a very user-friendly manual and is meant for self-paced learning with little or no input from an instructor. The manual proceeds to take the student through:

Building a database structure
Filling it with data
Editing
Sorting
Queries (simple, complex and conditional)
Expression builder
Action queries, (Make Table, Delete, Append, Update)
Parameter queries (Parameter, Group by)
Construction of forms, subforms, and subdatasheets
Construction of reports
Importing Excel data
Referential Integrity
Relationships (One to many, Many to many)
Primary key
Foreign key
Input Mask Expressions

The concept of developing calculated columns using formulas, functions and the expression builder is also incorporated in the development of reports.

Distance delivery and e-learning classes are greatly enhanced with the use of these materials as questions are answered by working through the materials. The manual is designed for a 25-hour (or less) course depending on the depth required.