26/01/2017
2:59 hours
00 – Introduction
Welcome
Who should take this course
Using the exercise files
Using the challenge files
01 – 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
02 – 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
03 – Build Tables
Manage tables
Manage records in tables
Modify fields
Validation and masks
Challenge: Build tables
Solution: Build tables
04 – 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
05 – Create Forms
Create a form
Configure form controls
Add subforms
Format a form
Challenge: Create forms
Solution: Create forms
06 – Create Reports
Create a report
Configure report controls
Format a report
Add a calculated field
Challenge: Create reports
Solution: Create reports
07 – Final Practice Exam
Challenge: Full-length practice exam
Solution: Full-length practice exam
08 – Conclusion
Next steps
Exercise Files