Access Intermediate training Course

Duration:

2 days

Versions Available:

2007, 2010, 2013, 2016

COURSE OUTLINE
Refreshing the basics
Database relationships
Referential integrity
Designing userforms and reportsAdvanced form design
Main and SubForms
Multiple instances of subform
Calculations in forms
Form properties
Modal forms
Popup forms
Selecting data with combo boxes
Filtering from combo boxes
Running queries from forms

Queries
Calculations in queries
Action queries
Union queries

Reports
Advanced report design
Using visual basic to customise reportsMacros
Macro actions
Group macros
Conditional macros
Assigning macros to toolbars and menus

Introduction to Visual Basic
Event properties
Functions
Methods
Properties
Macro actions in VBA

BookThisCourse