Access 2007: VBA Programming

Request more details:

submit request
Description:
This course is designed for experienced Access users who want to learn ActiveX data objects, control structures, and the basics of VBA programming.
Prerequisites:
VBA programming for MS Applications
Visual Basic Editor:
Objects
Object Browser
Collections
Programming basics:
Working with data
Scope
Control structures:
Decision structures
Loop structures
ActiveX Data Objects:
Getting started with ActiveX Data Objects
Working with ActiveX Data Objects
VBA debugging tools:
Errors in code
Debugging techniques
Handling runtime errors
Office integration:
Automating Office 2007
Working with Word from Access
Working with Excel from Access