Part 2 | 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 2 of 5

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

Request Training

Course Files

Modules

Available Services

Delivery Options

Technical Info

Modules

Learning Modules

201: Importing Data and Table Analyzer

For learners who know how to create a database and wish to learn how to import data and run the table analyzer. In this module, learners will import data into the database they created in Part 1. Learners will also run the Table Analyzer Wizard to split the original table into a set of related tables.

202A: Creating Basic Queries

For learners who know how to create a database and wish to learn how to create single-table and multi-table queries, and add criteria to queries. In this module, learners will create queries using the query wizard and using query design. Learners will also create multi-table queries and add criteria to the query design grid.

202B: Wildcards, Dates, Multiple Criteria, and Limited Records in Queries

For learners who know how to create a database and basic queries, and wish to add multiple criteria to queries, including wildcards and date criteria. In this module, learners will create multiple criteria queries to locate records that match a pattern, set criteria to find records within a specific date range, and limit the number of records in a query.

203: Calculations in Queries

For learners who know how to create a database and advanced queries, and wish to create calculations in queries. In this module, learners will create calculations and use functions to perform calculations in queries.

204: Crosstab, Unmatched, and Duplicates Queries

For learners who know how to create a database and advanced queries, and wish to create crosstab, unmatched, and duplicates queries. In this module, learners will create a crosstab query which is equivalent to a PivotTable in Excel. Learners will also run the Find Duplicates wizard to find duplicate records within a table, and run the Find Unmatched query to locate records in a child table which have no related record in a parent table.

205: Parameter and Action Queries

For learners who know how to create a database and advanced queries, and wish to create parameter queries and action queries. In this module, learners will use parameters to ask for input when running a query and create action queries to perform actions on the data in a database, including make a table, append data, update data, and delete data.

206: Understanding Form/Design View

For learners who know how to design and create a database, create queries, and wish to gain a deep understanding of forms in form view and design view. In this module, learners will explore table relationships, and examine forms in form view and design view. Learners will also change the record source of a form and explore the results.

207: Changing the Form Record Source

For learners who know how to design and create a database, create queries and forms, and wish to learn how to change the record source of a form. In this module, learners will create a form containing a subform, change the record source of a form, and explore the results.

208: Understanding Form Properties

For learners who know how to design and create a database, create queries, and wish to understand form properties. In this module, learners will observe the cause and effects of changing form properties.

209: Creating a Form and Subform

For learners who know how to design and create a database, create queries, and wish to create, format and modify a form with a subform. In this module, learners will run the form wizard to create a form with a subform. This module will also cover formatting and modifying a form and subform.

Available Services

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