55279-A: Introduction to Microsoft Access 2019 Course

Introduction to Microsoft Access 2019 ( 55279-A) Certification Training Course Overview

Enroll for 2-day Introduction to Microsoft Access 2019 certification training course from Koenig Solutions accredited by Microsoft. This course cover basic database concepts. Students will then learn to design and create databases and tables, query those tables, and create forms and reports.

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

Learning Objectives:

After completing this course, you 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.

 

 

 

55279-A: Introduction to Microsoft Access 2019 Course (Duration : 16 Hours) Download Course Contents

Live Virtual Classroom
Group Training 850
08 - 09 Aug 09:00 AM - 05:00 PM CST
(8 Hours/Day)
06 - 07 Sep 09:00 AM - 05:00 PM CST
(8 Hours/Day)
04 - 05 Oct 09:00 AM - 05:00 PM CST
(8 Hours/Day)
1-on-1 Training (GTR) 950
4 Hours
8 Hours
Week Days
Week End

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here Hire Our Trainers! Click here

Customers who bought this course also bought

• AZ-303: Microsoft Azure Architect Technologies
• AZ-304: Microsoft Azure Architect Design
• AZ-400T00-A: Designing and Implementing Microsoft DevOps solutions
• AZ-500: Microsoft Azure Security Technologies
• DA-100 Analyze Data with Power BI
• AZ-204: Developing Solutions for Microsoft Azure
• AZ-104T00-A: Microsoft Azure Administrator
• AZ-900T01: Microsoft Azure Fundamentals (1 day)
• DP-203T00: Data Engineering on Microsoft Azure
• Microsoft Power Platform Fundamentals

Course Modules

Module 1: Quick Overview of the Access User Interface
  • Access Ribbon
  • Quick Access Toolbar
  • Object Navigation Pane
  • Access Work Surface
  • Object Overview
  • Process Overview
  • Create a Database Using a Wizard
  • Getting Around the Access Environment
Module 2: Fundamentals
  • Questions to Ask Before You Starat
  • Approaches to Database Design
  • Gathering Information
  • A Few Words about Naming Conventions
  • Normalization
  • Table Relationships
  • Fundamentals Exercises
Module 3: Tables and Their Views
  • Definition and Purpose
  • Datasheet View
  • Design View
  • Working with Tables in Datasheet View
Module 4: Tables
  • Creating an Access Database
  • Data Types
  • Create a Table in Design View
  • Tables Exercises
Module 5: Queries
  • Queries
  • Select Queries
  • Select Queries with Criteria
  • Logical Operators
  • Group and Total with Queries
  • Creating Select Queries
Module 6: Forms
  • Forms
  • Alter a Form
  • Form Record Navigation
  • Layout View and Design View
  • One-click Forms
  • Form Wizard
  • Forms Exercises
Module 7: Reports
  • Reports
  • Report Wizard
  • Creating a Report with the Report Wizard
Download Course Contents

Request More Information

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