Access Vba Training

Microsoft Access 2007/2010 VBA

Class timetable | Course outline

Course Description

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

Target Audience

Experience Access users looking to learn Access VBA. Students should already have good working knowledge of Access or have completed our Access Level 3 class.

Access VBA course facts
Money Back Guarantee

For added peace of mind, Training Connection’s Microsoft Access training comes with a 100% Money Back Guarantee.
If by lunchtime you don't feel that the program is for you, then you can leave the course at this point and receive a full refund of your course fees.

Access VBA Class Timetable

Chicago Mar 1 Register
Los Angeles Mar 8 Register
Chicago May 3 Register
Los Angeles Jun 7 Register
Chicago Jul 5 Register

*  Class almost full    !  Class guaranteed to run    †  Class is full

Book Access Level VBA Training
 

Learning Objectives

Upon successful completion of this Access VBA training course students will be able to:


  • 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.
Detailed Course Outline

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 Control

Programming Basics

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

Control Structures

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

ActiveX Data Objects

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

VBA Debugging Tools

  • Identify compile-time, run-time and logical errors
  • Use the Debugging Tools
  • Write Error-handling code to trap errors
Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.
 

What's included

Microsoft Access Training Manual
Certificate of Course Completion
6 Months FREE Repeat Policy
2 AMC Movie Vouchers

Related Courses

Access Level 1 course Access Level 1
Access Level 2 course Access Level 2
Access Level 3 training Access Level 3

Register for Access VBA training
Access Training Testimonial
"Give Rich a raise!! He was very knowledgeable and an excellent facilitator."
Neil Alcorn - Country Financial
Access Training Testimonial
"I thought I'd have a difficult time with VBA, but after taking Access Levels 1,2 & 3 with Training Connection, I was prepared. Additionally, I had an excellent instructor, Rich. He moves at a good pace, but always stops if any student has a difficulty. The class format is hands-on and he always asks what we students would like to address in the day's lesson. Training Connection has prepared me well for dealing with the database on the job!"
Maria Carrasco - University of Illinois
# # # # # # # # # # # # # # # # # #
Computer and Business Skills Training

Adobe Training

Acrobat Training
After Effects Training
Captivate Training
Dreamweaver Training
Flash Training
Flash Builder Training
Illustrator Training
InDesign Training
Photoshop Training
Premiere Pro Training

Web Development

AJAX Training
CSS Training
HTML Training
JavaScript Training
jQuery Training
PHP MySQL Training
WordPress Training

Microsoft Office

Access Training
Excel Training
Outlook Training
PowerPoint Training
Project Training
Visio Training
Word Training

Business Skills

Business Communication
Business Etiquette Training
Business Writing Class
Customer Service Training
Project Management Training
Time Management Training

QuickBooks

QuickBooks Training
 
 
  • HOME
  • TRAINING
  • TIMETABLE
  • ONSITE TRAINING
  • ROOM HIRE
  • ABOUT US
  • CONTACT US

  • SITE MAP
  • TERMS
  • COPYRIGHT 2007 - 2009