After this course, I feel more equipped to handle coding using Ruby-On-Rails. The instructor was kno... More Testimonials »

Access 2007: VBA Programming Training

Delivery Options

Class Date and Time Price Pricing Information Register
Mar 19, 2010 10:00 AM - 5:00 PM ET $375.00 or 1 vouchers Register
Apr 16, 2010 10:00 AM - 5:00 PM ET $375.00 or 1 vouchers Register
May 14, 2010 10:00 AM - 5:00 PM ET $375.00 or 1 vouchers Register

Class Description

Class Overview

This VBA programming for Access 2007 training course is designed for experienced Access 2007 users who want to learn ActiveX Data Objects, control structures, and the basics of VBA programming.

Class Goals

  • Learn to use VBA within Microsoft Access 2007.

Class Outline

  1. Visual Basic Editor
    1. Objects
    2. Object Browser
    3. Collections
  2. Programming basics
    1. Working with data
    2. Scope
  3. Control structures
    1. Decision structures
    2. Loop structures
  4. ActiveX Data Objects
    1. Getting started with ActiveX Data Objects
    2. Working with ActiveX Data Objects
  5. VBA debugging tools
    1. Errors in code
    2. Debugging techniques
    3. Handling runtime errors
  6. Office integration
    1. Automating Office 2007
    2. Working with Word from Access
    3. Working with Excel from Access

Class Materials

All students receive a course manual or book and all the class examples.

Students in private onsite classes will also receive:

Class Prerequisites

Experience in the following areas is required:

  • Expertise in Microsoft Access 2007

Technical Requirements

Our computer technical requirements and setup process is easy, with support just a click away.

Client Success
  1. Independent Survey
  2. Client List
  3. Testimonials
Join The Team
  1. Learn how you can become a Webucator Trainer
  2. Career Opportunities
Training Classes
Locations
Live eLearning

Like a class you would go to, but you don't have to go anywhere. More...

Customized Onsite Training

The trainer comes to you and delivers a class customized for your team. More...

Self-Paced eLearning

Our least expensive option. You proceed through the course entirely at your own pace. More...

Reference Library
Partner Programs
© Webucator, Inc. All rights reserved. | Toll Free: 877-932-8228 | UK: 0808-101-3484 | From outside the USA: 315-849-2724| Fax: 315-849-2723