Access Advanced: Formulas, Forms and Reports

Selected Date [ See all available dates ]

Friday, October 27, 2017
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

Description

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.


Prerequisites

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


Outline

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

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

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


Printable Course Description