Cert Prep: Access 2013 Microsoft Office Specialist (77-424)

Introduction

• Welcome
• What you should know before watching this course
• Using the exercise files
• Using the challenges

1. Microsoft Office Specialist Exam Overview

• Compare the Microsoft Office Specialist certifications
• Prepare for the exam
• Review the exam objectives and format

2. Create and Manage a Database

• Create a new database
• Set up the primary key
• Manage relationships
• Navigate through a database
• Protect and maintain a database
• Save and export a database
• Challenge: Create a database
• Solution: Create a database

3. Build Tables

• Create a new table
• Format a table
• Manage records
• Create and modify fields
• Challenge: Build tables
• Solution: Build tables

4. Create Queries

• Work with simple select queries
• Create multi-table queries
• Create crosstab queries
• Modify a query
• Utilize calculated fields and group within a query
• Challenge: Create queries
• Solution: Create queries

5. Create Forms

• Create basic forms
• Create navigation forms and split forms
• Set form controls
• Format forms
• Challenge: Create a form
• Solution: Create a form

6. Create Reports

• Create a report
• Set report controls
• Format a report
• Challenge: Create a report
• Solution: Create a report

7. Final Practice Exam

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

Conclusion

• Next steps