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.
- Price: $279.99
- Delivery method: eLearning
- DIR Discount: 20%
Submit form to obtain discount
Test Prep
17+ Pre Assessment Questions |
17+ Post Assessment Questions |
Features
44+ LiveLab |
00+ Minutes
The exam consists of performance based questions and is conducted in a live or simulated environment.
Why choose TOPTALENT?
- Get assistance every step of the way from our Texas-based team, ensuring your training experience is hassle-free and aligned with your goals.
- Access an expansive range of over 3,000 training courses with a strong focus on Information Technology, Business Applications, and Leadership Development.
- Have confidence in an exceptional 95% approval rating from our students, reflecting outstanding satisfaction with our course content, program support, and overall customer service.
- Benefit from being taught by Professionally Certified Instructors with expertise in their fields and a strong commitment to making sure you learn and succeed.
Outline
Lessons 1:
Introduction
- 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:
Tables
- Module A: Creating tables
- Module B: Creating fields
- Module C: Data Validation
- Module D: Relationships and keys
- Summary
Lessons 4:
Queries
- Module A: Creating basic queries
- Module B: Modifying queries
- Module C: Using calculated fields
- Summary
Lessons 5:
Forms
- Module A: Creating simple forms
- Module B: Form design
- Module C: Form controls
- Summary
Lessons 6:
Reports
- Module A: Creating Reports
- Module B: Report controls
- Module C: Formatting reports
- Summary
Lessons 7:
Introduction
- 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:
Macros
- 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