Dear users, due to the protests and the disorderly situation in Iran, there is a possibility of Internet interruption in Iran. We apologize in advance if there is a problem in updating the site. MahsaAmini WomanLifeFreedom

Download MO-500 Microsoft Access Expert Certification

Download MO-500 Microsoft Access Expert Certification

What you would learn in MO-500 Microsoft Access Expert Certification course?

This course will allow for a MO-500 Microsoft Access Expert certification exam. The MO-500 is the sole exam acknowledged as valid by Microsoft in the field of Access 365 Apps and Access 2019. The entire exam is thoroughly covered, along with questions and exercises. If you complete this course and adhere to the directions given, you'll increase your chances of earning this valuable certificate. Demonstrate your knowledge of databases by getting an independent certification from Microsoft.

This course was designed to ensure that you're familiar with all the methods specified to be used by Microsoft to meet the requirements of the MO-500 Objet Domain (Syllabus). Element of the specifications set forth by Microsoft is covered thoroughly in videos and exercises designed to help you understand the database strategies taught in the lectures.

The tests have been developed to ensure that when you take the actual test, you'll be ready for the standard design of Microsoft's assignments and projects.

You'll be fully prepared for the MS-500 test when you finish this course.

Course Content:

  • Chapter 1 : Introduction
    1. Course Introduction and Structure
  • Chapter 2 : Modify Database Structure
    1. Import Objects or Data from Other Sources
    2. Delete Database Objects
    3. Hide and Display Objects in the Navigation Pane
  • Chapter 3 : Manage Table Relationships and Keys
    1. (Part 1) Understand Relationships
    2. (Part 2) Understand Relationships
    3. (Part 3) Understand Relationships
    4. (Part 4) Understand Relationships
    5. Display Relationships
    6. Set the Primary Key
    7. Enforce Referential Integrity
    8. Set Foreign Keys
  • Chapter 4 : Print and Export Data
    1. Configure Print Options for Records, Forms, and Reports
    2. Export Objects in Alternative Formats
  • Chapter 5 : Objective Domain 1 Exercises and Solutions
    1. Objective Domain 1 Exercises and Solutions
  • Chapter 6 : Create Tables
    1. Import Data into Tables
    2. Create linked tables from external sources
    3. Import tables from other databases
  • Chapter 7 : Manage Tables
    1. Hide Fields in Tables
    2. Add Total Rows
    3. Add Table Descriptions
  • Chapter 8 : Manage Table Records
    1. Find and Replace Data
    2. Sort Records
    3. Filter Records
  • Chapter 9 : Create and Modify Fields
    1. (Part 1) Add and Remove Fields
    2. (Part 2) Add and Remove Fields
    3. Add Validation Rules to Fields
    4. Change Field Captions
    5. Change Field Sizes and Data Types
    6. Configure Auto Increment and Set Default Values
    7. Apply Built-In Input Masks
  • Chapter 10 : Objective Domain 2 Exercises and Solutions
    1. Objective Domain 2 Exercise Solutions
  • Chapter 11 : Create and Run Queries
    1. Create Simple Queries
    2. Create Basic Crosstab Queries
    3. Create Basic Parameter Queries
    4. (Part 1) Create Basic Action Queries
    5. (Part 2) Create Basic Action Queries
    6. (Part 3) Create Basic Action Queries
    7. (Part 4) Create Basic Action Queries
    8. Create Basic Multi-Table Queries
    9. Save Queries
    10. Run Queries
  • Chapter 12 : Modify Queries
    1. Add, Hide, and Remove Fields, Sort and Filter Data
    2. Filter Data Within Queries
  • Chapter 13 : Objective Domain 3 Exercises and Solutions
    1. Objective Domain 3 Exercises and Solutions
  • Chapter 14 : Configure Form Controls
    1. Introduction to Forms
    2. (Part 1) Add, Move, and Remove Form Controls
    3. (Part 2) Add, Move, and Remove Form Controls
    4. (Part 3) Add, Move, and Remove Form Controls
    5. (Part 4) Add, Move, and Remove Form Controls
    6. (Part 5) Add, Move, and Remove Form Controls
    7. Add and Modify Form Labels
  • Chapter 15 : Format Forms
    1. Modify Tab Order on Forms
    2. Sort Records by Form Field
    3. Modify Form Positioning
    4. Insert Information in Form Headers and Footers
    5. Insert Images on Forms
  • Chapter 16 : Objective Domain 4 Exercises and Solutions
    1. Objective Domain 4 Exercises and Solutions
  • Chapter 17 : Configure Report Controls
    1. Introduction to Access Reports
    2. Group and Sort Fields on Reports
    3. Add and Modify Report Controls and Labels
  • Chapter 18 : Format Reports
    1. Format a Report into Multiple Columns
    2. Modify Report Positioning
    3. Format Report Elements
    4. Change Report Orientation
    5. Insert Information in Report Headers and Footers
    6. Insert Images on Reports
  • Chapter 19 : Objective Domain 5 Exercises and Solutions
    1. Objective Domain 5 Exercises and Solutions
  • Chapter 20 : Sample Exam
    1. Sample Exam Project 1
    2. Sample Exam Project 2
    3. Sample Exam Project 3
    4. Sample Exam Project 4
    5. Sample Exam Project 5
    6. Sample Exam Project 6
  • Chapter 21 : Associate Access 77-730 Optional Lectures
    1. Create a Blank Desktop Database
    2. Create a Database from a Template
    3. Compact and Repair a Database
    4. Back Up a Database
    5. Split a Database
    6. Encrypt a Database with a Password
    7. Recover Data from Backup
    8. Create a Table
    9. Create a Form
    10. Create a Form from a Template with Application Parts
    11. Create a Report Based on the Query or Table and in Design View
    12. Create a Report Using the Report Wizard

Download MO-500 Microsoft Access Expert Certification from below links NOW!

Similar cases