
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
Learning Modules
201: Importing Data and Table Analyzer

202A: Creating Basic Queries

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

203: Calculations in Queries
204: Crosstab, Unmatched, and Duplicates Queries

205: Parameter and Action Queries

206: Understanding Form/Design View

207: Changing the Form Record Source
209: Creating a Form and Subform
Available Services
The following services are available to ensure your learners' success!
Upon request, the instructor will sign a non-disclosure agreement so learners can open working files during training.
Delivery Options
Let us help you choose the right delivery option to optimize your time and money.
Upon request, the instructor will sign a non-disclosure agreement so learners can open working files during training.
Technical Information
In our Training Portal, learners access DJL Training laptops for live online hands-on training.

Dual Screens
For the best learning experience in our instructor-led training portal, we recommend learners use two screens for training.
- On the Remote Lab screen, learners will complete training exercises under the watchful eye of their instructor.
- 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.

Training Manual
Recommended book - ACC19 Part 2 (LL)