Cert Prep: Access Expert - Microsoft Office Specialist for Office 2019 and Office 365
Offered By: LinkedIn Learning
Course Description
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
Taught by
Jennifer McBee
Related Courses
Datenmanagement mit SQLopenHPI Programming Cloud Services for Android Handheld Systems
Vanderbilt University via Coursera Getting and Cleaning Data
Johns Hopkins University via Coursera Ruby مدخل إلى برمجة مواقع الإنترنت باستخدام لغة
Rwaq (رواق) MongoDB for .NET Developers
MongoDB University