Intermediate Microsoft Access

Duration: 1 day (6 hours)

Prerequisite(s): Introduction to Microsoft Access 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 Microsoft Access.

Who Should Take This Seminar: Intermediate Microsoft Access is designed to instruct the student in how to create more advanced tables, queries, reports, macros, and forms in order to enhance the usability of this powerful database product. The student should have taken Systemetrics' Introduction to Microsoft Access seminar or have equivalent experience, which includes being able to create tables, forms with different types of controls, select queries, and basic reports. Those uncertain whether this seminar is appropriate for them should call Systemetrics at (401) 275-2200.

1. Managing Files
1. Compacting database files
2. Repairing database files
3. Introducing file and object security
2. Using Different Types Of Queries
1. Selecting data with select queries
2. Adding records to tables with append queries
3. Summarizing information with crosstabs queries
4. Deleting records with delete queries
5. Copying records to a new table with make-table queries
6. Changing data with update queries
7. Using parameters/variables in queries
8. Creating queries that calculate cumulative totals, averages, counts, etc.
9. Using queries to delete duplicate records
10. Changing link properties
3. Using Expressions for Calculation and Criteria
1. Using calculated fields in queries
2. Using calculated controls in forms and reports
3. Using functions
1. Date functions
2. IIF function
3. ISNULL and similar functions
4. DLOOKUP function
4. Importing, Exporting, and Linking Data and Objects
5. Using Form Controls and Buttons
6. Creating and Using Macros
1. Creating macros
2. Attaching macros to event properties
3. Using macro commands to force control recalculation
4. Using macro commands to place data in fields