Part 3 | 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 3 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-P3

Request Training

Modules

Available Services

Delivery Options

Technical Info

Modules

Learning Modules

301: Adding Calculations to a Form

For learners who know how to create a database, queries and basic forms, and wish to add calculated fields to a form and subform. In this module, learners will sum line totals on a form, add a calculated field to a form, format a calculated control, add a calculated field to a subform, use the expression builder, and add the current date to a form.

302: Disabling Fields and Adding ScreenTips

For learners who know how to create a database, queries and forms, and wish to learn how to lock and disable form fields, and create control ScreenTips. In this module, learners will protect fields from being edited by locking and disabling them. Learners will also create descriptive onscreen messages for fields.

303: Creating and Modifying a Report

For learners who know how to create a database, queries and forms, and wish to learn how to create and modify basic reports. In this module, learners will create a report using the Report Wizard, explore report sections and controls, select a report layout and explore report views.

304: Formatting and Printing a Report

For learners who know how to create a database, queries, forms, and reports, and wish to apply advanced formatting to reports. In this module. In this module, learners will add a logo to the page header, add a report title, subtitle and format text, size, align, and format report controls, and apply a theme to a report.

305: Setting Access Options

For learners who know how to create a database, queries, forms, and reports, and wish to set Access options. In this module, learners will explore Access options, modify the navigation pane, set database properties, set current database options and change datasheet settings and the color scheme.

306A: Splitting a Database

For learners who know how to create a database, queries, forms, and reports, and wish to split a database that several people share over a network. In this module, learners will back up the database and launch the Database Splitter to help improve database performance and reduce the chance of database file corruption by moving tables from the current database to new back-end database.

306B: Creating a Switchboard

For learners who know how to create a database, queries, forms, and reports, and wish to create a switchboard, an alternative to the Navigation Pane. In this module, learners will launch the switchboard manager and create a switchboard to help users navigate the database. Learners will also add a command button to the switchboard and set a startup form.

306C: Creating a Navigation Form and Setting a Database Password

For learners who know how to create a database, queries, forms, and reports, and wish to create a navigation form to make it easy for users to switch between the various forms and reports and password protect their database. In this module, learners will create a Navigation Form, add horizontal tabs, add items to the tabs, and edit tab titles. Learners will also add limited security to a database by encrypting it and setting a password.

308: Integrating With Word and Excel

For learners who know how to create a database, queries, forms, and reports, and wish to explore how to share Access data with other Microsoft Office programs, as well as how to format Access data for other systems and for the web. In this module, learners will integrate Access with Word, integrate Access with Excel, and display Access Data on the Web.

Available Services

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