Microsoft Visual Basic for Access – VBA

Duration 2 Days

Who should attend?

Those who require the fundamental skills to create useful and powerful VB applications.

Learning Outcomes

  • Explore variables and objects
  • Create robust codes
  • Manipulate data
  • Work with Command and Function procedures
  • Understand Variables
  • Work with Objects
  • Create User Forms
  • Set options within Access
  • Observe event handling codes
  • Debug Code

Course Content

  • Introduction to the Access VBA environment
  • Using Variables
  • Objects
  • Decision Making Code
  • Code that repeats
  • Using VBA to display information
  • Manipulating Forms and Reports
  • Events
  • User defined menus & toolbars
  • Breakpoints and watches
  • The Immediate Window
  • Manipulating Data in Database Tables