VBA and Access

Course Code ACCVBA6

Duration: 2 Days

Pre-requisites:
This course assumes no knowledge of Visual Basic for Applications (VBA).
The same basic structure of the course applies to all VBA environments, e.g. Excel, Word and Access but each uses objects specific to the application. This course therefore pre-supposes that users are familiar with building databases, incorporating forms, sub forms, reports, fields containing expressions and calculations.

For those new to programming, Visual Basic for Applications is a different environment to Visual Basic - please ask for guidance if you are unsure.

Objectives:
This course enables trainees to:
understand the different methods of creating VBA modules and the basic syntax of VBA statements;
use VBA to manipulate Microsoft Access objects, to perform arithmetic and display a message on the screen using VBA;
prompt the user for information and make use of the information received from the user;
test and debug VBA code.

Course Outline

Application Development Using VBA
The VBA development environment.

VBAFundamentals
The basic building blocks of VBA Programming. Forms, Controls, Code & Objects.

Working with Collections & Objects
Accessing the collections in the package
Manipulating objects properties, methods & events.
Navigating the hierarchy of the object model.

Recording & Editing Macros
Recording Marcos
Statements to watch for
Statements to change to speed up the macro
Statements to change for automatic use.

Working with Code and Forms
Writing the code that ties the elements of your application together.
VBA facilities that simplify writing and editing code.

Variables & Procedures
Types of variables and constants supported by VBA.
Writing and using procedures and functions

Controlling Programme Execution
Functions that VBA provides for tasks such as data conversion
Conditional and looping structures

Debugging
Different errors that can occur
How to find and correct them

Working with Controls
How to expand functionality by incorporating standard and ActiveX controls.

Input Validation
Different methods of ensuring users enter valid data.

Error Trapping
Ways of trapping and handling errors in applications.

Menus, Status Messages and Toolbars
Working with menus, status messages and toolbars.

Please note: we also develop solutions in Access. Please ask for details.