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