Duration: 1 day (6 hours)

Prerequisite(s): Intermediate Microsoft Access Level 2, or equivalent experience

Environment: Microsoft Windows

Version(s): All through Access 2003. Taught using Access 2003.

Support: Upon completion of this seminar, the student will be entitled to unlimited, free telephone support in Access.

Who Should Take This Seminar: Intermediate Microsoft Access - Level 3 is designed to enhance the student's knowledge of the many advanced features of Microsoft Access, including many of the new features that appeared in Access 2000. Students who take this seminar will develop a greater understanding of database management, programming and data analysis. The student should have taken Systemetrics' Intermediate Microsoft Access - Level 2 seminar or have equivalent experience, which includes being able to create all the different types of queries, understand subforms and subreports, and create forms to display only certain records. Those uncertain whether this seminar is appropriate for them should call Systemetrics at (401) 275-2200.

1. Database Management
1. Understanding relationships in a database
2. Using Name AutoCorrect (available only in Access 2000 or greater)
3. Reestablishing references
4. Splitting a database
5. Creating MDE files
2. Tables and Queries
1. Using subdatasheets (available only in Access 2000 or greater)
2. Defining column headings in crosstab queries
3. Combining data from 2 or more tables using SQL statements
3. Forms and Reports
1. Creating dynamic combo and list boxes
2. Modifying the contents of a combo or list box based on a previous entry
3. Deleting automation controls from forms
4. Changing the control type for existing controls
5. Reattaching captions to controls
6. Using Conditional Formatting (available only in Access 2000 or greater)
7. Creating a multiple-column report
8. Using the OnFormat event property
9. Resetting page numbers for each group in a report
10. Using PivotTable Forms
4. Programming
1. Using Event Procedures
2. Setting conditions in a macro
3. Using the SetWarnings action
4. Using the Echo and Hourglass actions
5. Using the StopMacro and the StopAllMacros action
6. Creating a Macro Group using macro names
7. Converting macros to Visual Basic procedures
8. Opening files in other applications from Access
5. Other
1. Linking Excel to Access using Microsoft Query
2. Using Data Access Pages (available only in Access 2000 or greater)