Training
Topics

Training Overview: Advanced Microsoft Access

This course is intended for users who have a good working knowledge of Microsoft Access or who have attended the Microsoft Access Introduction or Intermediate training courses. By the end of the course the delegate will feel confident to design and build relational databases that incorporate macro automation, manipulate data with advanced queries and produce advanced form and report design.

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.