VBA for Access Training

“Most of you are familiar with the virtues of a programmer. There are three, of course: laziness, impatience, and hubris.“  Larry Wall

Download course details

Request a quote for this course

 

What this course will do for you:
Visual Basic for Applications (VBA) is an event driven programming language with an associated integrated development environment (IDE) which is built into most Microsoft Office applications including Microsoft Access. This course introduces you to the basic concepts that underly this programming language as it’s used to control aspects of Access, and starts you on the journey of writing your own procedures to manipulate user interface features through the automation of forms and controls.

To get the most out of this course:
You don’t need any previous experience of VBA or writing computer programs but you should be a competent Microsoft Access user.

Duration: 2 Days

Course Topics:

Introduction to Event Driven Programming	Using the MsgBox and InputBox Functions
Using the Integrated Development Environment	Using the Dlookup Function
Discovering Access Objects	Using Standard Modules
Working with Methods and Properties	An Introduction to Data Access Objects
Constructing VBA Code and Error Trapping