Cert Prep: Access Expert - Microsoft Office Specialist for Office 2019 and Office 365

Introduction

• Prove your Access skills with a MOS certification
• Who should take this course?
• About the exercise files
• About the challenges

1. Microsoft Office Specialist (MOS) Exam Overview

• The different kinds of Microsoft Office Specialist certifications
• Prepare for the test and review learning objectives
• Overview of the Access Expert—Office 365 and Office 2019—exam format

2. Managing Databases

• Modify database structure
• Manage table relationships and keys
• Enforce referential integrity
• Print and export data
• ✓ Challenge: Create and manage a database
• ✓ Solution: Create and manage a database

3. Create and Modify Tables

• Create tables
• Manage tables
• Manage table records
• Manage fields
• Add validation rules and input masks
• ✓ Challenge: Create and modify tables
• ✓ Solution: Create and modify tables

4. Create and Modify Queries

• Create and run a query
• Create a crosstab query
• Create an action query
• Create a basic parameter query
• Modify a query
• ✓ Challenge: Create queries
• ✓ Solution: Create queries

5. Modify Forms in Layout View

• Configure form controls
• Modify tab order on forms and sort by field
• Modify form positioning
• Insert information in form headers and footers
• ✓ Challenge: Create forms
• ✓ Solution: Create forms

6. Modify Reports in Layout View

• Group and sort fields on reports
• Format reports
• Add and modify labels on reports
• Format a report into multiple columns
• ✓ Challenge: Create reports
• ✓ Solution: Create reports

7. Final Practice Exam

• ✓ Challenge: Full-length practice exam
• ✓ Solution: Full-length practice exam

Conclusion

• Next steps