Duration: 1 day (6 hours)

Prerequisite(s): Intermediate 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 Access.

Who Should Take This Seminar: Intermediate Microsoft Access - Level 2 is designed to enhance the student's knowledge of the many advanced features of Microsoft Access, including advanced queries and forms. Students who take this seminar will develop a greater understanding of data manipulation and analysis and different techniques for using forms to access records. The student should have taken Systemetrics' Intermediate Microsoft Access seminar or have equivalent experience, which includes creating and using select, crosstab, make table, append, update and delete queries, using parameters in queries, setting properties in tables, queries, forms and reports, and creating simple macros. Those uncertain whether this seminar is appropriate for them should call Systemetrics at (401) 275-2200.

1. Managing Databases
1. Customizing the Access environment
2. Importing objects from other Access databases
3. Managing linked/attached tables
4. Understanding Access and the year 2000
2. Managing Tables
1. Managing indexes and the primary key
2. Using multiple field indexes
3. Setting and resetting the value of an Autonumber field
3. Managing Reports
1. Changing the record source
2. Sorting and grouping data
3. Generating record counts
4. Using main and subreports
5. Generating static HTML pages
4. Managing Forms
1. Changing the record source
2. Understanding the order of events
3. Date/time stamping records
4. Using query by form
5. Using main and subforms
6. Using tabbed forms
7. Using the custom calendar control
5. Managing Controls
1. Using properties
2. Creating custom formats
6. Managing Queries
1. Creating a query to return top values
2. Using extended wildcard characters
3. Using comparison and logical operators
4. Establishing compound criteria
5. Using wildcards with parameters
7. Programming in Macros and Modules
1. Understanding macros versus modules and Visual Basic
2. Creating and using custom functions