1-877-WEBUCATE
(1-877-932-8228)
info@webucator.com
 
Microsoft Training
Java Training
XML Training
Database & SQL Training
PHP, Perl, ASP, Groovy, Grails, Ruby on Rails Training
HTML, JavaScript, Ajax & CSS Training
Adobe Training
◊ PUBLIC VBA TRAINING
Watch a 3-minute presentation
on our live instructor-led
online classes

How about taking a class directly from your home or office with a live instructor?
When you register for one of our instructor-led online VBA classes, we send you a computer headset, the courseware for class, and some other goodies. At the time of class, you simply put your headset on and log in to our web conferencing software. You can hear everything the instructor says, see the complete presentation, and ask questions at any time. Classes are small, generally 2-6 students, full of hands-on exercises, and are never cancelled due to low enrollment.

To have someone contact you about our instructor-led online classes, please fill out the form below. We will also email you a class schedule and pricing.

* (Required)
* (Required)
* (Required)
* (Required)
* (Required)
(The number of people requiring training)
* (Required)
(For Federal Government Pricing)

VBA Programming Training: Word 2007, Excel 2007, Access 2007 (3 days)

Classes for individuals are delivered via the Web by a Webucator instructor over a live web conference. For more information on how these classes are delivered click here or call us toll free at 877-932-8228.

Click here for our private onsite VBA classes

This class is not currently scheduled.
You may request that it be added to the schedule by clicking on the "Please Schedule" button below.

VBA Programming Training: Word 2007, Excel 2007, Access 2007 Course Overview

This VBA programming training course teaches how to use VBA in Word 2007, Excel 2007, and Access 2007.

It is designed to

  1. give experienced Word users proficiency in using the Visual Basic Editor (VBE). Students will learn how to build applications, debug code, automate data entry, and merge data files. They will also learn how to create forms, build tables, secure information, and share data.
  2. give experienced Excel users proficiency in creating procedures that run in response to specific events, working with control structures, developing user forms to accept or display data, validating the data entry in user forms, and debugging and handling errors in code.
  3. give experienced Access 2007 users proficiency in ActiveX Data Objects, control structures, and the basics of VBA programming.

VBA Programming Training: Word 2007, Excel 2007, Access 2007 Course Goals

  • Learn to use VBA within Microsoft Word 2007.
  • Learn to use VBA within Microsoft Excel 2007.
  • Learn to use VBA within Microsoft Access 2007.

VBA Programming Training: Word 2007, Excel 2007, Access 2007 Course Prerequisites

Experience in the following areas is required:

  • Expertise in Microsoft Word 2007
  • Expertise in Microsoft Excel 2007
  • Expertise in Microsoft Access 2007

VBA Programming Training: Word 2007, Excel 2007, Access 2007 Course Outline

  1. Getting started with the Visual Basic Editor
    1. Visual Basic for Applications
    2. Properties and modules
    3. The Code window
    4. The Object Browser
  2. Programming basics
    1. Working with variables and functions
    2. Scope of variables
    3. Scope of procedures
  3. Word objects
    1. Programming with objects
    2. The Documents collection
    3. The Tables collection
  4. Control structures
    1. Using decision structures
    2. Using loop structures
  5. Forms
    1. Working with forms
    2. Using events in forms
  6. Debugging and error-handling
    1. Errors
    2. Debugging
    3. Handling errors
  7. Custom dialog boxes
    1. User forms
    2. Events
  8. ActiveX Data Objects
    1. Getting started with ActiveX Data Objects
    2. Working with ActiveX Data Objects
  9. Office integration
    1. Automating Office 2007
    2. Working with Word from Access
    3. Working with Excel from Access

VBA Programming Training: Word 2007, Excel 2007, Access 2007 Course Materials

Each student will receive a comprehensive set of materials, including course notes and all the programming examples.

VBA Programming Training: Word 2007, Excel 2007, Access 2007 Course Technical Requirements and Setup Instructions

Click here for technical requirements and setup instructions

home - onsite classes - instructor-led online courses - self-paced online courses - why webucator - partners - contact - sitemap
© 2009 Webucator. All rights reserved. info@webucator.com | Toll Free: 877-WEBUCATE (877-932-8228) | From Outside the USA: 315-849-2724 | Fax: 315-410-5320
Phoenix, AZ | Santa Clara, CA | Santa Clara, CA | Los Angeles, CA | Sacramento, CA | Washington, DC | Atlanta, GA | Chicago, IL | Indianapolis, IN | Muncie, IN
New Orleans, LA Boston, MA | Cambridge, MA | Charlestown, MA | Framingham, MA | Ipswich, MA | Lincoln, MA | Wellesley, MA | Worcester, MA | Bangor, ME | Detroit, MI
Raleigh, NC Winston-Salem, NC | Lincoln, NE | East Hanover, NJ | Eatontown, NJ | Madison, NJ | Parsippany, NJ | Trenton, NJ | Albany, NY | Buffalo, NY | Rochester, NY
New York City, NY | Syracuse, NY | West Babylon, NY | Dayton, OH | Bethlehem, PA | Philadelphia, PA | Pittsburgh, PA | Pittsburgh, PA | State College, PA
Middletown, RI | Rapid City, SD | Austin, TX | Dallas, TX | Houston, TX | Arlington, VA | McLean, VA | Seattle, WA | Toronto, Canada | Ottawa, Canada | Calgary, CA