Subscribe for access to this FREE e-learning mini-course!

Your First Name:

Your Surname:

Your Email Address:


Hamburger menu
bookings:   0333 6000 111
service:       0333 6000 555
Microsoft Access Advanced
Microsoft Access Advanced


The best source of Advanced Access Training Courses

A hands-on one-day course with free e-learning revision after your training and pre-course online skills testing. Free bespoke course design is also available for private classes if the content needs to be adjusted
See Our Latest Reviews on TrustPilot:
CPD accredited course

Note: this Access Advanced course is CPD certified.
It is available as either a classroom course with online revision, or an online course.
This means that not only has it been rigorously assessed in terms of content and quality, but it comes with a FREE CPD Certification certificate, as well as an Activia diploma of completion.
We are a corporate member of the CPD: the highest level of association available.


Full details of modules and topics covered in this one-day course


This course covers 2010, 2013, 2016 and Office 365 versions

Blended learning

Note: Free e-learning revision is available with this course: 12 months of access for each delegate on scheduled public (open) classes and standard on-site/private classes (not available for bespoke courses) .


This is a one-day training course structured into 6 modules


This intensive hands-on one-day training course has been designed to provide delegates with a solid understanding of advanced tools and concepts in Access in order to increase their knowledge and productivity.


Users with a solid understanding of MS Access 2007, 2010, 2013 or 2016 who want to expand on their capabilities in a short space of time. Some of the lessons are quite technical and delegates must have a good working knowledge and understanding of the concepts covered in the Introduction and Intermediate courses.

Want to see prices and options for delivery of your training?

MODULE 1:  Advanced Data Management
Learning outcomes:
A look into table relationships and referential integrity along with introducing SQL, the language database professionals use to manage a database.
Topics covered:
  • Referential Integrity
  • Table Relationships
  • An Introduction to SQL
  • Modal Dialog Boxes
MODULE 2:  Advanced Form Tasks
Learning outcomes:
Creating navigation forms and sub-forms along with some of the advanced form controls necessary to create a fully rounded user interface.
Topics covered:
  • Using Subforms
  • Creating a Navigation Form
  • Advanced Form Controls
  • Exporting a Form
  • Other Form Tasks
MODULE 3:  Automating Reports
Learning outcomes:
Create Reports in Access that can return data quickly by using a form to control and launch reports. Look at modifying form properties including combo boxes and link a query to a form.
Topics covered:
  • Creating the Report Form
  • Building Query Criteria
MODULE 4:  SQL and Microsoft Access
Learning outcomes:
Some of the basic and more advanced SQL commands here along with the concept of JOINS and sub-queries.
Topics covered:
  • Understanding SQL
  • Using the SELECT Statement
  • Using Subqueries
MODULE 5:  Automating With Visual Basic for Applications (VBA)
Learning outcomes:
Using Macros and Visual Basic to create some advanced functionality to your Access Database.
Topics covered:
  • Building Advanced Procedures
  • Access and VBA
  • Building Advanced Procedures
  • Using VBA in a Database
MODULE 6:  Finishing the Application
Learning outcomes:
Look at finishing touches to control how users interact with a database using start-up and sharing options. Identify security measures by creating an ACCDE and encrypting a database with a password.
Topics covered:
  • Setting Start Up Options
  • Sharing/Splitting the Database
  • Creating an ACCDE
  • Encrypting the Database with a Password

Want to see prices and options for delivery of your training?

Microsoft Access Advanced
Nov 13, 2019
Bristol Easton BS5
Book Now
Dec 11, 2019
Leeds West One
Book Now
Dec 18, 2019
Birmingham Queensway
Book Now
Dec 20, 2019
Tower Bridge
Book Now
Jan 15, 2020
Manchester Piccadilly
Book Now
Jan 24, 2020
London Victoria
Book Now

Don't see a date you want?


Access Introduction

[Duration: one day]

Access Introduction

  • Getting Started with Access
  • The New Ribbon Interface
  • Creating a Simple Database
  • Forms; Queries; Reports and Filters

Access Intermediate

[Duration: one day]

Access Intermediate

  • Advanced File Tasks
  • Working with Tables
  • Working with Forms
  • Working with Reports
  • Working with Queries



Helen Crawford
, Jul 17 2019
"Found the course very interesting and informative. The instructor was great and had a good understanding of the subject matter. He was able to answer questions in a clear manner. "

Course rating of 3 stars
Katherine Medhurst
, Mar 27 2019
"Wide range of activities covered. "

Course rating of 3 stars
Laura Manley
, Dec 12 2018
"The trainer was knowledgeable and understandable. He carefully followed the course outline and covered all the topics on the syllabus."

Course rating of 5 stars
Ana Johnson
, Feb 9 2018
"Would recommend Activia to other employee's and friends, good course with good trainers. "

Course rating of 4 stars
Carol Prior
, Dec 20 2017
"Dallas was an excellent trainer"

Course rating of 5 stars
Ash Dean
, Aug 25 2017
"I thought John was great - very knowledgeable and accommodating to my many questions!"

Course rating of 5 stars
Danielle Roseweir
, Jun 29 2016
"Gareth was a good trainer, very informative and took the time to ensure understanding and go over practical examples"

Course rating of 4 stars
Kay Sawbridge
, Mar 9 2016
"Trainer was very good, lunch was nice."

