MO-500: Microsoft Access Expert Certification

Course: 9103

Create and maintain Access Database objects including tables, relationships, data entry forms, multilevel reports, and multi-table queries.

Download PDF
  • Duration: 1 day
  • Price: $325.00
Get This Course $325.00
March 27

9:00 AM – 4:00 PM CST

April 24

9:00 AM – 4:00 PM CST

May 29

9:00 AM – 4:00 PM CST

June 26

9:00 AM – 4:00 PM CST

July 24

9:00 AM – 4:00 PM CST

August 28

9:00 AM – 4:00 PM CST

September 25

9:00 AM – 4:00 PM CST

October 30

9:00 AM – 4:00 PM CST

Scroll to view additional course dates

Reserve Your Seat

  • Virtual instructor Led Training
  • Complete Hands-on Labs
  • Softcopy of Courseware
  • Learning Labs
  • Virtual instructor Led Training
  • Complete Hands-on Labs
  • Softcopy of Courseware
  • Learning Labs
  • You can use your Purchase Card and checkout
  • The GSA Contract Number: 47QTCA20D000D
  • Call 800-453-5961 for details
  • Customize your class
  • Delivery Onsite or Online for your organization
  • Choice of Dates when and where you want
  • Guidance in choosing and customizing your class

Question About this Course?

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

Question About this Course?

Need help picking the right course?

Contact Us

Call Now

Call Now800-453-5961