55279: Introduction to Microsoft Access 2019 Training

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 1: 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 it.

Understand the Navigation Pane.

Understand the objects and creation process.

Understand the Access work surface.

Understand how to create databases using a wizard.

This module explains how to think about some database fundamentals before diving into database creation.

Lessons

Questions to Ask Before You Start

Approaches to Database Design

Gathering Information

A Few Words about Naming Conventions

Normalization

Table Relationships

Lab 1: Fundamentals Exercises

Asking Questions

Normalizing Data

After completing this module, students will be able to:

Ask questions to consider before you create a database application.

Understand common approaches to database design: top-down and bottom-up.

Go from paperwork and data samples to categorized data (data mapping).

Understand naming conventions for tables and other objects.

Understand what normalization is.

Understand some basic concepts of normalization and how to apply them.

Understand primary and foreign keys.

Understand relationships and establish them among tables.

This module explains how to work with tables and their views in Microsoft Access.

Lessons

Definition and Purpose

Datasheet View

Design View

Lab 1: Working with Tables in Datasheet View

After completing this module, students will be able to:

Understand tables and table views in Access.

Work with tables in Datasheet view.

Add and Edit data records in the Datasheet view.

Understand the purpose of the Design view.

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

Lessons

Creating an Access Database

Data Types

Create a Table in Design View

Lab 1: Tables Exercises

Creating a New Database

Determining Data Types

Creating a Table in Design View

After completing this module, students will be able to:

Create an Access database.

Create a table in the Design view.

Understand data types.

Assign a key field.

Understand input masks.

Use expressions to define validation rules.

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

Lessons

Queries

Select Queries

Select Queries with Criteria

Logical Operators

Group and Total with Queries

Lab 1: Creating Select Queries

After completing this module, students will be able to:

Use queries and query views.

Create a simple query.

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

Lessons

Forms

Alter a Form

Form Record Navigation

Layout View and Design View

One-click Forms

Form Wizard

Lab 1: Forms Exercises

Adding Data Records in Form View

Creating a Form with the Form Wizard

After completing this module, students will be able to:

Understand types of forms.

Add records using a form.

Understand one-click forms.

Create a form using the Form Wizard.

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

Lessons

Reports

Report Wizard

Lab 1: Creating a Report with the Report Wizard

After completing this module, students will be able to:

Understand reports.

Use the one-click report.

Use the Report Wizard to create reports.