Prepare for the MO-500 Microsoft Access Expert Certification Exam
About This Video
In Detail
This course will prepare you to successfully pass the MO-500 Microsoft Access Expert certification exam. The …
Prepare for the MO-500 Microsoft Access Expert Certification Exam
About This Video
In Detail
This course will prepare you to successfully pass the MO-500 Microsoft Access Expert certification exam. The MO-500 is the only exam officially recognized by Microsoft for Access 365 Apps and Access 2019. Every aspect of the exam is covered in detail, together with exercises and solutions. If you take this course and follow the guidelines provided, you will enhance your chances of obtaining this extremely valuable qualification. Prove your database skills by obtaining independent certification from Microsoft.
The course is designed to ensure that you are familiar with all the techniques specified by Microsoft for the MO-500 Objective Domain (Syllabus). Every aspect of the requirements specified by Microsoft is comprehensively covered using video lectures together with appropriate exercises designed to ensure your understanding of the database techniques covered in each of the lectures.
The exercises have been designed so that when you take the actual exam, you will be fully prepared for the standard and style of the projects and tasks set by Microsoft.
By the end of this course, you will be well prepared for your MS-500 exam.
Audience
This course is suitable for beginners and designed for all students who wish to obtain the Microsoft Access MO-500 Expert Certification. No prior knowledge is assumed; just Microsoft Access 2016 or Microsoft Access 365/2019 is required for practice.
Chapter 1 : Introduction
Course Introduction and Structure
Chapter 2 : Modify Database Structure
Import Objects or Data from Other Sources
Delete Database Objects
Hide and Display Objects in the Navigation Pane
Chapter 3 : 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
Chapter 4 : Print and Export Data
Configure Print Options for Records, Forms, and Reports
Export Objects in Alternative Formats
Chapter 5 : Objective Domain 1 Exercises and Solutions
Objective Domain 1 Exercises and Solutions
Chapter 6 : Create Tables
Import Data into Tables
Create linked tables from external sources
Import tables from other databases
Chapter 7 : Manage Tables
Hide Fields in Tables
Add Total Rows
Add Table Descriptions
Chapter 8 : Manage Table Records
Find and Replace Data
Sort Records
Filter Records
Chapter 9 : 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
Chapter 10 : Objective Domain 2 Exercises and Solutions
Objective Domain 2 Exercise Solutions
Chapter 11 : 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
Chapter 12 : Modify Queries
Add, Hide, and Remove Fields, Sort and Filter Data
Filter Data Within Queries
Chapter 13 : Objective Domain 3 Exercises and Solutions
Objective Domain 3 Exercises and Solutions
Chapter 14 : 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
Chapter 15 : 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
Chapter 16 : Objective Domain 4 Exercises and Solutions
Objective Domain 4 Exercises and Solutions
Chapter 17 : Configure Report Controls
Introduction to Access Reports
Group and Sort Fields on Reports
Add and Modify Report Controls and Labels
Chapter 18 : 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
Chapter 19 : Objective Domain 5 Exercises and Solutions
Objective Domain 5 Exercises and Solutions
Chapter 20 : 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
Chapter 21 : 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
Create a Report Using the Report Wizard