|
MICROSOFT ACCESS INTERMEDIATE 2003
AIMS AND OBJECTIVES
This one-day training session will expand on participants' existing
knowledge of Microsoft Access. During the session participants
will receive training on a variety of uses of Access in the workplace.
All participants will receive hands-on training of all the topics.
WHO SHOULD ATTEND?
The training session is designed for those who have a good grounding
in Microsoft Access, for example, following attendance at an Introduction
workshop. Each participant will be given a comprehensive reference
manual to take away with them.
COURSE CONTENT
Planning & Designing
- Determine the Requirements
- Determine the Tables
- Determine the Fields
- Determine the Relationships
|
Queries
- Select Queries
- Parameter Queries
- Multiple Table Queries
- Calculations within a Query |
Relationships
- Overview of Relationships
- Creating
- Editing
- Removing
- Working with Related Tables |
More on Forms
- Forms to display related tables
- Linked Forms |
Working with Tables
- Lookup Lists
- Default Values
- Input Masks |
More on Reports
- Grouped Reports
- Reports with Subtotals |
|