Course rating of 5 stars
, Jan 29 2016
"Good structure and a wide range of topics covered. "

Course rating of 5 stars
John O`Neill
, Aug 19 2015
"Small class size was good. "

Course rating of 3 stars
Joan Hibbert
, Aug 19 2015
"very good trainer"

Course rating of 5 stars
Tanya A'len
, Jun 24 2015
"John was an amazing trainer and clearly a subject matter expert. Thank you John!"

Course rating of 5 stars
Les Sayer
, Apr 9 2015
"The course and tutor were excellent."

Course rating of 5 stars
Miranda Loutet
, Apr 1 2015
"This was a very useful day for me."

Course rating of 4 stars
Mark Burton
, Feb 25 2015
"The trainer, Mark, was excellent and very helpful. "

Course rating of 5 stars
Shona Holmes
, Feb 25 2015
"The trainer Mark was very patient and helpful with a barrage of questions and happy to deviate from the lesson planner when the questions went off on a tangent. I highly recommend the course and the trainer. "

Course rating of 5 stars
Steve English
, Feb 11 2015
"I have done 'a lot' of courses over the years with many teachers / trainers and Gareth is right up there as one of the best. I felt we could ask him anything and he answered all our questions very well. Me and the other student had quite specific projects to do and Gareth was able to help us with how we would transfer the skills into the 'real world' and he also set us challenges to complete after completing the material to test our newly found skills which simulated our project requirements."

Course rating of 5 stars
Cliff Orme
, Nov 28 2014
"The tutor Gareth was excellent to learn from."

Course rating of 5 stars
Kristy Holland
, Sep 5 2014
"Very comfortable course, and the trainer was extremely knowleadgeable and helpful - kept taking me back a step when I was racing off, which means I have a more thorough knowledge than I otherwise would have!"

Course rating of 4 stars
Mr Imran Shah
, Jul 16 2014
"Excellent Tutor"

Course rating of 5 stars
Imran Shah
, Jul 16 2014
"Excellent tutor and enjoyed every minute"

Course rating of 5 stars


Blended learning
FREE Online Revision

With our latest Microsoft Access courses, you get free online revision for a full 12 months after your class so you can reinforce the knowledge you have gained.

Access is simple: go to and log in using your email address.   This will give you free access to our e-learning revision modules.

Note: These have been developed and written exclusively by Activia to maximise effectiveness, by matching the online content exactly to what you cover in class.   We hope you have fun, on the day of the course and with honing your knowledge afterwards!

General Information

All Activia advanced access training courses have been created, reviewed and developed to ensure up to date provision and constantly improving standards of content. Our Microsoft Access training is interactive and classroom-based which maximises learning through the ability to ask questions and discuss specific issues.

Class Sizes

Maximum class size for Microsoft Access courses is 8 delegates, which ensures that attendees get adequate time for personal attention from the instructor. At some of our centres, the maximum class size is 6 delegates.

Note that we never cancel our scheduled classes -- even if there are only one or two delegates -- so once you have booked, your place is assured.

For training at your offices, we can deliver classes of up to 10 delegates, though with bigger class sizes you must understand that there is less time for questions from delegates, and this may affect the quality of their experience.

How to book
Course, dates and delegate numbers
Decide on the Microsoft Access course you want, the date(s) you can attend, and the number of delegates involved
Training location
Also decide whether you want training at your offices or at one of our centres
Speedy course booking
You can use the Speedy Quote option to contact us for a quick price, or you can book online from the schedule on this website
Call us
if at any time you want help or advice, or you want to book on the telephone, just call us on 0333 6000 111 to speak to one of our friendly training advisors

Note: With non-credit card bookings you must sign and return a Booking Form before we can confirm your training.

Also note: If you are a private individual you must pay by credit card at the time of booking.

The confirmation process
Course places allocated
Your place is allocated, along with the trainer, workbooks and exercise files if appropriate
Booking confirmation
You receive an official confirmation, with joining instructions (and directions if it's at our centre)
Training invoice
You receive a VAT invoice

Note: Please allow 1 - 2 working days for your confirmation and invoice.

What happens on the day

If you are coming to our centre, dress code is smart casual.   Refreshments in the form of tea/coffee will be provided for morning and afternoon breaks, but please note that we do not provide lunch.   The timetable is as follows:













Note: break times can vary according to the needs of the training, and course duration for smaller class sizes are usually shorter because fewer delegates have fewer questions !

For training at your offices, this itinerary can be varied by prior arrangement.

What you get

With every Microsoft Access training course with Activia, you get a free workbook as well as downloadable exercises, which match the course content exactly, so you can review and revise afterwards to reinforce your knowledge. With all courses, you are also given 12 months access to free online revision which will further help you to reinforce the lessons you have learned.

Every delegate on a Microsoft Access course also gets an Activia Training Attendance Certificate.


Call us on:
0333 6000 111

   You can Email us direct (You'll usually get a response within 2-3 working hours)
   Or fill out the details below and we'll be in touch very soon:

Stay in touch

Back to top
Quick Links
More on This Page
Site Cookies
We have placed cookies on your device to help make this website better.

You can change your cookie settings in your browser. Otherwise, we’ll assume you’re OK to continue.

I'm fine with this