For training call +44(0)1273 6222 72

Your basket is empty View Cart shopping cart

Microsoft Access Masterclass Training

Steve understood exactly what I was trying to do. the course was personalised and progressive - excellent step by step method.

Andie Davidson - Mecmesin Ltd

MAKE AN ENQUIRY Download Course Outline

Many organisations have large databases in Access that have built up over the years; staff have learned enough to build a database with a good relational structure, create forms to enter data and write queries to generate some useful reports.

Advanced Microsoft Access Training

However, when databases get big making your queries and forms effective can become more complex and it is worth investing in Microsoft Access Masterclass training to get the most from your data and save time.

Our Microsoft Access Masterclass course teaches delegates how to analyse data by creating complex queries, make forms and reports more efficient, speed repetitive tasks by creating macros.

If you are a looking for training specific to your business, we can provide private and in-company Microsoft Access Courses. Call us on +44 (0)1273 622272 to discuss your needs.


There are no prerequisites for this course. 

Course Objectives

By the end of this MS Access Masterclass training course, delegates will be able to:

  • Demonstrate an advanced understanding of Microsoft Access
  • Design advanced queries, forms and reports
  • Use macros to increase productivity and perform advanced functions

Course Feedback

Great teaching - very enjoyable & helpful.

Claire Thackway, Brighton College

Feel I have had a rounded introduction to Access, which is exactly what I required from the course. Very friendly and patient trainer who ran the course at a flexible pace

Paul Clarke - Hampshire Probation Trust

Microsoft Access Masterclass Training Course Content


  • Review of basic concepts:
  • Design concepts
  • Relationships between tables

Designing Queries

  • Using And and Or statements
  • Totals Queries
  • Creating calculations in queries
  • Parameter Queries
  • Autolookup Queries

Designing Forms

  • Adding controls
  • Working with combo boxes
  • Working with calculated controls
  • Control properties
  • Working with subforms

Report Design

  • Creating a report using the Wizard
  • Designing grouped reports
  • Adding sub-totals to reports


  • Creating simple macros
  • Creating grouped macros
  • Creating conditional macros
  • Assigning macros to command buttons
  • Creating a Switchboard
  • Using macros to pass conditions between forms
  • Using macros to pass conditions to run reports


* Required

For in-company or private training please request a quote


Course Details

  1. Course Title

    Microsoft Access Masterclass Training

  2. Duration

    1 Day

  3. Price Starting From

    £544.00 + VAT

Upcoming Dates

Onsite Training

This course can be run in-company anywhere in the world & we can tailor the content to focus on your requirements.

We regularly provide training in London, Manchester, Bristol and all over the United Kingdom.

Who is this course for?

This course is aimed at Microsoft Access users who want to expand their knowledge to include advanced techniques and macros.

Looking for Online Training?

AgilePM, PRINCE2® & MSP® eLearning

A flexible, cost-effective way to gain your AgilePM, PRINCE2 & MSP qualifications online with our APMG accredited AgilePM eLearningPRINCE2 eLearning & MSP eLearning packages.

ITIL®, PRINCE2®, PRINCE2 Agile®, MSP®, M_o_R®, P3O®, MoP®, MoV® courses on this website are offered by The Knowledge Academy, ATO of AXELOS Limited. ITIL®, PRINCE2®, PRINCE2 Agile®, MSP®, M_o_R®, P3O®, MoP®, MoV® are registered trade marks of AXELOS Limited. All rights reserved.