Keep Calm and Study On - Unlock Your Success - Use #TOGETHER for 30% discount at Checkout

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


Tags: Microsoft MO-500 Free Test, Microsoft MO-500 Exam Questions, Microsoft MO-500 Study Guide, Microsoft MO-500 Online Course, Microsoft MO-500 Practice exam, Microsoft MO-500 learning resources