Microsoft Access Advanced

Course Duration is 1 Day

£295.00 Plus VAT (per person)

Have more than 2 delegates? Talk to us about our closed group courses.

Delivery Method

Open Public Courses РVirtual Delivery Only  Closed Group Courses РFace To Face and Virtual Delivery

Business Benefit

The use of advanced queries and macros will ensure that your Access databases will be more users friendly and run more efficiently.

Who Should Attend

This course is valuable for anyone who plans to prototype, build and integrate relational databases using Access to an advanced level.

Learning Outcomes

Create Cross Tab Queries
Create Make Table Queries
Modify Start-up options
Create Macros on Forms
Create Macros on Reports
Create Database Macros
Compact and Repair Databases
Database Password Protection
Split a Database

Course Content

Cross Tab Queries
Make Table Queries
Change Start-up Form
Database Switchboards
Create Macros
Understand Form Events
Understand Report Events
Create Autoexec & Autokeys Macros
Compacting Access Databases
Adding Password Protection To Databases
Creating Frontend / Backend Databases

How to Book

Dates below represent open public courses only. To book this course, please select an available date and click the book now button below to complete the booking. Have two or more people to train – you may consider a closed group course. Contact us on [email protected] to discuss specific date and delivery requirements.


Measuring The Success


The purpose of your training is learning new skills and/or changing behaviour. We can help you measure this!

To evaluate how successfully the attendees are doing this, delegates can attend a Workplace Implementation session during the skills transfer period. The cost of the session is £595+VAT delivered virtually and lasts for 2.5 hours.

During the Workplace Implementation session the individuals will either on a 1-2-1 basis or as a group discuss the challenges and successes they have experienced during their skills transfer period.
This will include what they are doing differently as a direct result of the training and how this has positively impacted the organisation.
This is an excellent way to encourage the learning, support the skills transfer into the workplace and act as a measure to evaluate the training.

We compile this information into a report so that you have evidence of your return on investment.