Please Note: This site’s design is only visible in a graphical browser that supports web standards, but its content is accessible to any browser or Internet device.

Automating Access using Macros and
Visual Basic for Applications

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.

Course Outline

  • Learn about creating macros
  • Meet the Visual Basic for Applications development tools
  • See how to use the macro converter
  • Learn about VBA language concepts
  • Understand about declaring data types
  • Cover commands and statements
  • Learn about variables and constants
  • Control program flow using If..Then..Else, Do..Loops and For..Next Constructs
  • See how to create your own procedures and functions
  • Learn how to programming Access forms and controls and the associated events
  • See how to interact with users with the input box and the message box
  • Cover integrating Access with other Office programs
  • Learn about using error handling and debugging 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.