Access Advanced: Formulas, Forms and Reports

There are no dates currently on the schedule for this course.

Class Details

Price per person: $349
Length of class:one day
Version covered:for Office 365


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.

Class Outline

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