Access 2007 VBA

2 Day Course
Hands On
Code DAC07VBA

This course has been retired. Please view currently available User Microsoft Office Training Courses.

Modules

Hide all

Getting Started (4 topics)

  • Introduction to Programming in Access
  • Why Program in Access?
  • Understanding the Development Environment
  • Using Visual Basic Help

Working with Procedures and Functions (10 topics)

  • Understanding Modules
  • Creating a Standard Module
  • Understanding Procedures
  • Creating a Sub Procedure
  • Calling Procedures
  • Using the Immediate Window to Call Procedures
  • Creating a Function Procedure
  • Naming Procedures
  • Organizing Code and Procedures
  • Working with the Code Editor

Understanding Objects (12 topics)

  • Understanding Classes and Objects
  • Navigating the Access Object Hierarchy
  • Understanding Collections
  • Using the Object Browser
  • Working with the Application Object
  • Understanding the Form Object
  • Working with Properties
  • Using the With Statement
  • Working with Methods
  • Understanding the DoCmd Object
  • Working with Events
  • Understanding the Order of Events

Using Expressions, Variables, and Intrinsic Functions (11 topics)

  • Understanding Expressions and Statements
  • Declaring Variables
  • Understanding Data Types
  • Working with Variable Scope
  • Working with Variable Lifetime
  • Considering Variable Scope and Lifetime Together
  • Using Intrinsic Functions
  • Understanding Constants
  • Using Intrinsic Constants
  • Using Message Boxes
  • Using Input Boxes

Controlling Program Execution (8 topics)

  • Understanding Control-of-Flow Structures
  • Working with Boolean Expressions
  • Using the If...End If Decision Structures
  • Using the Select Case...End Select Structure
  • Using the For...To...Next Structure
  • Using the For Each...Next Structure
  • Using the Do...Loop Structure
  • Guidelines for use of Branching Structures

Working with Recordsets (2 topics)

  • Declaring and Creating Object Variables
  • Working with the DAO Recordset Object

Debugging Code (7 topics)

  • Understanding Errors
  • Using Debugging Tools
  • Setting Breakpoints
  • Setting Break Expressions
  • Using Break Mode during Run Mode
  • Stepping through Code
  • Determining the Value of Expressions

Handling Errors (6 topics)

  • Understanding Error Handling
  • Understanding VBA's Error Trapping Options
  • Trapping Errors with the On Error Statement
  • Understanding the Err Object
  • Writing an Error-Handling Routine
  • Working with Inline Error Handling

Prerequisites

Before attending this course, students need to be able to: Understand database design and create tables, forms and reports. Have created queries and understand how to use query expressions.

Course PDF

Print

Sections