home  : Computer  : Microsoft Office  : Access

Training Provided by Training Connection

Access VBA Training - Chicago

ABCDEFGHI7.jpg" alt="Access VBA Training Class" width="145" height="150" align="left" />

1. Access 2003 VBA - $395 (1 day - instructor-led)

To find out more about this class please visit our website at http://www.trainingconnection.com or call 312.698.4475

Access 2003 VBA

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

What you will learn

• VBA terminology
• To work with Objects, their properties, methods, and events
• Using Variables, Procedures and Functions in VBA
• Control Structures to execute code
• ActiveX Data Objects
• Work with a Recordset and Parameter query
• Learn Debugging Tools

Outline

Unit 1: Visual Basic Editor

• Visual Basic Terminology
• Work with Objects, their properties, methods, and events
• Use Object Browser to get information about Objects
• Identify Collection Objects and use Collection Ccontrol

Unit 2: Programming Basics

• Manipulate and Combine Data to get User input
• Declare Variables and Procedures
• Create Sub and Function Procedures
• Call one Procedure from other

Unit 3: Control Structures

• Use Decision Structures to create procedures that execute code
• Use Loop structures to execute code repeatedly

Unit 4: ActiveX Data Objects

• Examine ActiveX Data Objects architecture and collections
• Connect to a Database
• Work with a Recordset and Parameter query

Unit 5: VBA Debugging Tools

• Identify compile-time, run-time and logical errors
• Use the Debugging Tools
• Write Error-handling code to trap errors

Access VBA Training - http://www.trainingconnection.com/microsoft-office/access-training-vba.php

Training Avaliability and Delivery

This is primarily ilt training Computer Lab Work Contact Training Connection for more information

Course Level: advanced Schedule: 1 days Training Presented in: English

About Training Connection - Training Provider

More Training from Training Connection

• Access Training - Chicago
• Acrobat Training
• AJAX Training
• Anger Management
• Business Etiquette
• Business writing
• Communication Training
• CSS Training
• Customer Service
• Dreamweaver Training Chicago
• Excel Training - Chicago
• Excel VBA Training
• Fireworks Training
• Flash Training
• HTML Training
• Illustrator Training
• InDesign Training
• Outlook Training
• Photoshop Training
• PHP MySQL Training
• PowerPoint Training Chicago
• Project Management
• Project Training
• QuickBooks Training
• Ruby on Rails Training
• Sales Training
• Supervisor Training
• Word Training