The MOS Access 2016 Essentials Online Course is designed for both students who are interested in gaining a broad knowledge of the Access application and for experienced Access users who wish to undertake a refresher course. The course follows the Microsoft Office Specialist (MOS) syllabus, and more, and is the ideal study guide for those wishing to gain the industry-recognised MOS certification.

Proficiency in Microsoft Office products is increasingly important in today's competitive business environment and, whether you are currently employed or a job seeker, Microsoft Office Specialist certification proves to employers and prospective employers that you have the necessary skills to become an important member of their team.

The MOS Access 2016 Essentials course teaches all you need to know about the major components of the Access 2016 application and is presented in a modern, multimedia, online format, with the constant support and guidance of your designated course tutor, who is there for you every step of the way.

The course contains valuable tips on preparing for the MOS examination and includes free access to the GMetrix range of MOS exam practice questions, which have the same format as the MOS exam itself.

Distance Learning Centre Online Training PortalBased on the proven "learn-by-example" principle which, as the name implies, provides real-world examples to illustrate a particular topic or technique, the courses are delivered through the Distance Learning Centre's highly-acclaimed on-line training portal via a standard web browser, such as Internet Explorer, Firefox, Chrome, Opera, or Safari. You will also be supported by a personal tutor who is available to provide feedback on your work at any time throughout the period of study.

The MOS Access 2016 Essentials Online Course consists of the following modules:

Lesson 1 - Creating and Managing Databases

  • Introduction;
  • The Access 2016 Application;
  • Creating & Modifying Databases;
  • Managing Relationships & Keys;
  • Navigating Through A Database;
  • Protecting & Maintaining Databases;
  • Printing & Exporting Data;
  • Lesson Review & Quiz;
  • Assignment 1 - Creating & Modifying Databases Exercises.

Lesson 2 - Building Tables

  • Introduction;
  • Creating Tables;
  • Managing Tables;
  • Managing Records In Tables;
  • Creating & Modifying Fields;
  • Lesson Review & Quiz;
  • Assignment 2 - Database Table Exercises.

Lesson 3 - Creating Queries

  • Introduction;
  • Creating Tables;
  • Managing Tables;
  • Managing Records In Tables;
  • Creating & Modifying Fields;
  • Lesson Review & Quiz;
  • Assignment 2 - Database Table Exercises.
Lesson 4 - Creating Forms
  • Introduction;
  • Creating Forms;
  • Configuring Form Controls (1);
  • Configuring Form Controls (2);
  • Formatting Forms;
  • Lesson Review & Quiz;
  • Assignment 4 - Forms Exercises.
Lesson 5 - Creating Reports
  • Introduction;
  • Creating Reports;
  • Configuring Report Controls;
  • Formatting Reports;
  • Lesson Review & Quiz;
  • Assignment 5 - Report Exercises;
  • The MOS Examination.

Click here for a detailed list of all content covered in the course.

Free GMetrix Exam Preparation Software:

The course also comes with GMetrix exam preparation software. The GMetrix Skills Management System provides everything you need to prepare for the Microsoft Office Specialist (MOS) Certification.

Overview of Test features:

  • Practice tests map to the Microsoft Office Specialist (MOS) exam objectives.
  • All tests are in-application or performance-based simulations to provide the best assessment of real-world experience.
  • All tests have both a testing and a training mode providing step-by-step help on each question.
  • Progress at own pace, save test to resume later, return to skipped questions.
  • Detailed, printable score report highlighting areas requiring further review.

Please Note: You will need a version of Microsoft Office 2016 to be able to use the GMetrix software package.


There are no particular entry requirements as the course is set out for beginners, although students will require their own version of Microsoft Access 2016 to complete the course.

Please Note: The course covers the use of Microsoft Access 2016, which is a PC version of the software. It will be possible to view the course materials using an Apple Mac although the information within the course will be specific to the PC version of Microsoft Office, which will differ from Mac versions.

Course Duration & Support:

Students may register at any time and have a full year to complete their studies. You also have access to a personal tutor by mail or email for a 12 month period. Course extensions can be purchased if you do not complete this course within the 12 month period. As the course is self-study you can complete in as little or as long a time as you prefer.


You will be assessed on assignments which are detailed in the course materials. These assignments will require you to create work on, create and edit database files. Your work can be sent back to your course tutor by email.


MOS Access 2016 Online CourseOn successful completion of this course students will receive our Access 2016 Essentials Certificate of Completion with feedback from your tutor, and students can also apply for the Microsoft Office Specialist (MOS) 77-730 exam.

Examinations must be sat at a registered Certiport Testing Centre. Exam vouchers (Valid for 12 Months) can be purchased from our website for £90.00. We usually advise buying a voucher when you are ready to sit your test, although you can add this to your order when you purchase your course.

Students can locate testing centres and schedule appointments on the Certiport Website by following the Test Candidates > Locate a Testing Centre links.

Please Note: Exam Centres will usually charge an additional proctoring fee (Approximately £15.00) for sitting exams.

View Testimonials
Submit a Testimonial