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 Online Training
Group Training 850
27 - 28 Dec GTR 09:00 AM - 05:00 PM CST
(8 Hours/Day)
03 - 04 Jan 09:00 AM - 05:00 PM CST
(8 Hours/Day)
1-on-1 Training (GTR) 950
4 Hours
8 Hours
Week Days
Weekend

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
Buy Flexi For Only $99 (Online Training Re-imagined)

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.