> Nearby Locations
Des Moines
515-226-3265
 
 
 
My Account  |  View Cart
Search:
 


Class Outline*


| Request Info | Contact Us


Access: Intro to VBA

Duration:
2 Days

Overview:
The course is designed for experienced Access users who want to learn ActiveX data objects, control structures, and the basics of VBA programming.

 

Outline:

Lesson 1: Visual Basic Editor

  • Objects
  • Object Browser
  • Collections

Lesson 2: Programming Basics

  • Data
  • Scope

Lesson 3: Control Structures

  • Decision structures
  • Loop structures

Lesson 4: ActiveX Data Objects

  • Getting started with ActiveX Data Objects
  • Working with ActiveX Data Objects

Lesson 5: VBA Debugging Tools

  • Errors in code
  • Debugging techniques
  • Handling run-time errors

Appendix: Office Integration

  • Automating Office 2003
  • Working with Word from Access
  • Working with Excel from Access

 

*Content, days, and times vary depending on your location. Please view the outline prior to purchase or contact the local center for more information.