Access 2010: VBA Programming Training

This VBA Programming for Access 2010 training course is designed for experienced Access users who want to learn ActiveX Data Objects, control structures, and the basics of VBA programming.

Location

Public Classes: Delivered live online via WebEx and guaranteed to run . Join from anywhere!

Private Classes: Delivered at your offices , or any other location of your choice.

Goals
  1. Learn to use VBA within Microsoft Access.
Outline
  1. Visual Basic Editor
    1. Visual Basic for Applications
    2. Using the Visual Basic Editor
      1. The Visual Basic Interface
      2. Working in Visual Basic Editor
      3. Using the Visual Basic Editor in Access
      4. Close Event Procedure
      5. Save and Run a Procedure
    3. Object Programming
      1. The Object Model
      2. Getting Help in the Object Browser
    4. Event Procedures and Macros
    5. Using the Object Model in Access
      1. The Access Object Model
  2. Programming Basics
    1. Data Basics
    2. Scope of Variables
    3. Naming Variables
    4. Using Variables to Accept User Input
  3. Control Structures
    1. Decision Structures
    2. Loop Structures
  4. Custom Dialog Boxes
    1. User Forms
    2. Events
  5. Debugging and Error Handling
    1. Errors
    2. Debugging
    3. 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 is required for this VBA class:

  • Expertise in Microsoft Access

Training for your Team

Length: 1 Day
  • Private Class for your Team
  • Online or On-location
  • Customizable
  • Expert Instructors

What people say about our training

A great primer for using Google Analytics. Even as a more experienced user, I have a long list of things I will make adjustments to to improve my website tracking.
Daniel Gering
Clackamas County Tourism and Cultural Affairs
This is my 2nd class with Webucators and my experience was as good as the first one (Java for Beginners). The instructor was good and knowledgeable.The class was good and the labs and activities in the class really help to understand the concepts better.
Oscar Avila
Administrative Office of the Courts (JID)
The staff at Webucator was amazingly helpful, and willing to make things happen at the last minute. They definitely went above and beyond what I have experienced with any other training organization. Thanks!!!
Nina Nussbaum-Jones
Lockheed Martin
Taking an online class from Webucator worked very well. Everyone was helpful and professional. The teacher and class material were excellent. It was as good as taking the class in person.
Nancy Mayo
The Gabriel Foundation

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing

64,157

Students who have taken Instructor-led Training

11,950

Organizations who trust Webucator for their Instructor-led training needs

100%

Satisfaction guarantee and retake option

9.30

Students rated our trainers 9.30 out of 10 based on 30,188 reviews

Contact Us or call 1-877-932-8228