VISUAL BASIC FOR ACCESS - 3 days
Objective
To acquaint the delegate with the overall concepts employed in VBA,
demonstrate how VBA can enhance the usability & performance of Microsoft
Access and introduce methods of implementing VBA in existing and new
projects
Requirements
A very good working knowledge of Microsoft Access and some experience
of writing simple statements in the Form Properties in Access.
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 Procedures
Procedures & 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.