Cert Prep: Access 2016 Microsoft Office Specialist (77-730)

Introduction

• Welcome
• Who should take this course
• Using the exercise files
• Using the challenge files

1. Microsoft Office Specialist (MOS) Exam Overview

• The different kinds of Microsoft Office Specialist certifications
• Prepare for the test
• Overview of the 2016 MOS exam format and learning objectives

2. Create and Manage a Database

• Create and modify databases
• Manage relationships and keys
• Navigate through a database
• Maintain databases
• Print and export data
• ✓ Challenge: Create and manage a database
• ✓ Solution: Create and manage a database

3. Build Tables

• Manage tables
• Manage records in tables
• Modify fields
• Validation and masks
• ✓ Challenge: Build tables
• ✓ Solution: Build tables

4. Create Queries

• Create and run a query
• Create a crosstab query
• Create an action query
• Create a parameter query
• Modify a query
• Create calculated fields and grouping within queries
• ✓ Challenge: Create queries
• ✓ Solution: Create queries

5. Create Forms

• Create a form
• Configure form controls
• Add subforms
• Format a form
• ✓ Challenge: Create forms
• ✓ Solution: Create forms

6. Create Reports

• Create a report
• Configure report controls
• Format a report
• Add a calculated field
• ✓ Challenge: Create reports
• ✓ Solution: Create reports

7. Final Practice Exam

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

Conclusion

• Next steps