Access 2016 Intermediate Training Courses – Online or Face to Face

Duration: 1 Day

Course Objective:

To build on some existing database design and/or user experience that may have been gained from the Introduction course.

Course Contents:

Action Queries

• Types Of Query
• The Crosstab Query
• The Make Table Query
• The Append Query
• The Delete Query
• The Update Query

Customising Forms

• Manipulating Data in the Form
• Creating A New Form
• Using the Form Wizard
• Creating a Form With a Subform
• Modifying and Redesigning the Form

Reports

• The Report Wizard
• Creating a Report With Summary Totals
• Using the Label Wizard
• Modifying and Redesigning the Report.
• Publishing Access Data on the Web

Protecting Desktop Databases with Backup and Restore Processes

• Why do I need a backup?
• Creating a database backup
• Creating a Split Database
• Backing up back-end database and 
• front-end database
• Restoring a database

What our attendees have said about us: