Course 55279-A: Introduction to Microsoft Access 2019

This Introduction to Microsoft Access 2019 training class starts by covering basic database concepts. Students will then learn to design and create databases and tables, query those tables, and create forms and reports.

Audience profile

This course is intended for students who have little or no familiarity with Microsoft Access 2019 or more experienced Access users who want to learn the topics covered in this course in the 2019 interface.

Job role: Developer

Skills gained

  • Gain an understanding of database concepts and terminology.
  • Learn about the Access interface.
  • Learn to work with table views, queries, forms, reports, and macros and modules.

Prerequisites

  • 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.

Course outline

Module 1: Quick Overview of the Access User Interface

This module explains how to become familiar with the Access user interface.

Lessons

  • Access Ribbon
  • Quick Access Toolbar
  • Object Navigation Pane
  • Access Work Surface
  • Object Overview
  • Process Overview
  • Create a Database Using a Wizard

Lab : Getting Around the Access Environment

After completing this module, students will be able to:

  • Understand the organization of the Access ribbon.
  • Understand context tabs in the ribbon.
  • Understand the Quick Access Toolbar and how to customize.
  • Understand the Navigation Pane.
  • Understand the objects and creation ...