| Course Details [choose new course] [printable version] |
| Access 2007: VBA Programming |
| Course Number: AP0016 |
| Category: Database & Collaboration Tools |
| Duration: 1.00 day |
Description
This ILT Series course, rated 4.9/5.0 in overall quality by ProCert Labs, is designed for experienced Access 2007 users who want to learn ActiveX Data Objects, control structures, and the basics of VBA programming.
Outline
- 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