Access VBA

Goals

Being able to program with Visual Basic (VBA) in Access.

Prerequisite

Working experience with Microsoft Access.

Contents

Introduction

• Introduction to VBA
• Terminology
  • Objects
  • Collections
  • Properties
  • Methods
  • Events
  • Modules
  • Sub Procedures
  • Functions
• The Visual Basic Editor

Modules

• General modules
  • Concepts and uses
• Forms and report modules
  • Concepts and uses

Variables

• Definition
• Variable declaration and Data Types
• Local and global variables

Controlling Program Execution

• Conditional structures
  • If
  • Select Case
• Loop structures
  • For & For Each
  • Do Loop
• Interactivity
  • Inputbox
  • Msgbox

DAO

• Concepts
• Object hierarchy
• Recordsets
• Read, update, add and delete records

VBA Debugging Tools

• Errors in Code
• Debugging Techniques

Handling Runtime Errors

• Understanding error handling
• Understanding VBA's error trapping options
• Trapping errors with the On Error statement