Microsoft Access Expert Office 2019 (MO-500) Online Course
Microsoft Access Expert Office 2019 (MO-500) Online Course
Microsoft Access Expert Office 2019 (MO-500) Online Course
This course fully prepares you for the MO-500 Microsoft Access Expert certification exam—the only Microsoft-recognized credential for Access 365 Apps and Access 2019. Through detailed video lessons, hands-on exercises, and complete coverage of the official syllabus, you’ll master all required database techniques and build the confidence to excel in the exam. By course completion, you’ll be ready to prove your skills and earn this valuable Microsoft certification.
Who should take this Course?
The Microsoft Access Expert Office 2019 (MO-500) Online Course is ideal for database developers, analysts, office professionals, and students who want to master advanced skills in designing, managing, and analyzing databases using Microsoft Access 2019. It’s also suitable for individuals preparing for the MO-500 certification exam and those seeking to enhance their ability to create complex queries, forms, reports, and automate tasks with macros. Basic knowledge of database concepts is recommended for effective learning.
What you will learn
Learn how to manage databases
Learn how to create and modify tables
Learn how to create, run, and modify queries
Learn how to modify forms in layout view
Learn how to modify reports in layout view
Solve seven sample exams
Course Table of Contents
Introduction
Course Introduction and Structure
Modify Database Structure
Import Objects or Data from Other Sources
Delete Database Objects
Hide and Display Objects in the Navigation Pane
Manage Table Relationships and Keys
(Part 1) Understand Relationships
(Part 2) Understand Relationships
(Part 3) Understand Relationships
(Part 4) Understand Relationships
Display Relationships
Set the Primary Key
Enforce Referential Integrity
Set Foreign Keys
Print and Export Data
Configure Print Options for Records, Forms, and Reports
Export Objects in Alternative Formats
Objective Domain 1 Exercises and Solutions
Objective Domain 1 Exercises and Solutions
Create Tables
Import Data into Tables
Create linked tables from external sources
Import tables from other databases
Manage Tables
Hide Fields in Tables
Add Total Rows
Add Table Descriptions
Manage Table Records
Find and Replace Data
Sort Records
Filter Records
Create and Modify Fields
(Part 1) Add and Remove Fields
(Part 2) Add and Remove Fields
Add Validation Rules to Fields
Change Field Captions
Change Field Sizes and Data Types
Configure Auto Increment and Set Default Values
Apply Built-In Input Masks
Objective Domain 2 Exercises and Solutions
Objective Domain 2 Exercise Solutions
Create and Run Queries
Create Simple Queries
Create Basic Crosstab Queries
Create Basic Parameter Queries
(Part 1) Create Basic Action Queries
(Part 2) Create Basic Action Queries
(Part 3) Create Basic Action Queries
(Part 4) Create Basic Action Queries
Create Basic Multi-Table Queries
Save Queries
Run Queries
Modify Queries
Add, Hide, and Remove Fields, Sort and Filter Data
Filter Data Within Queries
Objective Domain 3 Exercises and Solutions
Objective Domain 3 Exercises and Solutions
Configure Form Controls
Introduction to Forms
(Part 1) Add, Move, and Remove Form Controls
(Part 2) Add, Move, and Remove Form Controls
(Part 3) Add, Move, and Remove Form Controls
(Part 4) Add, Move, and Remove Form Controls
(Part 5) Add, Move, and Remove Form Controls
Add and Modify Form Labels
Format Forms
Modify Tab Order on Forms
Sort Records by Form Field
Modify Form Positioning
Insert Information in Form Headers and Footers
Insert Images on Forms
Objective Domain 4 Exercises and Solutions
Objective Domain 4 Exercises and Solutions
Configure Report Controls
Introduction to Access Reports
Group and Sort Fields on Reports
Add and Modify Report Controls and Labels
Format Reports
Format a Report into Multiple Columns
Modify Report Positioning
Format Report Elements
Change Report Orientation
Insert Information in Report Headers and Footers
Insert Images on Reports
Objective Domain 5 Exercises and Solutions
Objective Domain 5 Exercises and Solutions
Sample Exam
Sample Exam Project 1
Sample Exam Project 2
Sample Exam Project 3
Sample Exam Project 4
Sample Exam Project 5
Sample Exam Project 6
Associate Access 77-730 Optional Lectures
Create a Blank Desktop Database
Create a Database from a Template
Compact and Repair a Database
Back Up a Database
Split a Database
Encrypt a Database with a Password
Recover Data from Backup
Create a Table
Create a Form
Create a Form from a Template with Application Parts
Create a Report Based on the Query or Table and in Design View