Microsoft Access VBA

Training Provided by Computer Training Source, Inc. In this class you will learn how to Work with objects, use Object Browser, identify collection objects, and use the Controls collection. Manipulate data by declaring variables, combine data by using expressions, get user input, create Sub and Function procedures, and call one procedure from another. Use decision structures and use loop structures. Identify ActiveX Data Objects (ADO) architecture and collections, connect to a database, work with a Recordset, and create a parameter query. Identify compile-time, run-time, and logical errors; use the debugging tools; and write error-handling code. Our classes are all instructor-led, hands-on learning. Each student has their own computer and is given a student manual with practice files to take home. A freerepeat, within six months, is included as well as thirty days of technical support. Class is usually one day from 9am to 4pm (unless it& 39;s an evening class or an accelerated class). Click on any class date below to view a class outline.

Microsoft Access VBA

Unit 1: Visual Basic Editor

Topic A: Objects
Topic B: Object Browser
Topic C: Collections

Unit 2: Programming basics

Topic A: 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 run-time errors

Appendix A: Office integration

Topic A: Automating Office 2003
Topic B: Working with Word from Access
Topic C: Working with Excel from Access

About The Training Provider: Computer Training Source, Inc.

More Access Training from Computer Training Source, Inc.

• Microsoft Access Advanced
• Microsoft Access Intermediate
• Microsoft Access Introduction