This is a three-day course designed for Access database creators who wish to use Visual Basic for Applications to automate Microsoft Access databases making them easier for your end-users to operate. Each delegate will carry out various practical exercises during the course, which involves them working through examples of each subject covered.

Learn how to

• Create macros
• Use the Visual Basic for Applications development tools
• Use the macro converter
• Work with VBA language concepts
• Declare data types
• Use commands and statements
• Create variables and constants
• Control program flow using If..Then..Else, Do..Loops and For..Next Constructs
• Create your own procedures and functions
• Program Access forms and controls and the associated events
• Interact with users with the input box and the message box
• Integrate Access with other Office programs
• Use error handling and debug code

Who would benefit from the course?

This course is designed for Access database creators who wish to give more functionality to users and improve automation of Access databases.

Pre-requisites

A good understanding of Access and, ideally, attendance on our Access Beyond the Basics course is required.