Microsoft Access Advanced

Course Duration is 1 Day

£295.00 Plus VAT

Delivery Method

Face To Face Delivery  Virtual Delivery One To One Coaching Closed Group Course Public Course

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

If you are interested in booking this course, then please select an available date and then click book now to complete the booking. Can’t see a suitable date contact us on [email protected] and we can discuss specific date requirements.


These follow up coaching sessions help support your colleagues to embed their learning during their skills transfer period.  Applying new skills and changing behaviour takes effort and practice.  After attending a training course many colleagues will find they need support through this transition.  EQV can provide that support with follow up coaching sessions to help embed the learning.

Embedding coaching sessions can be delivered in 90 minute and half day durations.  The facilitator will work with the group to capture feedback about challenges and how to overcome them ensuring success going forward.

Having a formal embedding coaching session will not only increase the success of the skills transfer period but helps create a platform of motivation, inclusivity and commitment within the group.