Generic filters
Exact matches only
Search in title
Search in content
Search in excerpt

Microsoft Access 2019 (MO-500)

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.
Microsoft Access 2019 (MO-500)
Test Prep
17+ Pre Assessment Questions | 17+ Post Assessment Questions |
44+ LiveLab | 00+ Minutes
The exam consists of performance based questions and is conducted in a live or simulated environment.

Why choose TOPTALENT?


Lessons 1:

  • Course setup

Lessons 2:
Database fundamentals

  • Module A: Understanding general database terms
  • Module B: Relational databases
  • Module C: Access interface and objects
  • Summary

Lessons 3:

  • Module A: Creating tables
  • Module B: Creating fields
  • Module C: Data Validation
  • Module D: Relationships and keys
  • Summary

Lessons 4:

  • Module A: Creating basic queries
  • Module B: Modifying queries
  • Module C: Using calculated fields
  • Summary

Lessons 5:

  • Module A: Creating simple forms
  • Module B: Form design
  • Module C: Form controls
  • Summary

Lessons 6:

  • Module A: Creating Reports
  • Module B: Report controls
  • Module C: Formatting reports
  • Summary

Lessons 7:

  • Course setup

Lessons 8:
Advanced queries

  • Module A: Grouping and summarizing
  • Module B: Updating, deleting, and relationships
  • Module C: Indexing for performance
  • Summary

Lessons 9:
Advanced forms

  • Module A: Subforms
  • Module B: Advanced control types
  • Module C: Specialized form types
  • Summary

Lessons 10:
Advanced reports

  • Module A: Subreports
  • Module B: Advanced grouping
  • Module C: Advanced formatting
  • Summary

Lessons 11:

  • Module A: Creating basic macros
  • Module B: Using variables
  • Module C: Troubleshooting macros
  • Summary

Lessons 12:
Database management

  • Module A: Compact & Repair
  • Module B: Restoring a database
  • Module C: Other maintenance tasks
  • Summary