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

Course Overview

Demonstrate your advanced knowledge of Access 2016 by becoming a Microsoft Office Specialist. This course helps you prepare for exam 77-730.

Course Circullum

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

Jennifer McBee

out of 5.0

5 Star 85%

4 Star 75%

3 Star 53%

1 Star 20%

Item Reviews - 3

Submit Reviews

5 stars 4 stars 3 stars 2 stars 1 star

Name

Review

Free Trial Available

Enroll Now

This Course Include: