Skip to content

Microsoft Office Specialist (MOS) Access 2019 & 365 Expert Online Course



Microsoft Office Specialist (MOS) Access 2019 & 365 Expert Online Course


The MOS Access 2019 & 365 Expert Online Course is designed for both students who are interested in gaining a wider knowledge of the Microsoft Access application and for experienced Microsoft Access users who wish to undertake a refresher course.

The course follows the Microsoft Office Specialist (MOS) Expert 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 Access 2019 & 365 Expert course teaches all you need to know about the more advanced components of the Access 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.




The MOS Access 2019 & 365 Expert Course Includes the Following Units:

Unit 1: Managing Databases

The following topics are covered:

  • Introduction;
  • Modifying Database Structure;
  • Managing Table Relationships & Keys;
  • Printing & Exporting Data;
  • Lesson Review & Quiz;
  • Assignment 1 – Creating & Modifying Databases Exercises.
Unit 2: Creating & Modifying Tables

The following topics are covered:

  • Introduction;
  • Creating Tables;
  • Managing Tables;
  • Managing Records In Tables;
  • Creating & Modifying Fields;
  • Lesson Review & Quiz;
  • Assignment 2 – Database Table Exercises.
Unit 3: Creating & Modifying Queries

The following topics are covered:

  • Introduction;
  • Creating & Running Queries (1);
  • Creating & Running Queries (2);
  • Modifying Queries;
  • Creating Calculated Fields & Grouping;
  • Lesson Review & Quiz;
  • Assignment 3 – Query Exercises.
Unit 4: Modifying Forms in Layout View

The following topics are covered:

  • Introduction;
  • Configuring Form Controls (1);
  • Configuring Form Controls (2);
  • Formatting Forms (1);
  • Formatting Forms (2);
  • Lesson Review & Quiz;
  • Assignment 4 – Forms Exercises.
Unit 5: Modifying Reports in Layout View

The following topics are covered:

  • Introduction;
  • Configuring Report Controls;
  • Formatting Reports;
  • Lesson Review & Quiz;
  • Assignment 5 – Report Exercises;
  • The MOS Examination.

Key Information



Course Format

Self-study Time

Delivery Time



Approximately 80 Hours (Self-Study)

1-2 Working Days (Email)


GMetrix Test Prep 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 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 2019 or Microsoft Access 365 to complete the course.

Please Note: This course covers the PC versions of Microsoft Access 2019 and Microsoft Access 365. 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 and will differ slightly from the Mac versions.


Course Duration & Online Support

You can start this course at any time, and you would be registered for a one-year period. You also have access to a personal tutor who can be contacted by email. Your tutor is available to assist with any queries and to mark your assignments.

As the course is self-study, you can complete it as quickly as you like. Support extensions are available if students do not complete the course within the one-year period.



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


MOS Office 2019/365 Certification

On successful completion of this course students will receive our Microsoft Access 2019 and 365 Expert Certificate of Completion with feedback from your tutor, and students can also apply for the Microsoft Office Specialist (MOS) Access Expert MO-500 exam.

Examinations must be sat at a registered Certiport Testing Centre. You should choose the Program, Version and Exam before adding your location for a list of suitable exam centres.

Exam vouchers (Valid for 12 Months) can be purchased 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.

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


who can I contact for more information?



Call Chris Dolman on 01482 211714




Register your interest and we will contact you

Skip to content