Custom Search
Provided by: Training Connection

Access VBA Training

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

This is primarily ilt training
computer labComputer Lab Work
Contact Training Connection for more information
Course Level:advanced
Duration:1 days
Training Presented in:English
About The Training Provider: Training Connection
Training Connection - Training Connection Training Connection provides training in the world's most popular desktop applications and in business skills. All our hands on training sessions are delivered by a qualified industry leading professionals. We keep our class sizes small so that each student is well looked after. www.trainingconnection.com Computer Courses include Photoshop Training, Dreamweaver...
Want to market your chicago training?
tcw11-gfc-v396M-10/25/09-09:51:38-()[B]-[A]-[B] -16:45:25