Access: VBA Programming Training
Delivery Options
- Live Online Training - Public Class (): $325.00 (Register)
- Customized Onsite Training (1 day): Request a Proposal
| Class Date and Time |
Price
|
|
|---|---|---|
|
$325.00
or 1 vouchers
voucher
|
||
| $325.00 or 1 vouchers voucher | ||
| $325.00 or 1 vouchers voucher | ||
| $325.00 or 1 vouchers voucher | ||
| $325.00 or 1 vouchers voucher | ||
| $325.00 or 1 vouchers voucher | ||
| $325.00 or 1 vouchers voucher | ||
| $325.00 or 1 vouchers voucher |
Class Description
Class Overview
This VBA Programming for Access training course is designed for experienced Access users who want to learn ActiveX Data Objects, control structures, and the basics of VBA programming. Any version of software can be used for this class, including 2003, 2007, and 2010.
Class Goals
- Learn to use VBA within Microsoft Access.
Class Outline
- Visual Basic Editor
- Visual Basic for Applications
- Using the Visual Basic Editor
- The Visual Basic Interface
- Working in Visual Basic Editor
- Using the Visual Basic Editor in Access
- Close Event Procedure
- Save and Run a Procedure
- Object Programming
- The Object Model
- Getting Help in the Object Browser
- Event Procedures and Macros
- Using the Object Model in Access
- The Access Object Model
- Programming Basics
- Data Basics
- Scope of Variables
- Naming Variables
- Using Variables to Accept User Input
- Control Structures
- Decision Structures
- Loop Structures
- Custom Dialog Boxes
- User Forms
- Events
- Debugging and Error Handling
- Errors
- Debugging
- Error Handling
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
Technical Requirements
Our computer technical requirements and setup process is easy, with support just a click away.
Client Success
Join The Team
- Learn how you can become a Webucator Trainer
- Career Opportunities
Locations
- Where We've Trained
- We have trainers all over North America.
Compare Us
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 ...