Course 55280-A: Advanced Microsoft Access 2019

This Advanced Access 2019 training class is for students who intend to design databases at an advanced level and/or want to improve existing Access 2019 or Access 365 databases.

Audience profile

This course is intended for students who have basic skills with Microsoft Access 2019 who want to learn advanced-level skills or students who want to learn the topics covered in this course in the 2019 interface.

Job role: Developer

Skills gained

  • Understand database relationships.
  • Work with table relationships.
  • Work with queries at an advanced level.

Prerequisites

  • Introductory-level knowledge and skills working with Microsoft Access.

Course outline

Module 1: Relationships

This module explains how to work with relationships in Microsoft Access.

Lessons

  • Review
  • Referential Integrity
  • Relationships
  • A Few Words about Naming Conventions

Lab : Installing and Configuring Windows 7

After completing this module, students will be able to:

  • Understand referential integrity.
  • Establish relationships between tables.

Module 2: Queries

This module explains how to work with queries in Microsoft Access.

Lessons

  • Query Design View
  • Review of Select Queries
  • Review of Select Queries with Criteria
  • Logical Operators
  • Parameter Queries
  • Action Queries

Lab : Quer...