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 Intermediate
Microsoft Access Intermediate


The best source of Intermediate Access 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 Intermediate 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 5 modules


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


Users with a basic understanding of MS Access 2007, 2010, 2013 or 2016 who want to consolidate and expand on their knowledge of the basic features in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction course.

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

MODULE 1:  Advanced File Tasks
Learning outcomes:
A look at some important administrative features necessary for managing an Access Database file.
Topics covered:
  • Using Windows Explorer within Access
  • Database Management
  • Saving Your Files
  • Exporting Files
  • Linking Files
MODULE 2:  Working with Tables
Learning outcomes:
Further developing an understanding of tables, looking deeper into a table's properties fine tuning data types and use data validation.
Topics covered:
  • Customising Tables
  • Table Properties: Formatting
  • More Table Properties
  • Data Validation and Lookup Wizard
MODULE 3:  Working with Forms
Learning outcomes:
Building professional forms to enhance the user experience and improve effective use.
Topics covered:
  • Basic Form Controls
  • Advanced Form Controls
  • Formatting Your Form
  • Formatting Controls
  • Using Themes
MODULE 4:  Working with Reports
Learning outcomes:
Organise and format your reports professionally and common report tasks you may need to perform.
Topics covered:
  • Organizing Report Data
  • Formatting Reports
  • Common Report Tasks
MODULE 5:  Working with Queries
Learning outcomes:
Creating a range of different queries from very basic queries through to management queries with advanced functionality.
Topics covered:
  • Basic Queries
  • Doing More with Queries
  • Creating Advanced Queries
  • Creating Management (Action) Queries

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

Microsoft Access Intermediate
Oct 31, 2019
Leeds West One
Book Now
Nov 5, 2019
Tower Bridge
Book Now
Nov 7, 2019
Birmingham Queensway
Book Now
Nov 12, 2019
Bristol Easton BS5
Book Now
Nov 21, 2019
Manchester Piccadilly
Book Now
Nov 26, 2019
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 Advanced

[Duration: one day]

Access Advanced

  • Advanced Data Management
  • Advanced Form Tasks
  • Automating Reports
  • SQL and Microsoft Access
  • Automating With Visual Basic for Applications (VBA)
  • Finishing the Application



Laura Jacobs-Howe
, Jan 17 2019
"Great pace and structure"

Course rating of 5 stars
Sarah Howden
, Jan 17 2019
"The trainer was very good and knowledgeable and was happy to answer any questions around the course and how we may be using this application in our Business"

Course rating of 5 stars
Ann Holland
, Oct 30 2018
"Excellent trainer who was able to adapt what we were going through to specific issues we all had. Have attended other IT courses at different places and the trainer can really make the difference to how much you get out of the course. Can't recommend the trainer enough."

Course rating of 5 stars
Samuel Yip
, Oct 30 2018
"The trainer was excellent and went through the course content sufficiently and made the day interesting."

Course rating of 5 stars
Stephen Almond
, Sep 25 2018
"Useful for work"

Course rating of 5 stars
Melissa Stansfield
, Jul 26 2018
"Tutor was very knowledgeable and answered questions above and beyond the course content which was greatly appreciated"

Course rating of 4 stars
Marie Gilmore
, Oct 31 2017
"I really liked the Trainer, he was very good and very thorough "

Course rating of 5 stars
Annie Anderson
, Oct 17 2017
"Very clear instructions during the course"

Course rating of 4 stars
Sue Calladine
, Jul 25 2017
"For both courses the Introduction and Intermediate Access courses were very useful and on both I was the only delegate. Which gave me a lot more time to ask about specific items relating to my work situation."

Course rating of 5 stars
Nicola Parrott
, Jul 19 2017
"Excellent training by Rob. Pace and content exactly what I was hoping for."

Course rating of 5 stars
Alison Osborn
, Jul 17 2017
"Great tutor - really helpful and the small class was great."

Course rating of 5 stars
Kamila Broniszewska
, Jul 6 2017
"Great training - easy to understand and follow. The trainer has answered all questions thoroughly without compromising the time allocated to cover all topics. "

Course rating of 5 stars
Patricia Velasco
, Jul 6 2017
"Great training, well structured and easy to follow. The trainer has taken time to answer all questions thoroughly without compromising the time to cover all material. "

Course rating of 5 stars
Hector Albeiro Gonzalez Hernandez
, Jul 6 2017
"Thank you for the great training, it was very outstanding."

Course rating of 4 stars
Beverley Dean
, Feb 21 2017
"Thank you for all your help with this training, it has been successful and will help me in many ways to progress my database. Thanks to Steve, the teacher from Activia. "

Course rating of 4 stars
John Routley
, Feb 14 2017
"Our course tutor Tracey was excellent and once she knew our requirements she tailored the course to suit both our needs and our knowledge of Access."

Course rating of 5 stars
Jade Tracey
, Jan 17 2017
"The facilitator is brilliant."

Course rating of 4 stars
Kay Blischke
, Nov 15 2016
"Great to get a one on one experience."

Course rating of 4 stars
Abigail Rowlatt
, Aug 2 2016
"As the only attendee I enjoyed being able to ask specific questions and have a one-on-one with a skilled trainer. She also took in to account what I said I was already familiar with and made a point not to go too detailed in these areas."

Course rating of 4 stars
, Jun 28 2016
"Thank you and I would like to thank Mr.Gareth for his support and for passing on his knowledge in an effective way."

Course rating of 5 stars
Sam Roake
, May 31 2016
"Friendly atmosphere, good all round"

Course rating of 4 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 intermediate access 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