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

Other Access Training Courses

Access Introduction
Access Queries and Reports

StressLess Learning, Microsoft Access Training Experts