55279: Introduction to Microsoft Access 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.