Beginning

Intermediate

Advanced

Apr. 15

Module 1: Accessing Access. Navigate the Screen, Get On-line Help, View Operating Modes, Understand Object Properties, Create a Database File

Module 2: Table Design. Use a Table Wizard, Design a Table, Enter and Delete Data, Format the Datasheet, Filter and Sort Tables

Module 3: Fields and Formats. Edit Field Attributes, Set Value Limits, Use Default Values, Create Required Fields, Change Format Properties, Use Input Masks

Module 4: Form Design. Explore Forms, Use a Form Wizard, Design a Form, Modify Display Attributes, Modify Form Controls, Change Tab Order, Use Calculated Fields

Module 5: Searching and Sorting. Create a Select Query, Sort Data, Use Multiple Criteria: ANDs/Ors, Create a Calculation Query, Use an Action Query, Use a Query Wizard, Create a Parameter Query

Module 6: Import and Export Data. Export to Excel, Import an Excel Worksheet, Export to a Text File, Import to a Text File, Import a Paradox File, Import an Access Object

Module 7: Data Relations. Use Analyzing Tools, Normalize Data, Establish Simple Relationships, Create a Complex Relational Database, Use the Relationships Windows, Explore Referential Integrity

Module 8: Report Creation. Use the Reports Wizard, Lay Out a Report, Modify Display Attributes, Use Calculated Fields, Print a Report, Create Mailing Labels  

Module 9: Advanced Queries. Make Multitable Queries, Create Equi-Joins, Create Outer Joins, Use Action Queries, Use Referential Integrity, Use Multitable Queries

Module 10: Power Table Use. Link and Unlink a Table, Modify Table Properties, Create Combo Boxes, Create Lookup Tables, Insert Graphics in Fields

Module 11: Customizing Forms. Insert Graphics, Employ Display Controls, Create Grouped Controls, Modify Form Properties, Use the Dlookup Function, Use the IIF Function, Make a Subform

Module 12: Formatting Reports. Create Multitable Reports, Use Graphics in Reports, Create Report Templates, Create AutoForm Entries, Group Data, Use Summary Controls

Module 13: Using Macros. Run a Macro, Create a Macro, Create AutoKey Macros, Use the DoMenuItem Action, Reference Object Properties, Create Decision-Making Macros

Module 14: Control Extensions. Run Macros at Startup, Synchronize Forms to Same record, Run Macros in Macros, Assign Macros to Events, Create a MacroButton

Module 15: Power Access Techniques. Explore Access SQL, Write a SQLStatement, Assign SQL Statements to Objects, Use the Menu Builder, Create a Crosstab Query, Use Charts

Module 16: Access Modules. Explore the Module Windows, Use the Debug Window, Edit Visual Basic Code, Write User-Defined Functions, Use IF-THEN-ELSE Statements, Use SELECT CASE...END SELECT Statements, Use a Module Function in a Form