Access 2016: VBA Programming Training

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

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
Preparing for Class

Training for your Team

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

Training for Yourself

$325.00 or 1 vouchers
  • Live Online Training
  • For Individuals
  • Expert Instructors
  • Guaranteed to Run
  • 100% Free Re-take Option
  • 1-minute Video

What people say about our training

This is not what I expected for a web-based class. I loved that the class size was so small and that we were able to have as much interaction with the instructor as we did. Instructor did an amazing job! I Definitely would recommend Webucator to my co-workers and friends.
Kimberly Hernandez
Colorado Dept of Local Affairs
World Class Service.
Mike Egler
Veolia
I am leaving this class with lots of new information that I can apply to my everyday tasks.
Irma Luque
United States Postal Service (USPS)
Webucator took the time to customize the training to meet our needs. The instructor was excellent and continued to use examples pertinent to us.
Alex Yohn
West Virginia University

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing

61,023

Students who have taken Instructor-led Training

11,715

Organizations who trust Webucator for their Instructor-led training needs

100%

Satisfaction guarantee and retake option

9.29

Students rated our trainers 9.29 out of 10 based on 28,956 reviews

Contact Us or call 1-877-932-8228