Cert Prep: Access Expert - Microsoft Office Specialist for Office 2019 and Office 365

Course details

Demonstrate your mastery of Access 2019 by becoming a Microsoft Office Specialist (MOS). Get training to prepare for the Access Expert certification exams for Office 365 and Office 2019. This course, created by Microsoft Certified Instructor and MOS Master Jennifer McBee, helps you prepare for the five main areas of focus for the Access Expert Office 365 and Office 2019 exams: managing databases, creating and modifying tables, creating and modifying queries, modifying forms in layout view, and modifying reports in layout view. The course includes an overview of the MOS certification program, its costs, and all the exam objectives. Follow along with the downloadable sample files. Then take the full-length practice test at the end of the course to test your skills and speed.

Learning objectives
Modifying the database structure
Managing table relationships and keys
Exporting data
Managing records and fields
Creating and running queries
Configuring form controls
Modifying form positioning
Grouping report fields
Formatting reports
Taking the practice exam

Concepts

0. Introduction

01 - Prove your Access skills with a MOS certification
02 - Who should take this course
03 - About the exercise files
04 - About the challenges

1. Microsoft Office Specialist (MOS) Exam Overview

05 - The different kinds of Microsoft Office Specialist certifications
06 - Prepare for the test and review learning objectives
07 - Overview of the Access Expert Office 365 and Office 2019 exam format

2. Managing Databases

08 - Modify database structure
09 - Manage table relationships and keys
10 - Enforce referential integrity
11 - Print and export data
12 - ✓ Challenge - Create and manage a database
13 - ✓ Solution - Create and manage a database

3. Create and Modify Tables

14 - Create tables
15 - Manage tables
16 - Manage table records
17 - Manage fields
18 - Add validation rules and input masks
19 - ✓ Challenge - Create and modify tables
20 - ✓ Solution - Create and modify tables

4. Create and Modify Queries

21 - Create and run a query
22 - Create a crosstab query
23 - Create an action query
24 - Create a basic parameter query
25 - Modify a query
26 - ✓ Challenge - Create queries
27 - ✓ Solution - Create queries

5. Modify Forms in Layout View

28 - Configure form controls
29 - Modify tab order on forms and sort by field
30 - Modify form positioning
31 - Insert information in form headers and footers
32 - ✓ Challenge - Create forms
33 - ✓ Solution - Create forms

6. Modify Reports in Layout View

34 - Group and sort fields on reports
35 - Format reports
36 - Add and modify labels on reports
37 - Format a report into multiple columns
38 - ✓ Challenge - Create reports
39 - ✓ Solution - Create reports

7. Final Practice Exam

40 - ✓ Challenge - Full-length practice exam
41 - ✓ Solution - Full-length practice exam

Conclusion

42 - Next steps