Microsoft Access 2019 MOS Certification Training

This course can be delivered live online, at your offices, or at any other location.

Join our Access instructor in a live classroom for this Microsoft Access 2019 MOS Certification Training course. Learn all of the content from our Introduction and Advanced Access courses, including all of the learning objectives on the Microsoft Office MOS certification exam. Get hands-on experience with Access as you prepare for the MOS exam with a live instructor.

This Microsoft Access MOS Certification Training course helps prepare students to take the following Microsoft Office MOS certification exam:

  1. Access 2019 certification exam MO-500

This course has been tested and approved by ProCert labs, the official tester of Microsoft courseware. The course has been found to meet the highest industry standards of instructional quality.

  Microsoft Certified Partner

Webucator is a Microsoft Certified Partner for Learning Solutions (CPLS). Our curriculum has been tested and approved by ProCert Labs, the official tester of Microsoft courseware, and has been found to meet the highest industry standards of instructional quality.

Goals
  1. Master Microsoft Access.
  2. Prepare for the Microsoft Access certification exam.
Outline
  1. Quick Overview of the Access User Interface
    1. Access Ribbon
      1. File
      2. Home
      3. Create
      4. External Data
      5. Database Tools
      6. Contextual Tabs
    2. Quick Access Toolbar
    3. Object Navigation Pane
    4. Access Work Surface
    5. Object Overview
      1. Tables
      2. Queries
      3. Forms
      4. Reports
      5. Macros and Modules
    6. Process Overview
    7. Exercise: Getting Around the Access Environment
    8. Create a Database Using a Wizard
  2. Fundamentals
    1. Questions to Ask Before You Start
      1. What is the purpose of the database?
      2. Who will use the database?
      3. What kind of output is needed from the database?
      4. What process is the database replacing or improving?
    2. Exercise: Asking Questions
    3. Approaches to Database Design
      1. Top-Down Database Design
      2. Bottom-Up Database Design
      3. Reality
    4. Gather Information
      1. Data Mapping
      2. Sample Data Map
    5. A Few Words about Naming Conventions
    6. Exercise: Gathering Information
    7. Normalization
      1. First Normal Form
      2. Second Normal Form
      3. Third Normal Form
    8. Table Relationships
      1. Relationship Types
    9. Exercise: Normalizing Data
  3. Tables and Their Views
    1. Definition and Purpose
    2. Datasheet View
      1. Selection Tools
      2. Table Layout Tools
      3. Sorting and Filtering Tools
      4. Print Records
      5. Record Navigation
      6. Working in Datasheet View
    3. Exercise:Working with Tables in Datasheet View
    4. Design View
      1. Open a Table in Design View
      2. Design View Layout
  4. Tables
    1. Creating an Access Database
    2. Exercise: Creating a New Database
    3. Data Types
    4. Exercise: Determining Data Types
    5. Create a Table in Design View
      1. Delete a Field
      2. Rename a Table
    6. Exercise: Creating a Table in Design View
  5. Queries
    1. Queries
      1. Definition and Purpose
      2. Types
      3. Views
    2. Select Queries
    3. Select Queries with Criteria
    4. Logical Operators
    5. Group and Total with Queries
      1. Totals Row with Group By
    6. Exercise: Creating Select Queries
  6. Forms
    1. Forms
      1. Definition and Purpose
      2. Views
    2. Alter a Form
      1. Delete Forms
      2. Remove Form Controls
      3. Format a Form
    3. Exercise: Adding Data Records in Form View
    4. Form Record Navigation
    5. Layout View and Design View
    6. One-Click Forms
      1. Basic Data Entry Form
      2. Basic Multi-Record Form
      3. Datasheet Form
      4. Split Form
    7. Form Wizard
    8. Create a Form with the Form Wizard
    9. Exercise: Creating a Form with the Form Wizard
  7. Reports
    1. Reports
      1. Definition and Purpose
      2. Views
      3. One-Click Report
    2. Report Wizard
      1. Create a Report Using the Report Wizard
    3. Exercise: Creating a Report with the Report Wizard
  8. Relationships
    1. Review
    2. Referential Integrity
    3. Relationships
      1. Data Types and Relationships
      2. Formalize the Relationship between Tables
    4. A Few Words about Naming Conventions
    5. Exercise: Creating Relationships
  9. Queries
    1. Query Design View
    2. Review of Select Queries
    3. Review of Select Queries with Criteria
    4. Logical Operators
    5. Parameter Queries
    6. Action Queries
      1. Make Table Queries
      2. Append Queries
      3. Update Queries
      4. Delete Queries
      5. Creating Crosstab Queries
      6. Delete a Query
      7. Rename a Query
    7. Exercise: Creating Select and Action Queries
    8. Exercise: Creating a Parameter Query
  10. Table Functions
    1. Importing Data
    2. Linking Tables from External Sources
    3. Import Tables from other Databases
    4. Tables from Templates and Application Parts
    5. Exercise: Importing Data from Excel
    6. Exercise: Exporting Data to Excel
  11. Forms
    1. Design View
      1. Form Sections
      2. Adding a Header and Footer
      3. Adding a Logo to the Header
      4. Adding a Title to the Header
      5. Adding Fields to a Form
      6. Arranging Fields on a Form
      7. Spacing Objects on a Form
    2. Formatting
    3. Tab Order
      1. Setting Properties on a Form
      2. Controls
    4. Create Forms with Application Parts
    5. Creating a Subform
    6. Exercise: Creating Forms
    7. Alter a Form
      1. Delete Forms
      2. Remove Form Controls
      3. Format a Form
  12. Reports
    1. Design View
    2. Report Sections
      1. Report Header
      2. Page Header
      3. Group Header
      4. Detail
      5. Group Footer
      6. Page Footer
      7. Report Footer
      8. Adding a Report Header/Footer
      9. Adding a Logo to the Report Header
      10. Adding a Title to the Report Header
      11. Adding Fields to a Report
      12. Add Calculated Fields
    3. Arranging Fields on a Report
    4. Resizing the Detail Section
      1. Eliminating Repeating Headings
      2. Set Margins
    5. Grouping and Sorting
    6. Setting Properties on a Report
      1. Report Property Sheet
      2. Section Property Sheet
      3. Object Property Sheet
      4. Adding Record Counts
    7. Special Report Fields
      1. Dates
      2. Page Numbering
    8. Controls
      1. Printing a Report
    9. Subreports
    10. Application Parts
    11. Deleting a Report
    12. Formatting a Report
      1. Adding a Background and Images and Applying a Theme
    13. Exercise: Creating Reports
  13. Macros
    1. Macro Basics
      1. Open a Table, Form, and Report
      2. Run a Query
      3. Print a Report
    2. Running a Macro
    3. Exercise: Creating Simple Macros
  14. Completing the Desktop Application
    1. The Navigation Form
    2. Running Macros from a Navigation Form
    3. Setting the Navigation Form as the Default Form
    4. Exercise: Creating a Navigation Form
    5. Splitting the Database
      1. Encrypt with a Password
    6. Distributing the Front-End Database
    7. Database Maintenance
      1. Compact and Repair
      2. Backup/Recover a Database
      3. Maintain Backward Compatibility
