Microsoft Access Advanced training

Course duration

(we will customise to your learning requirements and timeframe)

Target audience

This course is designed for those who already have a good understanding of Microsoft Access and need to upgrade their skills.

Download the PDF Course Outline.

Course Objectives

At the end of the course participants will be able to:

• Understand Table Design in a practical context
• Understand and apply Field Properties
• Understand the major components of Form and Report Design
• Design customised Forms and Reports
• Create Calculated Fields within Queries
• Create and use Action Queries
• Create and use Multi-Table Queries
• Create Switchboards and Startup Forms
• Understand and use Auto lookup
• Exchange data with other applications
• Build Advanced Queries and increase Query performance
• Create complex Reports, incorporating sub reports and calculated controls
• Export data from Access in Excel

Project Overview

• Objects, Tables, Forms, Reports & Queries

Customising Tables

• Importing Tables
• Using Link Table
• Field Properties
• Standard and Custom Formats
• Format Properties for Number Formats
• The Input Mask Property and Wizard
• Indexes Window
• Copying Tables
• Relationships
• Relationship Types
• Foreign Keys
• Relationships Window
• Adding Tables
• Creating a One to Many Relationship

Creating Complex Forms

• Using Wizards to Create Forms
• Main/Subforms
• Creating a Linked Form
• Form Design
• Controls
• The Toolbox
• Lines and Rectangles
• Labels
• Text Boxes
• Layering Controls
• AutoFormat

Applied Form Design

• Control Wizards
• Creating a Combo box, Button and Option Groups
• Additional Design Tools
• The Field List
• Tab Order
• Property Sheets
• Builders
• Building Expressions using the Expression Builder
• Naming Controls

Using Wizards to Create Reports

• Grouping and Subtotalling in a Report
• Creating Mailing Labels
• Mail Merge using Microsoft Word

Report Design

• Design View
• Performing Calculations in Reports
• Dates and Times
• Combining Text Values
• Page Numbers
• Summary Calculations
• Sorting and Grouping in a Report
• Formatting a Report
• Embedding Images
• White Space

Applied Queries

• Creating and Formatting Calculated Fields
• Using Calculated fields in Combo Boxes
• Creating Action, Make-Table, Append, Update, Delete and Multi-Table Queries

Database Consolidation

• Using the Switchboard Manager
• Creating a Switchboard Form
• Creating a Startup Form
• Main/Subforms