Course 55279-A: Introduction to Microsoft Access 2019

Microsoft

Course 55279-A: Introduction to Microsoft Access 2019

Share This Learning Path

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.

Prerequisites

Course outline

Module 1: Quick Overview of the Access User Interface

Module Overview

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 Sessions

Getting Around the Access Environment

Lab Lessons

Lab lessons not available

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 process.
Understand the Access work surface.
Understand how to create databases using a wizard.

Module 2: Fundamentals

Module Overview

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

Lessons

Questions to Ask Before You Starat
Approaches to Database Design
Gathering Information
A Few Words about Naming Conventions
Normalization
Table Relationships

Lab Sessions

Fundamentals Exercises

Lab Lessons

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 establishing them among tables.

Module 3: Tables and Their Views

Module Overview

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

Lessons

Definition and Purpose
Datasheet View
Design View

Lab Sessions

Working with Tables in Datasheet View

Lab Lessons

Lab lessons not available

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 Datasheet view.
Understand the purpose of Design view.

Module 4: Tables

Module Overview

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 Sessions

Tables Exercises

Lab Lessons

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 Design view.
Understand data types.
Assign a key field.
Understand input masks.
Use expressions to define validation rules.

Module 5: Queries

Module Overview

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 Sessions

Creating Select Queries

Lab Lessons

Lab lessons not available

After completing this module, students will be able to:

Use queries and query views.
Create a simple query.

Module 6: Forms

Module Overview

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 Sessions

Forms Exercises

Lab Lessons

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.

Module 7: Reports

Module Overview

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

Lessons

Reports
Report Wizard

Lab Sessions

Creating a Report with the Report Wizard

Lab Lessons

Lab lessons not available

After completing this module, students will be able to:

Understand reports.
Use the one-click report.
Use the Report Wizard to create reports.

Book Your Seat

Find Learning Paths

Course 20703-1-B: Administering System Center Configuration Manager

Join our community of certified professionals

About Us

ICTC is the leader in technical certification courses and exams. Our labs consist of a latest tech PCs and our instructors are certified from each vendor

Policy for the Prevention and Combating of Violence and Harassment in the Workplace.

Learn

View all the provided certifications and there relevant courses. Book online for a certification exam.

Contact Us

International Computer Training Center