Access Intermediate

Duration:

2 days

Versions Available:

97, 2000, XP, 2003, 2007, 2010

COURSE OUTLINE
Refreshing the basics
Database relationships
Referential integrity
Designing userforms and reports

Advanced 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 reports

Macros
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
Print Friendly Print Get a PDF version of this webpage PDF

Post a Comment

Your email is never published nor shared. Required fields are marked *

*
*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>