Microsoft Access 2019

Our Access 2019 courses will give learners a comprehensive understanding of Access 2019, including how to design and create an Access database from scratch, and create and work with tables, queries, forms, and reports. We offer Access training for everyone from novices to power users.

Part 1 of 5

Access 2019 ​Part 1

Access 2019 Part 1 is designed to provide learners with the knowledge and skills they need to eventually become an expert in Microsoft Access. The ideal learner needs to create a new database or maintain an existing database. In this course, learners will to learn how to design and create a fully functional database from scratch. Learners will create tables, set field properties, create input masks and lookup fields, understand relationship types, create junction tables, and create relationships between tables.


To ensure success in this course, learners should have a working knowledge of another Microsoft application and be ready to apply the knowledge they will gain in this course to an Access database. Previous database experience is not required. Learners should also:
  • Be familiar with using personal computers
  • Have experience using a mouse and keyboard 
  • Be comfortable working in Windows
  • Know how to open and close applications
  • Know how to navigate basic file structures
  • Know how to manage files and folders

12 hours

Course ID: ACC19-P1

Request Training
Modules
Available Services
Delivery Options
Technical Info
Modules

Learning Modules

101: What Is Microsoft Access

An optional exercise in class, this module is for new Access learners who have not opened an Access database before. In this independent exercise, learners will tour an existing database observing tables and their relationships, and forms. Learners will tour an existing database and gain an understanding of the benefits, features, and purpose of an Access database. This module is offered as a 30-min video lesson to new Access learners.
102: The Database Development Life Cycle
For learners who wish to learn how to plan and start creating a database. In this module, learners will advance through the eight steps of the database development life cycle; plan a database, gather requirements, develop a conceptual, logical, and physical design, conduct testing, implement and rollout the database, and provide ongoing support. Learners will also identify fields and tables, identify data types and set primary keys. As this is part of the planning stage, learners will complete this module on paper. In this module, learners will also be introduced to Access templates.
103A: Creating Tables

For learners who understand the database development life cycle and wish to learn about table guidelines and learn how to create tables. In this module, learners will examine database table guidelines and review the requirements gathered for the database they will create in class and brainstorm on how to accomplish the goal. Learners will also create tables, set data types, enter field descriptions, and get an introduction to primary keys and table relationships.
103B: Modifying Tables
For learners who know how to create a table and wish to learn how to modify tables. Time permitting, in this module, learners will add, remove, rearrange fields in design and datasheet view. This module is offered as a 30-min video lesson for new Access learners.
103C: Setting Field Properties
For learners who know how to create and modify tables and wish to understand field properties. In this module, learners will set field properties, enter test data, and observe the effect and impact of field properties.
103D: Creating Input Masks 
For learners who know how to create and modify tables, set field properties and primary keys and wish to protect the integrity of their data by creating input masks. In this module, learners will create field input masks to help users enter data correctly into forms. 
103D: Creating Lookup Fields

For learners who know how to create and modify tables, set field properties and primary keys, and create input masks and lookup fields and wish to protect the integrity of their data by creating lookup fields. In this module, learners will create create lookup fields to make it easier for users to enter data in a field.
104A: Understanding Relationship Types
For learners who know how to create tables, set field properties and primary keys, and create input masks and lookup fields and wish to gain an in-depth understanding of database relationship types. In this module, learners will learn how to identify related tables and know their relationship type.
104B: Adding Tables to the Relationship Window
For learners who know how to create tables, set field properties and primary keys, and understand relationships types, and wish to add tables to the relationship window. Time permitting, in this module, learners will add tables to the Relationship window.
104C: Creating Junction Tables
For learners who know how to create tables, set field properties, create primary and foreign keys, and understand relationships types, and wish to recognize many-to-many relationships and learn how to create them. In this module, learners revisit the database requirements will create junction tables, add foreign keys to related tables, and create many-to-many relationships.
104D: Creating Relationships
For learners who know how to create tables, set field properties, create primary and foreign keys, understand relationships types, and junction tables and wish to relates in a database. In this module, learners will relate tables in a database.
Available Services

Available Services

The following services are available to ensure your learners' success!

Pre-assessments

Measure your learners' knowledge of course material before training

User Forums

Learners Q&A with their instructor in private user forums

Post-assessments

Measure your learners' knowledge of course material after training

Certificate of Completion

Learners download a certificate upon successful completion of the course

Skill Builders

Immediately after the concept discussion, learners complete real-world exercises by following detailed, step-by-step guidance from the instructor

Skill Sharpeners

Learners complete additional in-class, hands-on exercises with moderate assistance from the instructor

Skill Challengers

In this graded exercise, the instructor tests learners’ skills by describing the correct results without providing specific instructions on how to achieve them

Skill Masters

In this graded exercise, learners demonstrate their skills and creativity to achieve the results they envision based on generic instructions

Micro Quizzes

Enhance the transfer of learning with micro quizzes designed to boost your training ROI

Video Conference

Learners interact with their instructor in live video

Open Lab

An instructor will answer learners' spontaneous software questions at your place of business

eLearning Content

Learners access eLearning content anytime, anywhere

Video Library

Learners access training videos anytime, anywhere

Deskside Support

Learners receive onsite follow-up support

Upon request, the instructor will sign a non-disclosure agreement so learners can open working files during training.

Delivery Options

Delivery Options

Let us help you choose the right delivery option to optimize your time and money.

Instructor-led Training

Traditional instructor-led hands-on training in a classroom setting. 

eLearning

Learners access our eLearning content anytime, anywhere.

Seminar/Demo

Modules can be delivered seminar-style to maximize your class size and minimize employee downtime.

Live Online

Learners participate in real-time training via live video and audio feeds from the convenience of their desktops or tablets.

Deskside Training

Learners receive individual, personalized instruction at their desks to increase their productivity.

Upon request, the instructor will sign a non-disclosure agreement so learners can open working files during training.

Technical Info

Technical Information

In our Training Portal, learners access DJL Training laptops for live online hands-on training.

System Requirements

Learners' PCs should meet the following requirements: 

  • 2 GB of available hard disk space 
  • SVGA monitor at 1024 × 768 or higher resolution
  • A version of Windows support by Microsoft
  • The latest version of Chrome browser (preferred browser)

Dual Screens

For the best learning experience in our instructor-led training portal, we recommend learners use two screens for training.

  1. On the Remote Lab screen, learners will complete training exercises under the watchful eye of their instructor.
  2. On the Virtual Classroom screen, learners will see and hear their instructor as they follow the instructor's step-by-step directions. The virtual classroom screen can be a big screen in a conference room or a learner's second monitor.

Instructor-led Portal System Check

Our system check will check the readiness of your learners' browser, internet connectivity, screen resolution, microphone and camera. The test link will be provided to you prior to your class.

Training Manual

Recommended book - ACC19 Part 1 (LL)

DJL Training, Inc. | PO Box 72362 | Durham NC 27722 | www.djltraining.com | firstclass.djltraining.com

(c) Copyright 2010-2019 | All Rights Reserved