Access Intermediate - $109
Query multiple tables. Create Parameter Queries that do the work of many different queries. Perform multiple sorts using more than one criteria.
Create, edit, and delete relationships (links between different tables.) Learn about one-to-one, one-to-many, and many-to-many relationships.
Create macros that automate basic actions such as running queries and reports, finding data, etc.
Create forms with sub-forms. Add buttons to forms to run macros. EXPRESSIONS / CALCULATED FIELDS:
Use expressions to perform calculations in queries, forms, and reports. Add, subtract, multiply, and divide numeric data.
SWITCHBOARD (MAIN MENU):
Create a Switchboard (or main menu) with buttons to organize your tables, macros, queries and forms into one central place.