Cert Prep: Access 2010 Microsoft Office Specialist (77-885)

Demonstrate your knowledge of Access to the world—become a Microsoft Office Specialist. Prepare for the Access 2010 MOS Certification Exam 77-885.

Demonstrate your knowledge of Access to the world—become a Microsoft Office Specialist. This course, created by Certified MOS Master Instructor Jennifer McBee, helps you prepare for the Access 2010 MOS certification exam (77-885). Review the five main areas of the Access 2010 MOS exam, including managing the Access environment, building tables, creating forms, creating and managing queries, and designing reports. Explore the MOS certification program, its cost, and its format and walk through each Access certification objective in detail. Get hands-on experience with free downloadable practice files and take the challenges to test your skills. The course wraps with a full-length, 50-minute practice exam.

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. Managing the Access Environment

• Create a new database
• Manage a database
• Configure the Navigation pane and access options
• Apply application parts
• Backup a database
• ✓ Challenge: Create databases
• ✓ Solution: Create databases

3. Building Tables

• Create a new table
• Create and modify fields
• Sort and filter records
• Primary key
• Set table relationships
• Manage records
• Import data
• ✓ Challenge: Build tables
• ✓ Solution: Build tables

4. Create Forms

• Create basic forms
• Create navigation forms and split forms
• Set form controls
• Apply headers, footers, themes, and add images
• Arrange objects on forms
• Apply backgrounds, alternate row color, and control formatting groups
• Format form controls
• ✓ Challenge: Create forms
• ✓ Solution: Create forms

5. Create and Manage Queries

• Work with simple select queries
• Create multi-table queries
• Create crosstab queries
• Append query
• Create Make Table queries
• Use Total and Group By
• Use calculated fields in a query
• ✓ Challenge: Create queries
• ✓ Solution: Create queries

6. Create Reports

• Create a report
• Apply Report Design tab options
• Control report margins and padding
• Apply Format tab options
• Apply Report Page Setup tab options
• Sort and filter records for reporting
• ✓ Challenge: Design Reports
• ✓ Solution: Design Reports

7. Final Practice Exam

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

Conclusion

• Next steps