Access 2003: VBA

Course Specifications:

Courseware: Access 2003: VBA Programming

Software: Microsoft Access 2003

Course length: 1 day

Course times: 8:30 a.m. - 4:30 p.m.

Course Description:

Access 2003: VBA introduces students to working with objects, using Object Browser, identifying collection objects, and using the Controls collection. Students will also manipulate data by declaring variables, combine data by using expressions, get user input, create Sub and Function procedures, and call one procedure from another.

Course Objective:

In this course, students will learn ActiveX data objects, control structures, and the basics of VBA programming.

Target Student:

This course is designed for students who wish to become proficient in working with objects and collections and implementing ActiveX Data Objects.

Prerequisites:

To ensure the successful completion of Access 2003: VBA, we recommend completion of the following MicroAssist courses, or equivalent knowledge from another source:

  1. Access 2003: Introduction
  2. Access 2003: Intermediate
  3. Access 2003: Advanced
  4. Access 2003: Application Development
  5. Basic familiarity with Visual Basic for Applications

Delivery Method:

Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities. Each student is provided with a computer and a Manual. The manual is the student's to keep and makes an excellent reference guide.

Course Content:

Lesson 1: Visual Basic Editor

  1. Topic 1A: Objects
  2. Topic 1B: Object Browser
  3. Topic 1C: Collections

Lesson 2: Programming basics

  1. Topic 2A: Data
  2. Topic 2B: Scope

Lesson 3: Control structures

  1. Topic 3A: Decision structures
  2. Topic 3B: Loop structures

Lesson 4: ActiveX Data Objects

  1. Topic 4A: Getting started with ActiveX Data Objects
  2. Topic 4B: Working with ActiveX Data Objects

Lesson 5: VBA debugging tools

  1. Topic 5A: Errors in code
  2. Topic 5B: Debugging techniques
  3. Topic 5C: Handling run-time errors

Lesson 6: Office integration

  1. Topic 6A: Automating Office 2003
  2. Topic 6B: Working with Word from Access
  3. Topic 6C: Working with Excel from Access