MOS Access 2019 and 365 Expert

• Introduction
• Modifying database structure
• Managing table relationships and keys
• Printing and exporting data
• Lesson review and quiz
• Assignment 1 – creating and modifying databases exercises

• Introduction
• Creating tables
• Managing tables
• Managing records in tables
• Creating and modifying fields
• Lesson review and quiz
• Assignment 2 – database table exercises

• Introduction
• Creating and running queries
• Modifying queries
• Creating calculated fields and grouping
• Lesson review and quiz
• Assignment 3 – query exercises

• Introduction
• Configuring form controls
• Formatting forms
• Lesson review and quiz
• Assignment 4 – forms exercises

• Introduction
• Configuring report controls
• Formatting reports
• Lesson review and quiz
• Assignment 5 – report exercises
• The MOS examination

You must have Microsoft Access 2019 to complete this course. The course covers the use of either Microsoft Access 2019 or 365 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 differs slightly.

You will have up to 1 year to complete your course. The course study time should take approximately 80 hours, so 1 year will allow flexible learning. You can complete your course in as little or as much time as you like.

Your course will be studied online, so you have access to your course materials through an online training portal. You will have access to your personal tutor support throughout your course through email, so help is available at any point.

GMetrix Skills Management System is also included in your course, which will allow you to practice for your exam effectively.

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.

Your assignments will involve you completing Access based assignments to present your understanding of the course. You will need to submit your assignments online to your tutor. These will be marked and returned to you.

This course prepares you for the official Microsoft Office Specialist (MOS) Word Expert MO-500 exam. If you want to take the exam to receive the full official qualification, you will need to book and pay for this separately. They must be sat at a registered Certiport Testing Centre.

Upon successful completion of this course, you will able to use it towards your university application. We recommend that you check with your chosen University that they accept this qualification as part of their entry requirements. If after, you’re looking to enhance your IT knowledge even further, take a look at the other IT and computer courses we offer.

Here are some job titles that frequently use Microsoft Office:

• Administrative assistant
• Data entry clerk
• Human resources assistant
• Project coordinator
• Marketing coordinator
• Executive assistant
• Customer service representative
• Financial analyst
• Sales coordinator
• Event planner