Capital Business Machines Access 2007 Level 4 - VBA

Access 2007: VBA Programming

Access 2007 Level 4 is designed for experienced Access users who want to learn ActiveX data objects, control structures, the basics of VBA programming. We learn how to take Access beyond it’s built in default capabilities.

Course Length:

2 days

Prerequisites:

Access 2007: Application Development or , Access Basic, Intermediate, and Advanced skills training

Topic

Unit 1: Visual Basic Editor

Topic A: Objects

Topic B: Object Browser

Topic C: Collections

Unit 2: Programming basics

Topic A: Working with data

Topic B: Scope

Unit 3: Control structures

Topic A: Decision structures

Topic B: Loop structures

Unit 4: ActiveX Data Objects

Topic A: Getting started with ActiveX Data Objects

Topic B: Working with ActiveX Data Objects

Unit 5: VBA debugging tools

Topic A: Errors in code

Topic B: Debugging techniques

Topic C: Handling runtime errors

Appendix A: Office integration

Topic A: Automating Office 2007

Topic B: Working with Word from Access

Topic C: Working with Excel from Access Page