VBA For Access Introduction - 3 Days

Introduction to VBA
A look at the history of VBA, its importance and relevance to solutions and consideration of compatibility issues.
Concepts in VBA
Getting to grips with objects and their Properties and Methods.
Understanding Procedures and Modules
An introduction to events and event handling.
Objects
Treatment of Objects in general
An introduction to naming conventions
How Properties & Methods are accessed & used.
Objects commonly found in Microsoft applications

Objects specific to Microsoft Access
Variables & Constants
A general introduction to storage using Variables and Constants.
When and how to declare, use and name them
Control Structures
Determining the flow of a program.
Writing self-contained, re-usable Procedures

Controls
Control types commonly found in Microsoft applications
How to use and create them
Forms
Enhancing Forms with ProceduresProcedures & Functions
Calling Procedures from other

Procedures
Passing data between Procedures
Using standard Functions
Use of Named Arguments
An Introduction to the creation and use of custom functions
Automatic Procedures in Access
Menus & Toolbars
Using the Menu Editor
Creating and customising Toolbars
Assigning Procedures
Manipulation within Procedures
Debugging & Error Handling
Types of errors and how to handle them
Investigating problems using the Debug Window