t 01732 833085
e david wallis
:: home > access training > access VBA programming course
access VBA programming course
This is a course for Access developers who want an appreciation of the Access version of VBA (Visual Basic for Applications) and its use in enhancing database operability.
course duration
Two days on-site.
course pre-requisites
Practice in those database development skills covered by our Basic Introduction, Intermediate and Advanced courses.
course content
Topics may include the following and you can specify others to suit your objectives.
Visual Basic for Applications
Why use, and went to use, VBA
Why not use macros
Access Programming environment
Modules
Using the VB Editor
Using VB Help.
Procedures and Functions
Sub procedures
Function procedures
Calling procedures
Use of Immediate Window to test code
Organizing code and procedures.
References
Relevance of References
Managing References.
Objects
Object model
Object classes
Object hierarchy
Object collections
Using the Object Browser
The Application Object
The Form Object.
Working on Properties
Distinguishing Properties
Using the With...End With statements
Working with Events.
Working with Methods
Distinguishing Methods
Understanding the DoCmd Object.
Coding
Expressions
Statements.
Variables and Constants
Declaring variables
Variable data types
Variable scope and lifetime
Local and global constants.
Functions
Intrinsic functions
Message boxes
Input boxes
Custom functions.
Program Execution Control
Program flow
Boolean expressions
If...Else...End statements
Select Case...End Select statements
For...Next statements
For Each...Next statements
Do...Loop statements.
Recordsets
DAO and ADO
Managing object variables
ADODB Recordset Object
Specifying a Recordset Cursor Type
Processing data sets programmatically.
Debugging Code
Understanding Errors
Using debugging tools
Testing and evaluating expressions.
Error Handling
Purpose of error handling
Essential error handling
VBA error object
Trapping and responding to errors
General-purpose error-handling code.
Applying code to forms
Event code
Controls code
Form code.
Applying code to reports
Controls code
Report code.
london, kent, surrey, east sussex, west sussex
We regularly travel to clients in London and the South East. Based near Tonbridge, we are particularly well placed to visit clients throughout Kent, East and West Sussex, Surrey and London.
As we have done in Ashford, Aylesford, Brighton, Canterbury, Chatham, Chiddingstone, East Grinstead, Edenbridge, Heathfield, Lightwater, London, Maidstone, Maresfield, Orpington, Paddock Wood, Richmond, Rochester, Sevenoaks, Sittingbourne, Tadworth, Ticehurst, Tonbridge, Tunbridge Wells and Westerham.