Access® 2013 on Demand

15. Automating and Extending a Database

What You’ll Do

Automate a Database with Macros

Create, Edit, Run, and Test a Macro

Create a Macro Group

Create a Macro Condition

Add Comments to a Macro

Create a Message Box

Assign a Macro to an Event

Assign a Macro to a Button or Toolbar

Extend a Database with VBA

Create a Module

View the Visual Basic Editor

Create a Sub Procedure

Write VBA Commands

Run a Sub Procedure

Copy Commands from the Object Browser

Create and Run a Custom Function

Create a Class Module

Set Project Properties

Debug a Procedure

Identify VBA Debugging Tools

Optimize Performance with an ACCDE File

Introduction

If you find yourself repeating the same sequence of tasks over and over again, you can save time and effort by creating ...