Microsoft Access Training: Advanced

Description

By the end of the course delegates will be able to design and build relational databases that incorporate macro automation, manipulate data with advanced queries and produce advanced form and report design.

Pre-Requisites

Delegates should have a good working knowledge of Microsoft Access or have attended either of the Access Introduction or Intermediate training courses prior to attending this course.

Course Content

Advanced Forms

Multi-table forms
The expression builder
Switchboards

Advanced Reports

Sub-reports
Mailing labels
Incorporating pictures

Creating Relational Queries

Joining tables in a query
Types of joins
Calculating in queries
Action queries
Summarising data queries
Cross tab queries
Using parameters

Importing, Exporting and Attaching Data

Import from Excel and Word
Attach external data
Using mail merge wizard

Format

This course is instructor led in a classroom environment. We recommend a maximum of 8 delegates per course to ensure that all delegates gain the maximum benefit from the course.

Duration

This is a one day course. Standard hours are 9:30 to 16:30, with a one hour lunch break, and short breaks mid morning and mid afternoon. It may be possible to change this arrangement by request.