Course 55279-A: Introduction to Microsoft Access 2019

Course Modality

Instructor-led (classroom)

Course Level

Beginner

Course Time

2 days

Course Language

English

Course Overview

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.

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.

Intended Audience

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.

Why The DataTech Labs ?

Self-Paced Online Video

A 360-degree learning approach that you can adapt to your learning style

A 360-degree learning

Engage and learn more with these live and highly-interactive classes alongside your peers

24/7 Teaching Assistance

24/7 Teaching Assistance Keep engaged with integrated teaching

Online Practice Labs

Projects provide you with sample work to show prospective employers.

Applied Projects

Real-world projects relevant to what you’re learning throughout the program

Learner Social Forums

A support team focused on helping you succeed alongside a peer community

Skill Covered

After completing this course, students will be able to:

  • 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. 
  • Learn to plan a database. 
  • Learn database design fundamentals. 
  • Learn to work with forms and the Form Wizard. 
  • Learn to work with reports and the Report Wizard.

Get In Touch

Course Curriculum

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 process.
  • Understand the Access work surface.

Understand how to create databases using a wizard.

Fundamentals

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

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

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

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 : Creating Select Queries

After completing this module, students will be able to:

  • Use queries and query views.
  • Create a simple query.

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

Reports

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

Lessons

  • Reports
  • Report Wizard

 

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

Reviews

Get in touch, enquire now!


By submitting this form, I consent to the processing of the personal data that I provide The Data Tech Labs Inc. in accordance with and as described in the Privacy Policy.

© 2020 The Data Tech Labs Inc. All rights reserved.

TDTL-arrow
[glt language="Arabic" label="Arabic" image="yes" text="yes" image_size="24"]
[glt language="English" label="English" image="yes" text="yes" image_size="24"]
[glt language="French" label="French" image="yes" text="yes" image_size="24"]
[glt language="German" label="German" image="yes" text="yes" image_size="24"]
[glt language="Hindi" label="Hindi" image="yes" text="yes" image_size="24"]
[glt language="Marathi" label="Marathi" image="yes" text="yes" image_size="24"]
[glt language="Spanish" label="Spanish" image="yes" text="yes" image_size="24"]

Microsoft Power Platform App Maker

Designing & Implementing Azure AI Solution

Microsoft Azure Administrator

Developing Solutions For Microsoft Azure

Microsoft Azure Architect Design Exam

Implementing Azure Data Solution

Administering Relational Databases On Microsoft Azure