MO-500.AI1
Microsoft Access 2019 (MO-500)
Prepare & practice for the MO-500 exam with this MS Access course.
- Practice in 73 Hands-On Labs — nothing to install
- 12 Interactive Lessons and 43 topics mapped to the official exam objectives
- 141 Practice Test Questions
Beginner Self-paced · 1 year access 4.4/5 (22 Reviews)
73 Hands-On LiveLabs
Practice real IT tasks in guided environments.
- Real environments
- Auto-graded
- No installation
12Interactive Lessons
43Topics
73LiveLab
141Practice Test Questions
2Videos
100Flashcards
100Glossary of terms
01 / Skills you'll get
What you will be able to do
Try Free →
No credit card required
The Microsoft Access 2019 (MO-500) is a comprehensive training course that teaches you the skills needed to effectively create, manage, and analyze databases using Access. The course content is in sync with the MO-500 exam objectives, focusing on developing your knowledge and ability to create and maintain Access Database objects including tables, relationships, data entry forms, multi-level reports and multi-table queries. It has a prep engine with hands-on Labs which provide different sets of questions to prepare for the exam in the test environment. After completing this Microsoft Access 2019 course you’ll know how to manage databases, create and modify tables, create and modify queries, modify forms in layout view, and modify reports in layout view.
- Core understanding of database concepts: tables, fields, and relationships
- Use queries for data manipulation to select, insert, update, and delete data
- Design and create forms for data data entry, modification, and display
- Generate and format reports for data analysis and presentation
- Optimizing query by using techniques like indexing, grouping, and calculated fields
- Ability to customize forms and enhance detailed reports
- Utilizing macro programming for automating and streamlining repetitive tasks
- Skilled with maintenance tasks including compacting, repairing, and restoring databases
- Awareness of security best practices to protect data
Target Career Roles
- Office Manager
- Executive Assistant
- Database Specialist
- IT Support Technician
- Administrative Assistant
02 / Lessons & labs
See exactly what you will learn and practice
Lessons
12 Interactive Lessons · 43 topics01 Introduction 1 topics +
- Course setup
02 Database fundamentals 4 topics · 4 LiveLab +
- Module A: Understanding general database terms
- Module B: Relational databases
- Module C: Access interface and objects
- Summary
4 LiveLab in this lesson — see the labs panel →
03 Tables 5 topics · 14 LiveLab +
- Module A: Creating tables
- Module B: Creating fields
- Module C: Data Validation
- Module D: Relationships and keys
- Summary
14 LiveLab in this lesson — see the labs panel →
04 Queries 4 topics · 14 LiveLab +
- Module A: Creating basic queries
- Module B: Modifying queries
- Module C: Using calculated fields
- Summary
14 LiveLab in this lesson — see the labs panel →
05 Forms 4 topics · 7 LiveLab +
- Module A: Creating simple forms
- Module B: Form design
- Module C: Form controls
- Summary
7 LiveLab in this lesson — see the labs panel →
06 Reports 4 topics · 10 LiveLab +
- Module A: Creating Reports
- Module B: Report controls
- Module C: Formatting reports
- Summary
10 LiveLab in this lesson — see the labs panel →
07 Introduction 1 topics +
- Course setup
08 Advanced queries 4 topics · 5 LiveLab +
- Module A: Grouping and summarizing
- Module B: Updating, deleting, and relationships
- Module C: Indexing for performance
- Summary
5 LiveLab in this lesson — see the labs panel →
09 Advanced forms 4 topics · 4 LiveLab +
- Module A: Subforms
- Module B: Advanced control types
- Module C: Specialized form types
- Summary
4 LiveLab in this lesson — see the labs panel →
10 Advanced reports 4 topics · 6 LiveLab +
- Module A: Subreports
- Module B: Advanced grouping
- Module C: Advanced formatting
- Summary
6 LiveLab in this lesson — see the labs panel →
11 Macros 4 topics · 5 LiveLab +
- Module A: Creating basic macros
- Module B: Using variables
- Module C: Troubleshooting macros
- Summary
5 LiveLab in this lesson — see the labs panel →
12 Database management 4 topics · 4 LiveLab +
- Module A: Compact & Repair
- Module B: Restoring a database
- Module C: Other maintenance tasks
- Summary
4 LiveLab in this lesson — see the labs panel →
Hands-On Labs Our edge
73 LiveLabs- Exploring a Query
- Importing a Flat File
- Creating a Database from a Template
- Using the Navigation Pane
- Creating a Blank Table
- Deleting a Table from a Database
- Renaming a Table
- Changing the Form Header using the Caption Property
- Creating a Primary Key
- Adding a Field in Datasheet View
- Modifying Fields in Design View
- Adding Records to a Database Table
- Creating and Formatting a New Table
- Changing Date/Time Controls
- Creating a Table-level Validation Rule
- Setting the Required and Default Value Properties
- Setting Validation Rules
- Creating a Relationship Between Tables
- Creating a Select Query
- Creating an Append Query
- Saving a Filter as a Query
- Creating a Totals Query
- Creating an Update Query
- Modifying a Query
- Formatting a Query
- Sorting a Query
- Creating a Make Table Query
- Creating a Delete Query
- Adding the Criteria
- Creating a Crosstab Query
- Using Date Ranges in a Report
- Using Calculated Fields
- Creating and Viewing a Form in Form View
- Creating a Form Using the Form Wizard
- Designing a Form
- Creating a Split Form
- Adding Form Controls
- Adding List Controls and Command Buttons
- Changing the Layout of Controls
- Creating a Basic Report
- Creating a New Report and Binding it to a Query
- Creating a Report Using the Report Wizard
- Controlling a Report's Data Source
- Manipulating Controls in a Report
- Creating Labels Using the Label Wizard
- Creating a Calculated Field
- Formatting a Report and an Image
- Grouping a Report and Adding a Group Summary Calculation
- Working with Themes
- Grouping and Summarizing Data
- Using the WHERE Clause
- Performing Cascading Updates and Deletions
- Deleting a Record
- Indexing a Table
- Creating a Subform and Linking Forms
- Creating a Chart Using the Chart Wizard
- Inserting a Background Image in a Form
- Working with Advanced Form Controls
- Creating Unrelated Subreports
- Adding a Related Subreport to an Existing Report
- Creating a Subreport with the Same Record Source as the Main Report
- Sorting a Field of Reports
- Adding Running Sums to a Report
- Using the Report Formatting Options
- Creating a Data Macro
- Creating an Embedded Macro
- Creating a Macro
- Exporting Objects to Other Access Databases
- Debugging a Macro
- Running Compact & Repair
- Restoring an Access Database
- Using Print Preview to Create a Print Layout
- Performing the Maintenance Tasks
Labs run in your browser — nothing to install.
03 / Exam details
Microsoft Access 2019 (MO-500) Details
Gain the skills required to pass the Microsoft Access certification exam with the Microsoft Access 2019 course and lab. Lab delivers hands-on experience replacing expensive physical labs. The course and lab cover the MS Access MO-500 exam objectives and provide the ability to create and maintain Access Database objects including tables, relationships, data entry forms, multilevel reports, and multi-table queries. The Microsoft Access training has the best MO-500 practice tests to help you master the skills covered in the exam.
Questions
40-60
(per exam)
Duration
90 minutes
(per exam)
Passing Score
The passing score varies from exam to exam and is provided on the score report.
(scaled score)
Exam Fee
USD 100
(per exam)
Delivered by
Certiport
(in-person or online)
Question Format
The exam consists of performance based questions and is...
single/multiple choice, performance-based
Practice Tests
141 Practice Questions
(mapped to official exam objectives)
Certification
MO-500.AI1
Microsoft credential
Ready to take the exam?
Add your official MO-500.AI1 exam voucher to your order.
Official Voucher · Fast delivery · Retake bundle available
Exam voucher is sold separately and not included with standard course.
04 / FAQs
Questions before you start
What is the Microsoft Access 2019 (MO-500) course about? +
It is an online preparatory course that helps you prepare and practice for the MO-500 certification exam. Everything from the course content to the training Lab exercises are 100% aligned with the certification exam.
What is the MO-500 certification exam? +
Mo-500 is a certification exam conducted by Microsoft to validate the database management skills of an individual. The exam covers a wide range of topics, including: database management, table creation and management, query design, form design, report creation, and advanced database management topics like using subforms, advanced controls, and specialized form types.
What is the format of the MO-500 certification exam? +
The exam format is MCQ. You’ll have to select the most appropriate answer from the given options.
Is there a time limit for completing this certification exam? +
Yes, there is a time limit. You’ll have to complete the exam within 50 minutes.
What is the Microsoft Access 2019 certification fee? +
The exam fee is $100.
What is the estimated salary range of a MS Access certified professional?+
The estimated salary range is anywhere between $37,500 to $121,000 annually depending on experience, organization and location.
What are the prerequisites for this exam?+
There are no technical prerequisites for the certification exam.
What is the exam registration fee?+
USD 100
Where do I take the exam?+
What is the format of the exam?+
The exam consists of performance based questions and is conducted in a live or simulated environment.
How many questions are asked in the exam?+
The exam contains 40-60 questions.
What is the duration of the exam?+
90 minutes
What is the passing score?+
The passing score varies from exam to exam and is provided on the score report.
What is the exam's retake policy?+
Microsoft Office Specialist (MOS) exam retake policy
- If a candidate does not achieve a passing score on an exam the first time, the candidate must wait 24 hours before retaking the exam.
- If a candidate does not achieve a passing score the second time, the candidate must wait 2 days (48 hours) before retaking the exam a third time.
- A two-day waiting period will be imposed between each subsequent exam retake.
- There is no annual limit on the number of attempts on the same exam.
- If a candidate achieves a passing score on an Office exam, the candidate may take it again.
What is the validity of the certification?+
For life
Where can I find more information about this exam?+
Streamline Your Data Management Tasks
Optimize your workflow and data potential with Microsoft Access 2016.
- 1 year of full access
- 73 LiveLab included
- Certificate of completion
No credit card required