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

Access 2019 ​Part 4

Access 2019 Part 4 consists of expert-level modules designed by DJL Training for experienced Access 2019 users who wish to take their Access skills to the next level.


To ensure success in this course, learners should be advanced users who have completed Access 2019 Part 1, 2, and 3 or have equivalent knowledge and experience.

6 hours

Course ID: ACC19-P4

Modules
Available Services
Delivery Options
Technical Info
Modules

Learning Modules

401: Creating a Basic Search Form
For advanced Access learners who know how to create a database, queries, forms, and reports, and wish to create a basic search form. In this expert level module, learners will create text boxes, create command buttons, program form buttons, edit search query, and add finishing touches.
402A: Creating a Login Form
For Advanced Access learners who know how to create a database, queries, forms, and reports, and wish to create a simple login form to protect a database from invalid access. In this expert level module, learners will create a login table, run the Input Mask Wizard, creating a login form, add an On Click event to the Login button, and set the login form as the start up form.
402B: Customizing the Ribbon
For Advanced Access learners who know how to create a database, queries, forms, and reports, and wish to customize the Ribbon in order to make an application easier to use. In this advanced level module, learners will understand Ribbon customization techniques, create and apply a custom Ribbon, add Ribbon customization XML to the USysRibbons table, apply the custom Ribbon, and restore the default Ribbon.
403: Conditional Formatting
For Advanced Access learners who know how to create a database, queries, forms, and reports, and wish to format data conditionally. In this module, learners will learn how to apply conditional formatting to data.
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

Online materials provided

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

(c) Copyright 2010-2019 | All Rights Reserved