55279: Introduction to Microsoft Access 2019 Training

Name: 55279: Introduction to Microsoft Access 2019 Training
Brand: Microtek Learning
Price: $499
Rating: 4.7 (231 reviews)

Course Description

Basic database topics are covered at the beginning of this Introduction to Microsoft Access 2019 training course. After that, they will discover how to design databases, make tables, query those tables, and produce forms and reports.

Prerequisites for this training

Working knowledge of how to use a computer, mouse, and keyboard.
An agreeable Windows environment.
The capacity to run programs, shut them down, navigate to on-screen information, and organize files and folders.

Who should attend this course?

Students with little to no experience with Microsoft Access 2019 or expert Access users who want to learn the concepts taught in this course with the 2019 interface are the target audience for this course.

Microsoft Certified Partner

Microtek Learning is a Microsoft Certified Partner for Learning Solutions. This class uses official Microsoft courseware and will be delivered by a Microsoft Certified Trainer (MCT).

Schedules

Jun 15, 2023

9:00 am - 5:30 pm EST

Online

ENROLL NOW

What you will learn

Acquire knowledge of terminologies and database concepts.
Discover the Access user interface.
Work with forms, reports, macros, modules, table views, and queries.
Understand database planning.
learn the principles of database design.
Acquire knowledge on how to use forms and the Form Wizard.
Become familiar with the Report Wizard and reports.

Curriculum

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

Module 2: Fundamentals

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.

Module 3: Tables and Their Views

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.

Module 4: Tables

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.

Module 5: Queries

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.

Module 6: Forms

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.

Module 7: Reports

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.

With Microtek Learning, you’ll receive:

Certified Instructor-led training
Industry Best Trainers
Official Training Course Student Handbook
Pre and Post assessments/evaluations
Collaboration with classmates (not available for a self-paced course)
Real-world knowledge activities and scenarios
Exam scheduling support*
Learn and earn program*
Practice Tests
Knowledge acquisition and exam-oriented
Interactive online course.
Support from an approved expert
For Government and Private pricing*

* For more details call: +1-800-961-0337 or Email: info@microteklearning.com

Our Clients

For many years, Microtek Learning has been helping organizations, leaders, and professionals to reach their maximum performance by addressing the challenges they are facing.