Description
If you are a student who is interested in gaining a wider knowledge of the Access application or an experienced Access user who wishes to undertake a refresher course, the MOS Access 2019 & 365 Expert online course is the course for you. The course is an ideal study guide for those wishing to gain the industry-recognised MOS Access Expert certification, as the course follows the MOS syllabus.
Whether you are currently employed or a job seeker, Microsoft Office Specialist certification proves to employers and prospective employers alike 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 consists of the following modules:
MOS Access 2019 & 365 Expert Fact Sheet
- Introduction;
- Modifying Database Structure;
- Managing Table Relationships & Keys;
- Printing & Exporting Data;
- Lesson Review & Quiz;
- Assignment 1 – Creating & Modifying Databases Exercises.
- Introduction;
- Creating Tables;
- Managing Tables;
- Managing Records In Tables;
- Creating & Modifying Fields;
- Lesson Review & Quiz;
- Assignment 2 – Database Table Exercises.
- Introduction;
- Creating & Running Queries (1);
- Creating & Running Queries (2);
- Modifying Queries;
- Creating Calculated Fields & Grouping;
- Lesson Review & Quiz;
- Assignment 3 – Query Exercises.
- Introduction;
- Configuring Form Controls (1);
- Configuring Form Controls (2);
- Formatting Forms (1);
- Formatting Forms (2);
- Lesson Review & Quiz;
- Assignment 4 – Forms Exercises.
- Introduction;
- Configuring Report Controls;
- Formatting Reports;
- Lesson Review & Quiz;
- Assignment 5 – Report Exercises;
- The MOS Examination.
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 the real-world experience.
- All tests have both a testing and a training mode providing step-by-step help on each question.
- Progress at your own pace, save the test to resume later and 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.
Prerequisites
There are no particular entry requirements as the course is set out for beginners although students will require their own version of Microsoft Excel 2019 or Microsoft Excel 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.
Online Course Format
Based 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 our online training portal via a standard web browser, such as Internet Explorer, Firefox, Chrome, Opera, or Safari. The lesson notes are delivered through slides giving you the required information to work through each lesson and there are student files you will download to work on so you are putting into practice what you are learning. 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.
Assessment
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 Microsoft Access documents. Your work can be sent back to your course tutor by email.
MOS Access 2019/365 Expert Certification
Upon 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 2019/365 Expert MO-100 exam.
Examinations must be sat at a registered Certiport Testing Centre. You should choose the Program, Version and Exam before adding your location to a list of suitable exam centres.
Exam vouchers (Valid for 12 Months) can be purchased from our partner website for £96.00. We usually advise buying a voucher when you are ready to sit your test.
MOS Exam Voucher (Optional) – £96.00
All students have the option to purchase MOS Exam Vouchers for £96.00 which will cover the cost of the exam at participating exam centres. A voucher would be required for each MOS exam you sit. An additional proctoring fee will need to be paid to the exam centre for each exam.
Please Note: It is the student’s responsibility to source suitable exam centres. We advise researching exam centres prior to purchasing an exam voucher to make sure a suitable participating exam centre is available.
Please Note: Exam Centres will usually charge an additional proctoring fee (Approximately £15.00) for sitting exams.
