Dynamics 365
Power BI & Apps
Microsoft 365 (Office)
Cyber Security
Government Solutions

Microsoft Access Expert (Access and Access 2019) MO-500

In this course, you will use the advanced tools and features in PowerPoint to create and deliver engaging presentations.

Microsoft Access Expert (Access and Access 2019) MO-500

This course will help students create and maintain Access Database objects including tables, relationships, data entry forms, multilevel reports, and multi-table queries. Candidates are expected to demonstrate the correct application of the principal features of Access and complete tasks independently.

Course Outline 

Manage databases

Modify database structure

  • import objects or data from other sources
  • delete database objects
  • hide and display objects in the Navigation Pane

Manage table relationships and keys

  • understand relationships
  • display relationships
  • set primary keys
  • enforce referential integrity
  • set foreign keys

Print and export data

  • configure print options for records, forms, and reports
  • export objects to alternative formats

Create and modify tables

Create tables

  • import data into tables
  • create linked tables from external sources
  • import tables from other databases

Manage tables

  • hide fields in tables
  • add total rows
  • add table descriptions

Manage table records

  • find and replace data
  • sort records
  • filter records

Create and modify fields

  • add and remove fields
  • add validation rules to fields
  • change field captions
  • change field sizes
  • change field data types
  • configure fields to auto-increment
  • set default values
  • apply built-in input masks

Create and modify queries

Create and run queries

  • create simple queries
  • create basic crosstab queries
  • create basic parameter queries
  • create basic action queries
  • create basic multi-table queries
  • save queries
  • run queries

Modify queries

  • add, hide, and remove fields in queries
  • sort data within queries
  • filter data within queries
  • format fields within queries

Modify forms in layout view

Configure form controls

  • add, move, and remove form controls
  • set form control properties
  • add and modify form labels

Format forms

  • modify tab order on forms
  • sort records by form field
  • modify form positioning
  • insert information in form headers and footers
  • insert images on forms

Modify reports in layout view

Configure report controls

  • group and sort fields on reports
  • add report controls
  • add and modify labels on reports

Format reports

  • format a report into multiple columns
  • modify report positioning
  • format report elements
  • change report orientation
  • insert information in report headers and footers
  • insert images on reports

Do not hesitate to Contact Us or Live Chat if you have questions or concerns about PowerPoint 2019 Certification MO-300 Course. 

Need help picking the right course?

Give us a call!
408-684-5250 or 
800-453-596 (Toll Free) 

Train Your Team

Save money and get your team trained. With a group of 5 or more people, you have special options. Click the button below to request a special quote for your team now!

Register Now


1 days


    202 S.E. Church Street, Suite 203 Leesburg, VA 20175
    800-453-5961 (Toll Free)
    linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram