MO-500 Microsoft Access Expert Certification

Description

This course will prepare you to successfully pass the MO-500 Microsoft Access Expert certification exam. The MO-500 is the only exam officially recognized by Microsoft for Access 365 Apps and Access 2019. Every aspect of the exam is covered in detail, together with exercises and solutions. If you take this course and follow the guidelines provided, you will enhance your chances of obtaining this extremely valuable qualification. Prove your database skills by obtaining independent certification from Microsoft. The course is designed to ensure that you are familiar with all the techniques specified by Microsoft for the MO-500 Objective Domain (Syllabus). Every aspect of the requirements specified by Microsoft is comprehensively covered using video lectures together with appropriate exercises designed to ensure your understanding of the database techniques covered in each of the lectures. The exercises have been designed so that when you take the actual exam, you will be fully prepared for the standard and style of the projects and tasks set by Microsoft. By the end of this course, you will be well prepared for your MS-500 exam. All the resources are available at: https://github.com/PacktPublishing/MO-500-Microsoft-Access-Expert-Certification

What You Will Learn

Learn how to manage databases
Learn how to create and modify tables
Learn how to create, run, and modify queries
Learn how to modify forms in layout view
Learn how to modify reports in layout view
Solve seven sample exams

Audience

This course is suitable for beginners and designed for all students who wish to obtain the Microsoft Access MO-500 Expert Certification. No prior knowledge is assumed; just Microsoft Access 2016 or Microsoft Access 365/2019 is required for practice.

Approach

The course is designed to ensure that you are familiar with all the techniques specified by Microsoft for the MO-500 Objective Domain. Every aspect of the requirements specified by Microsoft is comprehensively covered with appropriate exercises designed to ensure your understanding of the database techniques covered in each of the lectures. We will also cover several sample exams for practice.

Key Features

Learn all the techniques specified for the Microsoft Access Expert MO-500 Certification Exam * Learn how best to prepare to take the MO-500 exam * Be familiar with the standard and format of the MO-500 exam with our sample certification exam

Github Repo

https://github.com/PacktPublishing/MO-500-Microsoft-Access-Expert-Certification

About the Author

Dave Murphy

Dave Murphy - With over twenty years of experience as a systems analyst and project manager with significant experience in the design and implementation of major projects for some of the world's largest companies, Dave Murphy changed his career track in 2000 and has been a professional university educator for over 20 years. Dave is currently a lecturer in business information systems at the Technological University, Dublin. His main interests are in Microsoft certifications, project management, and business process analysis. Dave has a bachelor's in science (Hons) from Trinity College, Dublin, and a master's degree in computing. In addition to obtaining PRINCE2 Practitioner status, Dave is also a Microsoft Certified Professional in managing projects with Microsoft Project, is a MOS Master, and also a MOS examiner.

Course Outline

1. Introduction

2. 1.1 - Modify database structure

3. 1.2 - Manage Table Relationships and Keys

4. 1.3 - Print and Export Data

5. Objective Domain 1 Exercises and Solutions

6. 2.1 - Create Tables

7. 2.2 - Manage Tables

8. 2.3 - Manage Table Records

9. 2.4 - Create and Modify Fields

10. Objective Domain 2 Exercises and Solutions

11. 3.1 - Create and run queries

12. 3.2 - Modify Queries

13. Objective Domain 3 Exercises and Solutions

14. 4.1 - Configure Form Controls

15. 4.2 - Format Forms

16. Objective Domain 4 Exercises and Solutions

17. 5.1 - Configure Report Controls

18. 5.2 - Format Reports

19. Objective Domain 5 Exercises and Solutions

20. Sample Exam

21. Associate Access 77-730 Optional Lectures