Microsoft Access Advanced Outline
Aims of the Two-Day Course
This course has been designed to give experienced users the skills they
need to develop integrated database solutions using Microsoft Access.
The course is 100% hands on, with exercises to practice the skills as
you learn them.
Course Content
- Forms & Subforms
- Form Properties
- Navigating Forms and Subforms
- Linking to another Subform
- Forms - Expressions
- Entering Expressions
- The Expression Builder
- Expressions in Forms and Subforms
- Calculations in Queries
- Types of Calculations
- Predefined Calculations
- Custom Calculations
- Using Dates in a Query
- Parameter Queries
- Using text, numbers and expressions
- Using several parameters
- Crosstab Queries
- Creating and Changing a Crosstab Query
|
- Append & Delete Queries
- Creating an Append Query
- Removing Duplicate Records
- Delete Queries
- Reports
- Report Design
- Expressions, Totals & Parameters
- Reports and Sub Reports
- Command Buttons
- Events & Macros
- Creating and Running a Macro
- Using a Macro to Update a Field
- Mail Merge
- Linking a Database Table
- Creating a New Document
- Performing the Mail Merge
|
Prerequisites
Trainees must have attended either the Intermediate or Level One course.
Alternatively the trainees must have a very good working knowledge of
Access.
Course Duration
Twelve hours (9.30am to 12.30pm and 1.30pm to 4.30pm on both days).
Next Course
Microsoft Access VBA
Prices
|
