There are no dates currently on the schedule for this course.
| Price per person: | $349 |
| Length of class: | one day |
| Version covered: | 2016 |
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
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