Beginning

Intermediate

Advanced

 Access 2.0 for Windows

Module 1: Accessing Access. Navigate the Screen, View Operating Modes, Access Help, Use Cue Cards

Module 2: Table Design. Use a Table Wizard, Design a Table, Enter Data, Modify the Datasheet, Edit Field Attributes, Filter/Sort

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

Module 4: Form Design. Use a Form Wizard, Design a Form, Modify Controls, Use Calculated Fields

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

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

Module 7: Data Relations. Normalize Data, Establish Simple Relationships, Create a Complex Relational Database, Use the Relationships Window

Module 8: Report Creation. Use the Report Wizards, Lay Out a Report, Use Calculated Fields, Make Mailing Labels

Module 9: Advanced Queries. Make a Multitable Query, Create an Equi-Join, Make Outer Joins, Create a Theta Join, Explore Referential Integrity, Use Action Queries

Module 10: Power Table Use. Attach a Table, Delete an Attached Table, Attach a FoxPro Table, Use the IIF Function, Cascade Updates and Deletes

Module 11: Customizing Forms. Use Headers and Footers, Insert Graphics, Change Tab Order, Make Combo Boxes, Make a Subform

Module 12: Formatting Reports. Group Data, Use Summary Controls, Create a Multicolumn Report, Make Subreports

Module 13: Using Macros. Run a Macro, Create a Macro, Use the DoMenuItem Action, Add a Macro Shortcut, Make a Macro Button, Construct Decision-Making Macros, Run a Macro from a Macro

Module 14: Access Modules. Explore the Module Window, Use Access Basic Help, Use the Immediate Window, Edit Module Syntax, Set a Breakpoint, Use a Module Function in a Form

Module 15: Writing in Access Basic. Write User-Defined Functions, Use If-Then-Else Statements, Use Select Case...End Select Statements, Use For...Next Loops, Use Do While...Loop Statements

Module 16: Power Access Techniques. Use Access SQL Statements, Use the Menu Builder, Run a Macro from an Event, Add a Graph to a Form