Sign up for access to this FREE e-learning mini-course!

Your Email Address:   

Sign Up
Small logo
Hamburger sub menu
Hamburger menu
bookings:   0333 6000 111
service:       0333 6000 555

Microsoft Access Intermediate

Microsoft Access Intermediate


The best solution for Access 2013 Courses

A hands-on one-day course with free pre-course online skills testing. Free bespoke course design is also available for private classes if the content needs to be adjusted
Need PRICES or DATES?  See the blue link buttons on the right  >>>

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


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 or 2013 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.

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

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
  • Macros and Visual Basic for Applications (VBA)
  • Finishing the Application



Beverley Dean, Feb 21 2017
Course rating of 4 stars "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. "

John Routley , Feb 14 2017
Course rating of 5 stars "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."

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

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

Abigail Rowlatt, Aug 2 2016
Course rating of 3 stars "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."

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

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

Garry Brooks, May 3 2016
Course rating of 3 stars "Tutor had an excellent in-depth knowledge of Access and was very helpful with questions"

Katie Marsh , Apr 21 2016
Course rating of 5 stars "Very friendly trainer who was very knowledgeable."

Lynne McLaughlin, Mar 15 2016
Course rating of 5 stars "I found Gareth to be an amazing tutor. He explains things in a way that makes it very easy to understand. He is also very welcoming and friendly which made me feel more comfortable during the sessions."

Sian Freeman , Mar 8 2016
Course rating of 4 stars "The course was beneficial and enjoyable. The trainer was interactive and helpful. "

Andrew Sexton, Mar 8 2016
Course rating of 4 stars "Training was very informative"

Charlotte Miller , Feb 16 2016
Course rating of 5 stars "My Trainer was amazing. Would love to have her again for my advanced. "

Timothy Robinson, Nov 3 2015
Course rating of 5 stars "Really appreciated the course trainer Steve training methods."

John Councer, Jun 2 2015
Course rating of 4 stars "Small group size made for good interactive session"



General Information

All Activia access 2013 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 workbooks (and lunches if it's at our centre)
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 and a free buffet lunch will be provided, but please note that, as a training company who relies on caterers, we are unable to reliably provide for differing dietary requirements, so if you are in any doubt then please bring your own.   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 itenerary 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.

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:


We can enhance your skills with training course in MS Access 2013 at any of our twelve training centres UK wide, or we can come to your offices: if you have groups of three or more staff who need training, this is a very convenient, flexible and cost effective option. Moreover, most of our access 2013 courses are 1 day, which keeps "out of office" periods for attendees to a minimum.

We have been delivering access intermediate all over the UK since 1995 and have continually developed our philosophy of high quality, flexible and results-driven provision of courses for Access 2013 to ensure constantly improving standards of quality.   So you can be confident that we have the expertise, and the experience, to give you a great return on your investment in Courses for Access 2013 from Activia.

Why not contact us today to see how we can help with providing your MS Access 2013 classes ?

Stay in touch

Stay In Touch!


Contact Details

Activia Training

Locations Address: Head Office, Regus House,
268 Bath Road
Slough, Berkshire SL1 4DX

Phone Sales:           0333 6000 111

Service:       0333 6000 555

Accounts:   0333 6000 777

Back to top
Quick Links
More on This Page