55279: Introduction to Microsoft Access 2019 Training

Category

MS Office

Rating
4.7
(4.7)
Price

$499
Per Participant

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

  • Virtual Live Training

Jun 15, 2023

9:00 am - 5:30 pm EST
Online
Request Batch

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

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

    Request Call

    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.

    • 300+ enterprise clients
    • 100,000+ professionals trained
    • Service 70 of the Fortune 100
    • 96% of our clients would recommend us
    our clients

    Our Awards

    our awards
    why choose us
    Accredited By
    img-microsoft-office-access-2019-part-1.png

    Course Details

    • Start Date: Jun 15, 2023
    • Duration: 2 Days
    • Enrolled: 1432
    • Price: $499
    side post side mode

    Talk to Learning Advisor