Don't miss our Black Friday 20% Off Self-Paced Courses and Vouchers!
Use code SP-BLACKFRIDAY at checkout.
VBA

Access 2019: VBA Programming Training (ACC301.19)

Course Length: 1 day

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

Access 2019: VBA Programming Training

Register or Request Training

  • Private class for your team
  • Live expert instructor
  • Online or on‑location
  • Customizable agenda
  • Proposal turnaround within 1–2 business days

Course Overview

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

Course Benefits

  • Learn to use VBA within Microsoft Access.

Delivery Methods

Microsoft Certified Partner

Our curriculum has been tested and approved by ProCert Labs, the official tester of Microsoft courseware, and meets the highest instructional standards.

Microsoft Silver Certified Partner

Course 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 receives a comprehensive set of materials, including course notes and all class examples.

Class Prerequisites

Experience in the following is required for this VBA class:

  • Expertise in Microsoft Access

Have questions about this course?

We can help with curriculum details, delivery options, pricing, or anything else. Reach out and we’ll point you in the right direction.