Microsoft Access Expert 2019 (Microsoft 365 Apps)

This 40-hour, educator-led course helps prepare students for Exam MO-500: Microsoft Access Expert (Office 2019). The course includes comprehensive student materials with guidance and a series of student lessons, activities and assessments contained within nine modules based around a single business case scenario. By becoming adept at using Access features, students develop their relational database skills and gain valuable insights into information-management strategies for efficiently designing and managing Access databases. They learn how to create databases that clearly and effectively organize information so that data can be easily retrieved.

On successful Completion of the course you will be able to:

• Modify database structure
• Manage table relationships and keys
• Print and export data
• Create and modify tables
• Create and modify fields
• Create and modify queries
• Modify forms in layout view
• Modify reports in layout view
• Format reports