Microsoft® Office Access 2007 on Demand

15. Enhancing a Database with Programming

What You’ll Do

Enhance a Database with VBA

Create a Module

Understand Parts of the Visual Basic Editor

Create a Sub Procedure

Write VBA Commands

Run a Sub Procedure

Copy Commands from the Object Browser

Create a Custom Function

Run a Custom Function

Create a Class Module for a Form or Report

Set Project Properties

Debug a Procedure

Identify VBA Debugging Tools

Optimize Performance with an ACCDE File

Introduction

If you want to create customized Microsoft Office Access 2007 applications, you’ll need to learn how to work with the Microsoft Office 2007 programming language, Microsoft Visual Basic for Applications, or VBA. VBA is more powerful and more flexible than Access macros, and you can use it in ...