CERTIFICATIONS

PROGRAMS

LEARN > Find a Class > Class Summary

ATACVBA - Access 2007: VBA Programming

If you have any questions about registering for this class, please call (877) 832-0688 Ext. 1493 or email us at getsmart@LRS.com

Access 2007: VBA Programming

Prerequisites

Access 2007: Application Development or equivalent experience

Detailed Class Syllabus

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