Advanced Microsoft Access

Course Details

This course is for anybody wanting to learn additional advanced Microsoft Access skills and looks at Microsoft 365 but also looks at previous versions, of 2016, 2013, 2010 or 2007, as it covers all the aspects and differences between the versions. It helps delegates improve their knowledge and skills to ensure that they can maximise the full use of MS Access.


To ensure success, delegates should have completed our Basic and intermediate Microsoft Access courses or are familiar with the topics in these courses

Benefits to you

By the end of the course, participants will be able to:

  • Understand advanced functions of Microsoft Access

Course Contents

  • Introduction
  • Ribbons
  • Relating Tables
  • Defining Table Relationships
  • One-to-One Relationships
  • Join Types
  • One-to-Many Relationships
  • Referential Integrity
  • Many-to-Many Relationships
  • Using the Lookup Wizard
  • Setting Cascade Deletes
  • Testing Cascade Deletes
  • Update Cascades
  • Entering Data into Related Tables
  • Modifying Lookup Fields
  • Value List & Combo Box
  • Input Masks
  • Creating an Input Mask for a Combo Box in Form View
  • Input Mask in Form View
  • Setting Field Properties
  • The AllowZeroLength Property
  • Validation Rules
  • Validation Text Property
  • Advanced Queries (Outer & Inner Joins)
  • Creating Calculated Fields
  • Formatting Calculated Fields
  • Using the Expression Builder
  • Using Action Queries
  • Summarising & Grouping Values
  • Concatenation
  • Crosstab Queries
  • Parameter Queries
  • Sub Forms/Linked Forms
  • Advanced Control Toolbox Forms
  • Macros & Events
  • Switchboards

Who should attend?

Anybody wanting to learn advanced Microsoft Access functions