MO-500 Access Expert
(365 Apps & Office 2019)
MO-500 Microsoft Access Expert
(365 Apps & Office 2019)
What the MOS MO-500 Exam Measures
The MO-500 Microsoft Access (Office 365/2019) exam measures your skills in using Microsoft Access at an EXPERT level.
Specifically, this exam is designed to evaluate candidates' fundamental database skills, including designing and managing databases, creating tables, designing queries, building forms and generating reports.
Candidates are expected to demonstrate their ability to apply features of Microsoft Access to various scenarios.
Preparing for the MO-500 exam requires you to become expert in the principal features of relational databases using Microsoft Access. This process of studying and practicing using our course will significantly enhance your expertise in Access and ensure your success in the certifiation exam.
This exam measures the students expertise in the following principal areas of Microsoft Access:
What the MOS MO-500 Exam Measures
The MO-500 Microsoft Access Expert exam measures your skills in using Microsoft Access (365 Apps and Office 2019) at an advanced level.
Specifically, this exam is designed to evaluate candidates' fundamental database skills, including designing and managing databases, creating tables, designing queries, building forms and generating reports.
Candidates are expected to demonstrate their ability to apply key features of Microsoft Access to various scenarios.
Preparing for the MO-500 exam requires you to become expert in relational databases using the features of Microsoft Access.
This exam measures the students expertise in the following principal areas of Microsoft Access:
Create and Manage a Database.
Build Tables.
Create Queries.
Create Forms.
Create Reports
Click the button below to download the MO-500 skills as measured by Microsoft in the exam
MO-200 Excel Associate (Office 2019) Courses
MOS University Course
MOS University provides a comprehensive course designed to prepare you for success in the Microsoft Access Expert (MO-500) Certification exam.
The course includes video lectures explaining all of the features of Microsoft Access (365/2019) together with exercises and solutions.
The course also features a complete sample exam with video solutions which will ensure that you can be
100% Confident Of Your Success at the 1st Attempt.
MO-500 Microsoft Access Expert (365/2019) Complete Techniques
MO-500
Microsoft Access Expert
(Office 365/2019)
Complete Techniques
MO-500 Learning Objectives
 |
Be confident in your preparation to pass the MO-500 Microsoft Certified Expert Access (365/2019) Exam. |
|
Be familiar with every aspect of the skills required for the MO-500 Exam. |
|
Understand the way that project tasks are posed in the MO-500 Certification exam. |
|
Obtain independent proof of your skills and assure potential employers of your expertise in the advanced features of Microsoft Access Expert (365/2019). |
Who Should Take These Courses?
 |
This course is best suited to students who want to obtain independent certification from Microsoft that they have achieved expert level in the use of Microsoft Access (365/2019). |
|
The course is designed for both novice and experienced database users who want to obtain expert certification in Access (365/2019). |
|
Existing users of Access who want to have access to the types of project tasks which will ensure that they pass the Microsoft Office Expert Access (365/2019) exam. |
|
Graduates seeking to gain professional qualifications. |
MO-200 Microsoft Excel 2019
Complete Techniques
MO-200 Microsoft Excel 2019
Practice Exams
Two Course Bundle: Complete Techniques and Practice Tests
MO-200 Course Details
MO-200 Microsoft Excel 2019
Complete Techniques for the MO-200 Associate Certificate Exam
Why Study with MOS University
Catering to students at all levels, these courses cover every possible aspect of the Microsoft Excel 2016 Core syllabus.
Exam preparation online sessions exploring student questions.
Learn at your own pace and be assured of our support throughout.
These courses cover all of the essential Microsoft Excel 2019 Core techniques AND provide you with the opportunity to practice using practice quetions set to the style and standard of the actual test.
Comprehensive exercise pack with complete video solutions.
This course is guaranteed to teach you all the techniques required for the MO-200 exam AND prepare you for the requirements of the exam so that you can pass the exam on your first attempt.
'Try It Yourself' exercises with virtually all lectures will ensure your understanding as the course progresses.
Microsoft Access Expert (365/2019)
MO-500
Complete Techniques Course Content
MO-500 Microsoft Access
(Office 365/2019)
Complete Techniques
Course Content
Introduction
Course Introducton
Create and Manage a Database
Manage database structure.
Manage table relationships and keys.
Print and export data.
Exercises and Solutions
Create and Modify Tables
Create tables.
Manage tables.
Manage table records.
Create and modify fields.
Exercises and Solutions
Create Queries
Create and run queries,
Modify queries.
Exercises and Solutions.
Modify Forms in Layout View
Configure form controls.
Format forms.
Exercises and Solutions.
Modify Reports in Layout View
Configure report controls.
Format reports.
Exercises and Solutions
Sample Exam
Sample Exam Project 1.
Sample Exam Project 2
Sample Exam Project 3.
Sample Exam Project 4.
Sample Exam Project 5.
Sample Exam Project 6.
Optional Extras
Create a blank database.
Create a database from a template.
Compact and repair a database.
Back-up a database.
Split a database.
Encrypt a database.
Recover data from back-up.
Create a table.
Calculated fields.
Create a form.
Create a form from a database with application parts.
Create a report by using the report wizard.
Sample Course Videos
Enfore Referential Integrity (Access 365/2019)
Create Cross Tab Queries(Access365/2019)
Student Reviews
Microsoft Access Expert
MO-500
(Office 365/2019)
The really nice thing about this course is that I continually use it when I hit a problem with Access. The material is well organized and explained. Super course.
Mark
77-730 Microsoft Access
(Office 2016)
Strongly recommend this course.
I bought the 77-727, 77-728 and 77-730 courses and I truly believe the expertise, skills and the short response time to any questions I had were key factors in my success in passing both the Excel and Access Microsoft Exams
Peter
77-730 Microsoft Access
(Office 2016)
The course was a good match because the Instructor knows exactly what is required for students to Pass the 77-730 Exam.
He knows his stuff and explains it with passion and clarity.
Explanations are excellent and the practices ensure that you're confident going into the exam.
Passed 90%
Student Reviews
Microsoft Access Expert
MO-500
(Office 365/2019)
The really nice thing about this course is that I continually use it when I hit a problem with Access.
The material is well organized and explained.
Super course.
Mark
Microsoft Access Expert
MO-500
(Office 365/2019)
Strongly recommend this course.
Covers every aspect of the MO-500 certification exam.
Passed with ease.
The practice exam was extremely close to the mark!
Mary
Microsoft Access Expert
MO-500
(Office 365/2019)
Excellent delivery in easy to follow lectures.
I particularly like the sample exams.
I was very confident going into the exam.
Passed 90%
77-727 Certification Bundle
Here are all the courses that are included in your bundle
Comprehensive Tuition for the 77-727 Excel 2016 Core Certification Exam
2 courses designed to prepare you for success in the MOS Excel Core Certification exam!
Be 100% Confident Of Your Success.
 |
 |
 |
© 2025 BowTieLearning Ltd. All Rights Reserved
Contact Us: [email protected]