Part 1 | DJL Training, Inc

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.

Catalog > Microsoft > Access

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

Course Files

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

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