ACCESS VBA (Visual Basic for Applications)

Overview

From long experience of training user in Access VBA we feel a course such as this should ideally be taught on a 'one to one' basis. Our Microsoft Access 'expert' is then able to sit with the user to offer training, guidance and help tailored specifically to individual requirements.

Course Syllabus

Getting started

• Introduction to Access programming
• Understanding the development environment
• Using VBA help

Sub and Function Procedures

• Understanding and creating Modules
• Defining Procedures
• Creating a Sub Procedure
• Calling Procedures
• Using the Immediate Window
• Creating a Function Procedure
• Working with the VBA code editor

Understanding Objects

• Understanding Classes and Objects
• Navigating the Access object heirarchy
• Understanding Collections
• References and the Object Browser
• Working with the Application object
• Understanding the Form object
• Working with object Properties
• Using the With statement
• Working with Methods
• Understanding the Docmd statement
• Working with Events      
• Understanding the order of Events

Intrinsic Functions & Variables

• Defining Expressions
• How to declare Variables
• Determining Data Types
• Programming with variable scope
• Harnessing intrinsic Functions
• Defining Constants
• Using Intrinsic Constants
• Using Message Boxes and Input Boxes
• Declaring and using Object Variables

Controlling Program Execution

• Understanding control-of-flow structures
• Working with boolean expressions
• Using the If..Else..End structure
• Using the Select Case structure
• Using the For...Next structure
• Using the For Each...Next structure
• Using the Do...Loop structure
• Guidlines for the use of GOTO statements

Working with Recordsets

• Declaring and creating object variables
• Working with the ADODB Recordset object
• Specifying a Recordset Cursor type
• Locking records for updating
• Specifying a Recordser Cursor location - optional
• Using the Cache Size property - optional
• Understanding Recordset Cursor properties - optional

Debugging the Code

• Defining errors
• Working with the Debugging tools
• Setting and clearing Breakpoints
• How to Step Into and Through code
• Working with Break Mode during Run Mode
• Displaying the value of expressions

Handling Errors

• Understanding error handling
• Understanding VBA error trapping options
• Using the 'ON Error' statement
• Understanding the Error Object
• Writing an error handling routing
• Working with inline error handling