Visual Basic for Access

This course covers all of the key concepts required to program within Access using Visual Basic including understanding VBA Essentials, the programming environment, variables and error handling techniques. This course assumes a strong knowledge of Microsoft Access to an Advanced level.

At the end of the course delegates will be able to create macros and forms, communicate with the user through input boxes and message boxes and use the debugging features of VBA to locate and identify errors. This course is available for Microsoft Office 2003, 2007 and 2010.

The Access Development Environment
Using Queries for Reports and Forms
Macros and VBA
Creating more Complex Macros
Converting Macros to VBA Code
VBA Essentials
Programming Environment Overview
Creating a Startup Form
Code Behind Forms
Understanding Modules in Access
Working with Numbers
Dealing with Overflows
Working with Decimals
Working with Dates
Creating a Simple Input Box
Creating more Elaborate Input Boxes
Creating Message Boxes
Customising Icons and Buttons
Asking Yes/No Questions
Creating Variable Reports
Navigating Records in a Form
Debugging VBA
Handling Errors in VBA