Microsoft Access Expert Office 2019 (MO-500) Practice Exam
Microsoft Access Expert Office 2019 (MO-500) Practice Exam
About Microsoft Access Expert Office 2019 (MO-500) Practice Exam
The Microsoft Access Expert Office 2019 (MO-500) Exam requires candidates to demonstrate their skills and knowledge in using the primary features of Access 2019. The MO-500 exam requires candidates to create and maintain Access database objects such as tables, relationships, data entry forms, multilevel reports, and multi-table queries.
Knowledge Acquired
Candidates will gain an understanding of database design principles. To qualify the Microsoft Access Expert Office 2019 (MO-500), should have -
- Approximately 150 hours of instruction and hands-on experience with Access 2019
- Proven competency at an industry expert level.
Skills Measured
- Managing databases
- Creating and modifying tables
- Creating and modifying queries
- Modifying forms in layout view
- Modifying reports in layout view
Course Outline
The Microsoft Access Expert Office 2019 (MO-500) Exam covers the following topics -
Domain 1 - Managing Databases
1.1 Describe Modifying Database Structure
- Explain importing objects or data from other sources
- Describe deleting database objects
- Overview hiding and displaying objects in the Navigation Pane
1.2 Understanding Managing Table Relationships and Keys
- Describe relationships
- Explain displaying relationships
- Learn setting primary keys
- Explain enforcing referential integrity
- Understand setting foreign keys
Overview Printing and Exporting Data
- Explain configuring print options for records, forms, and reports
- Describe exporting objects to alternative formats
Domain 2 - Creating and Modifying Tables
2.1 Learn Creating Tables
- Explain importing data into tables
- Describe creating linked tables from external sources
- Understand importing tables from other databases
2.2 Describe Managing Tables
- Explain hiding fields in tables
- Learn adding total rows
- Understand adding table descriptions
2.3 Learn Managing Table Records
- Describe finding and replacing data
- Explain sorting records
- Understand filtering records
2.4 Overview Creating and Modifying Fields
- Explain adding and removing fields
- Describe adding validation rules to fields
- Learn changing field captions, sizes, and data types
- Understand configuring fields to auto-increment
- Explain setting default values
- Learn applying built-in input masks
Domain 3 - Creating and Modifying Queries
3.1 Overview Creating and Running Queries
- Explain creating simple queries
- Describe creating basic crosstab queries
- Learn creating basic parameter queries
- Understand creating basic action queries
- Explain creating basic multi-table queries
- Learn saving and running queries
3.2 Understanding Modifying Queries
- Describe adding, hiding, and removing fields in queries
- Explain sorting and filtering data within queries
- Learn formatting fields within queries
Domain 4 - Modifying Forms in Layout View
4.1 Overview Configuring Form Controls
- Explain adding, moving, and removing form controls
- Describe setting form control properties
- Learn adding and modifying form labels
4.2 Understanding Formatting Forms
- Describe modifying tab order on forms
- Explain sorting records by form field
- Learn modifying form positioning
- Understand inserting information in form headers and footers
- Explain inserting images on forms
Domain 5 - Modifying Reports in Layout View
5.1 Overview Configuring Report Controls
- Describe grouping and sorting fields on reports
- Explain adding and modifying report controls and labels
5.2 Understanding Formatting Reports
- Describe formatting reports into multiple columns
- Explain modifying report positioning and elements
- Learn changing report orientation
- Understand inserting information and images in report headers and footers
- Understand images on reports