Overview
-
Demonstrate your mastery of Access by becoming a Microsoft Office Specialist (MOS). Get training for the Access Expert certification exams for Office 365 and Office 2019.
Syllabus
-
Introduction
- Prove your Access skills with a MOS certification
- Who should take this course?
- About the exercise files
- About the challenges
- The different kinds of Microsoft Office Specialist certifications
- Prepare for the test and review learning objectives
- Overview of the Access Expert—Office 365 and Office 2019—exam format
- Modify database structure
- Manage table relationships and keys
- Enforce referential integrity
- Print and export data
- ✓ Challenge: Create and manage a database
- ✓ Solution: Create and manage a database
- Create tables
- Manage tables
- Manage table records
- Manage fields
- Add validation rules and input masks
- ✓ Challenge: Create and modify tables
- ✓ Solution: Create and modify tables
- Create and run a query
- Create a crosstab query
- Create an action query
- Create a basic parameter query
- Modify a query
- ✓ Challenge: Create queries
- ✓ Solution: Create queries
- Configure form controls
- Modify tab order on forms and sort by field
- Modify form positioning
- Insert information in form headers and footers
- ✓ Challenge: Create forms
- ✓ Solution: Create forms
- Group and sort fields on reports
- Format reports
- Add and modify labels on reports
- Format a report into multiple columns
- ✓ Challenge: Create reports
- ✓ Solution: Create reports
- ✓ Challenge: Full-length practice exam
- ✓ Solution: Full-length practice exam
- Next steps
