Microsoft

Master Database Management with MS Access 2019

Prepare & practice for the MO-500 exam with this MS Access course.

(MO-500.AI1) / ISBN : 978-1-64459-208-3
Lessons
Lab
TestPrep
AI Tutor (Add-on)
Instructor Led (Add-on)
22 Reviews
Get A Free Trial

About This Course

The Microsoft Access 2019 (MO-500) is a comprehensive training course that teaches you the skills needed to effectively create, manage, and analyze databases using Access. The course content is in sync with the MO-500 exam objectives, focusing on developing your knowledge and ability to create and maintain Access Database objects including tables, relationships, data entry forms, multi-level reports and multi-table queries. It has a prep engine with hands-on Labs which provide different sets of questions to prepare for the exam in the test environment. After completing this Microsoft Access 2019 course you’ll know how to manage databases, create and modify tables, create and modify queries, modify forms in layout view, and modify reports in layout view.

Skills You’ll Get

  • Core understanding of database concepts: tables, fields, and relationships
  • Use queries for data manipulation to select, insert, update, and delete data
  • Design and create forms for data data entry, modification, and display
  • Generate and format reports for data analysis and presentation
  • Optimizing query by using techniques like indexing, grouping, and calculated fields
  • Ability to customize forms and enhance detailed reports
  • Utilizing macro programming for automating and streamlining repetitive tasks
  • Skilled with maintenance tasks including compacting, repairing, and restoring databases 
  • Awareness of security best practices to protect data

Get the support you need. Enroll in our Instructor-Led Course.

Download Course Outline

1

Introduction

  • Course setup
2

Database fundamentals

  • Module A: Understanding general database terms
  • Module B: Relational databases
  • Module C: Access interface and objects
  • Summary
3

Tables

  • Module A: Creating tables
  • Module B: Creating fields
  • Module C: Data Validation
  • Module D: Relationships and keys
  • Summary
4

Queries

  • Module A: Creating basic queries
  • Module B: Modifying queries
  • Module C: Using calculated fields
  • Summary
5

Forms

  • Module A: Creating simple forms
  • Module B: Form design
  • Module C: Form controls
  • Summary
6

Reports

  • Module A: Creating Reports
  • Module B: Report controls
  • Module C: Formatting reports
  • Summary
7

Introduction

  • Course setup
8

Advanced queries

  • Module A: Grouping and summarizing
  • Module B: Updating, deleting, and relationships
  • Module C: Indexing for performance
  • Summary
9

Advanced forms

  • Module A: Subforms
  • Module B: Advanced control types
  • Module C: Specialized form types
  • Summary
10

Advanced reports

  • Module A: Subreports
  • Module B: Advanced grouping
  • Module C: Advanced formatting
  • Summary
11

Macros

  • Module A: Creating basic macros
  • Module B: Using variables
  • Module C: Troubleshooting macros
  • Summary
12

Database management

  • Module A: Compact & Repair
  • Module B: Restoring a database
  • Module C: Other maintenance tasks
  • Summary

1

Database fundamentals

  • Exploring a Query
  • Importing a Flat File
  • Creating a Database from a Template
  • Using the Navigation Pane
2

Tables

  • Creating a Blank Table
  • Deleting a Table from a Database
  • Renaming a Table
  • Changing the Form Header using the Caption Property
  • Creating a Primary Key
  • Adding a Field in Datasheet View
  • Modifying Fields in Design View
  • Adding Records to a Database Table
  • Creating and Formatting a New Table
  • Changing Date/Time Controls
  • Creating a Table-level Validation Rule
  • Setting the Required and Default Value Properties
  • Setting Validation Rules
  • Creating a Relationship Between Tables
3

Queries

  • Creating a Select Query
  • Creating an Append Query
  • Saving a Filter as a Query
  • Creating a Totals Query
  • Creating an Update Query
  • Modifying a Query
  • Formatting a Query
  • Sorting a Query
  • Creating a Make Table Query
  • Creating a Delete Query
  • Adding the Criteria
  • Creating a Crosstab Query
  • Using Date Ranges in a Report
  • Using Calculated Fields
4

Forms

  • Creating and Viewing a Form in Form View
  • Creating a Form Using the Form Wizard
  • Designing a Form
  • Creating a Split Form
  • Adding Form Controls
  • Adding List Controls and Command Buttons
  • Changing the Layout of Controls
5

Reports

  • Creating a Basic Report
  • Creating a New Report and Binding it to a Query
  • Creating a Report Using the Report Wizard
  • Controlling a Report's Data Source
  • Manipulating Controls in a Report
  • Creating Labels Using the Label Wizard
  • Creating a Calculated Field
  • Formatting a Report and an Image
  • Grouping a Report and Adding a Group Summary Calculation
  • Working with Themes
6

Advanced queries

  • Grouping and Summarizing Data
  • Using the WHERE Clause
  • Performing Cascading Updates and Deletions
  • Deleting a Record
  • Indexing a Table
7

Advanced forms

  • Creating a Subform and Linking Forms
  • Creating a Chart Using the Chart Wizard
  • Inserting a Background Image in a Form
  • Working with Advanced Form Controls
8

Advanced reports

  • Creating Unrelated Subreports
  • Adding a Related Subreport to an Existing Report
  • Creating a Subreport with the Same Record Source as the Main Report
  • Sorting a Field of Reports
  • Adding Running Sums to a Report
  • Using the Report Formatting Options
9

Macros

  • Creating a Data Macro
  • Creating an Embedded Macro
  • Creating a Macro
  • Exporting Objects to Other Access Databases
  • Debugging a Macro
10

Database management

  • Running Compact & Repair
  • Restoring an Access Database
  • Using Print Preview to Create a Print Layout
  • Performing the Maintenance Tasks

Any questions?
Check out the FAQs

Get a glimpse of the most common doubts regarding this Microsoft Access 2019 certification training here.

Contact Us Now

It is an online preparatory course that helps you prepare and practice for the MO-500 certification exam. Everything from the course content to the training Lab exercises are 100% aligned with the certification exam.

Mo-500 is a certification exam conducted by Microsoft to validate the database management skills of an individual. The exam covers a wide range of topics, including: database management, table creation and management, query design, form design, report creation, and advanced database management topics like using subforms, advanced controls, and specialized form types.

The exam format is MCQ. You’ll have to select the most appropriate answer from the given options.

Yes, there is a time limit. You’ll have to complete the exam within 50 minutes.

The exam fee is $100.

The estimated salary range is anywhere between $37,500 to $121,000 annually depending on experience, organization and location.

Related Courses

All Course
scroll to top