Access 2007:
VBA Programming

Topic-Level Outline

Days: 1

Prerequisites: Access 2007: Application Development or equivalent experience

Unit 1 : Visual Basic Editor

Topic A: 0 Objects

A-1: Discussing objects

A-2: Examining the Properties window

A-3: Modifying the object properties

A-4: Writing code to change object properties

A-5: Using a method

A-6: Associating code with an event

Topic B: 0 Object Browser

B-1: Examining the Object Browser window

B-2: Searching in the Object Browser

Topic C: 0 Collections

C-1: Understanding collection objects

C-2: Using the Controls collection

Unit 2 : Programming basics

Topic A: 0 Working with data

A-1: Examining data types and variables

A-2: Declaring variables explicitly

A-3: Using operators

A-4: Using the interaction functions

Topic B: 0 Scope

B-1: Observing modules and procedures

B-2: Examining procedure- and module-level scope

B-3: Understanding public scope

B-4: Creating a Sub procedure

B-5: Calling a Sub procedure

B-6: Creating a Function procedure in a standard module

B-7: Calling a Function procedure

Unit 3 : Control structures

Topic A: 0 Decision structures

A-1: Using the If…Then statement

A-2: Using the If…Then…Else statement

A-3: Using the If…Then…ElseIf statement

A-4: Using the Select Case statement

Topic B: 0 Loop structures

B-1: Using the For…Next loop

B-2: Using the For Each…Next loop

B-3: Using the Do While…Loop

Unit 4 : ActiveX Data Objects

Topic A: 0 Getting started with ActiveX Data Objects

A-1: Discussing ADO

A-2: Discussing ADO collections

Topic B: 0 Working with ActiveX Data Objects

B-1: Connecting to a database

B-2: Creating a Recordset object

B-3: Navigating a Recordset

B-4: Saving and canceling changes

Unit 5 : VBA debugging tools

Topic A: 0 Errors in code

A-1: Discussing types of errors

Topic B: 0 Debugging techniques

B-1: Discussing debugging tools

B-2: Setting a breakpoint

B-3: Adding a watch expression

B-4: Using Step Into

B-5: Deleting a watch expression

B-6: Working with the Immediate window

B-7: Using the Locals window

Topic C: 0 Handling runtime errors

C-1: Writing error-handling code

Appendix A : Office integration

Topic A: 0 Automating Office 2007

Topic B: 0 Working with Word from Access

Topic C: 0 Working with Excel from Access