Class Materials

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.

Class Prerequisites

Experience in the following is required for this Microsoft Access class:

  • Familiarity with using a personal computer, mouse, and keyboard.
  • Comfortable in the Windows environment.
  • Ability to launch and close programs; navigate to information stored on the computer; and manage files and folders.

Training for your Team

Length: 4 Days
  • Private Class for your Team
  • Online or On-location
  • Customizable
  • Expert Instructors

This course is composed of the following classes, which you can sign up for individually.

Introduction to Microsoft Access 2019
Next Class: Jun 3-5, 2019 10AM-5PM ET

Advanced Microsoft Access 2019
Next Class: Jun 13-14, 2019 10AM-5PM ET

What people say about our training

Mark did an excellent job training. I would highly recommend Webucator to anyone looking to advance their knowledge with the various courses they offer.
Patty Ramirez
Golden Empire Mortgage
Instruction with Webucator has been the best training I have experienced in 25 years of IT courses. Thank you Webucator!!
Mandy Skinner
Employment Development Department (State of California EDD)
This webinar was a great tool for understanding Excel 2010. I am trying to get my boss to have more staff members take this class so we can all be on the same page, which will make sharing Excel spreadsheets a lot easier!
Lisa Drymon
BioResource International, Inc
Our instructor had a contagious enthusiasm equaled by her knowledge of the subject matter.
Diana Trankle
Canteen Vending

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing

62,570

Students who have taken Instructor-led Training

11,830

Organizations who trust Webucator for their Instructor-led training needs

100%

Satisfaction guarantee and retake option

9.29

Students rated our trainers 9.29 out of 10 based on 29,430 reviews

Contact Us or call 1-877-932-8228