Overview
-
Demonstrate your advanced knowledge of Access 2016 by becoming a Microsoft Office Specialist. This course helps you prepare for exam 77-730.
Syllabus
-
Introduction
- Welcome
- Who should take this course
- Using the exercise files
- Using the challenge files
- The different kinds of Microsoft Office Specialist certifications
- Prepare for the test
- Overview of the 2016 MOS exam format and learning objectives
- 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
- Manage tables
- Manage records in tables
- Modify fields
- Validation and masks
- ✓ Challenge: Build tables
- ✓ Solution: Build tables
- 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
- Create a form
- Configure form controls
- Add subforms
- Format a form
- ✓ Challenge: Create forms
- ✓ Solution: Create forms
- Create a report
- Configure report controls
- Format a report
- Add a calculated field
- ✓ Challenge: Create reports
- ✓ Solution: Create reports
- Challenge: Full-length practice exam
- Solution: Full-length practice exam
- Next steps
