dmw | consultancy
tel 01732 833085
tonbridge · kent · UK

Access VBA Programming Course

This is a course for Access developers who want to make a start on VBA (Visual Basic for Applications) in order to enhancing their databases' operability.

The huge advantage to you in opting for DMW’s on-site training is that 100% of your time is spent on your issues alone. With DMW you are tapping the skills of a programmer built up during development of scores of databases since Microsoft Access first arrived in the UK after its release in 1992.

A common request is for training on the application of VBA to a database that a client has already created but which can only be made fully operational with the inclusion of some specialised code.


Course Content

Choosing topics becomes very important if you’re planning to use what’s covered by the training as the basis for a particular database of your own. Topics may include the following and you can specify others to suit your objectives.

Macros and VBA (Visual Basic for Applications) Why use, and when 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.

Good Programming Style Structured programming. Applying structure to your VBA code.

Recordsets DAO and ADO. Managing object variables. ADODB Recordset Object. 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.


Course Duration

Two days on-site, each day running between 9:30am and 4:30pm. This should provide you with an appreciation of VBA and its relevance to your database developmnet.

VBA is a substantial programming language, with much to learn about its vocabulary and syntax. Consider that additional days with DMW may improve your skills quicker than you would achieve self-teaching, using books and the web.

Please speak to DMW about your specific objectives and how they might be achieved most efficiently.


Course Pre-requisites

To apply programming to your database you’ll need plenty of practical application of those database development skills covered by our Basic Introduction, Intermediate and Advanced courses.

“Programmers are in a race with the Universe to create bigger and better idiot-proof programs, while the Universe is trying to create bigger and better idiots. So far the Universe is winning.”

Rick Cook (Author of Wizardry series)