Access 2007: VBA Programming Training
Delivery Options
- Live Online Training - Public Class (): $245.00 (Register)
- Customized Onsite Training (1 day): Request a Proposal
| Class Date and Time |
Price
|
|
|---|---|---|
|
$245.00
or 1 vouchers
voucher
|
||
| $245.00 or 1 vouchers voucher | ||
| $245.00 or 1 vouchers voucher | ||
| $245.00 or 1 vouchers voucher | ||
| $245.00 or 1 vouchers voucher | ||
| $245.00 or 1 vouchers voucher | ||
| $245.00 or 1 vouchers voucher | ||
| $245.00 or 1 vouchers voucher | ||
| $245.00 or 1 vouchers voucher | ||
| $245.00 or 1 vouchers voucher |
Class Description
Class Overview
This VBA programming for Access 2007 training course is designed for experienced Access 2007 users who want to learn ActiveX Data Objects, control structures, and the basics of VBA programming.
Class Goals
- Learn to use VBA within Microsoft Access 2007.
Class Outline
- Visual Basic Editor
- Objects
- Object Browser
- Collections
- Programming basics
- Working with data
- Scope
- Control structures
- Decision structures
- Loop structures
- ActiveX Data Objects
- Getting started with ActiveX Data Objects
- Working with ActiveX Data Objects
- VBA debugging tools
- Errors in code
- Debugging techniques
- Handling runtime errors
- Office integration
- Automating Office 2007
- Working with Word from Access
- Working with Excel from Access
Class Materials
Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.
Class Prerequisites
Experience in the following areas is required:
- Expertise in Microsoft Access 2007
Technical Requirements
Our computer technical requirements and setup process is easy, with support just a click away.
- Onsite and Instructor-led Online course technical requirements and setup instructions.
- WebEx system requirements for Instructor-led Online delivery option.
of Live Online Training:
Recent Blog Articles
Data Types in VBA
Posted on Nov 30, 2010 by Connie
When declaring variables in VBA, you also assign a data type. But there is a trick to it: you want to choose a data type that uses the least amount of ...
Custom icons to run Macros in Microsoft Word 2003
Posted on May 19, 2010 by Connie
Have you ever wanted to attach a Macro to a button on the toolbar in Microsoft Word? Maybe you have and have seen the images that are provided for you. ...
VBA Variables Rules and Conventions
Posted on Apr 27, 2010 by Connie
What is a variable? Think of it this way, a variable is like a little box in your computer’s memory. The little box, the variable, will have a name. ...
Option Explicit in VBA
Posted on Apr 13, 2010 by Connie
You have probably opened the VB Editor in Access, Word, or PowerPoint, and seen Option Explicit at the top of the code window. But what does it mean? Option ...
Webucator is a Registered Education Provider (R.E.P.) approved by PMI to issue professional development units (PDUs) for our training courses.