Access Advanced: Formulas, Forms and Reports

Selected Date [ See all available dates ]

Friday, March 30, 2018
9:00 AM - 4:00 PM*
Trainer: Chris
How would you prefer to attend?
*All times are in the US/Pacific timezone.
[See all available dates]

Class Details

Price per person:$349
Length of class:one day
Version covered:2016 for Windows


In this one-day course, you will learn how to write formulas, creating calculated fields, doing math with dates, and writing expressions in queries and validation rules. You will also create sophisticated data entry forms, including navigation forms and subform containers. Finally, you will design reports and subreports, including using variables as report filters.


This class is ideally suited for people who have taken our Access Intermediate training class or have a year or more of experience using Access.


Writing Formulas (Expressions)
- calculated fields
- math with dates
- formulas in queries
- formulas in validation rules
- formulas that use relationships

- create a simple data form
- layout view
- layout grids
- design view
- datasheet forms
- navigation forms
- subform containers
- combo boxes as filters

- reports and subreports
- temporary variables
- using temp variables as report filters

Printable Course Description