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

Access 2019 ​Part 2

Access 2019 Part 2 is for learners who know how to create a database from scratch and who have a deep understanding of database relationships. This course will cover importing data and running the Table Analyzer, creating basic queries, using wildcards in queries, working with multiple criteria, limiting records in queries, creating calculations, crosstab queries, finding unmatched and duplicate records, parameter and action queries. This course will also cover creating a form and subform, adding calculations to a form, changing the form record source, disabling fields and adding ScreenTips, creating and modifying a report, and formatting and printing a report.


To ensure success in this course, learners should have completed Access 2019 Part 1 or have equivalent knowledge and experience. 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-P2

Request Training
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 queriesIn 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

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 2 (LL)

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

(c) Copyright 2010-2019 | All Rights Reserved