Microsoft Access VBA - Programming

VBA is the programming Interface for Access. It allows you to automate tasks and even control other applications such as PowerPoint and Word.

    Aug 9 2021

    Date: 08/09/2021 - 08/11/2021 (Monday - Wednesday) | 8:30 AM - 4:30 PM (EST)
    Location: ONLINE (Virtual Classroom Live)
    Delivery Format: VIRTUAL CLASSROOM LIVE Request Quote & Enroll

    Success! Your message has been sent to us.
    Error! There was an error sending your message.
    REQUEST MORE INFO:

    Microsoft Access VBA - Programming

    August 9 - 11, 2021 | 8:30 AM - 4:30 PM (EST) | Virtual Classroom Live


    How Did You Hear of Global IT Training?

    Join Our Email List?

    Sep 13 2021

    Date: 09/13/2021 - 09/15/2021 (Monday - Wednesday) | 8:30 AM - 4:30 PM (EST)
    Location: ONLINE (Virtual Classroom Live)
    Delivery Format: VIRTUAL CLASSROOM LIVE Request Quote & Enroll

    Success! Your message has been sent to us.
    Error! There was an error sending your message.
    REQUEST MORE INFO:

    Microsoft Access VBA - Programming

    September 13 - 15, 2021 | 8:30 AM - 4:30 PM (EST) | Virtual Classroom Live


    How Did You Hear of Global IT Training?

    Join Our Email List?

    Nov 15 2021

    Date: 11/15/2021 - 11/17/2021 (Monday - Wednesday) | 8:30 AM - 4:30 PM (EST)
    Location: ONLINE (Virtual Classroom Live)
    Delivery Format: VIRTUAL CLASSROOM LIVE Request Quote & Enroll

    Success! Your message has been sent to us.
    Error! There was an error sending your message.
    REQUEST MORE INFO:

    Microsoft Access VBA - Programming

    November 15 - 17, 2021 | 8:30 AM - 4:30 PM (EST) | Virtual Classroom Live


    How Did You Hear of Global IT Training?

    Join Our Email List?

Understanding the Access Object Hierarchy

  • Understanding Access Objects
  • Using the Object Browser
  • Controlling the Application Object
  • Understanding the Forms Collection and Form Object
  • Understanding the Controls Collection and Control Object
  • Using the With Statement
  • Understanding the Reports Collection and Report Object
  • Understanding the DoCmd Object
  • Using the Screen Object

Using Variables Arrays and Constants

  • Declaring Variables
  • Declaring Arrays
  • Declaring Constants
  • Declaring Object Variables

Using Functions Message Boxes and Input Boxes

  • Using Intrinsic Functions
  • Using Message Boxes
  • Using Input Boxes

Controlling Program Execution

  • Using Control Structures
  • Working with Conditional Expressions
  • Using the IfThenEnd If Structure
  • Using the IfThenElseEnd If Structure
  • Using the Select CaseEnd Select Structure
  • Using the DoLoop Structure
  • Using the For Next Structure

Debugging Code

  • Understanding Errors
  • Using Debugging Tools
  • Stepping Through Code and Setting Break Points
  • Understanding Error Events
  • Understanding the Error Object
  • Using the On Error Statement
  • Writing an Error Handling Routine
  • Compiling All Procedures

*Please Note: Course Outline is subject to change without notice. Exact course outline will be provided at time of registration.

Students will learn how to:

  • Understand the Access Object Hierarchy
  • Use Variables Arrays and Constants
  • Use Functions Message Boxes and Input Boxes
  • Control Program Execution
  • Debug Code

In order to take this course, students must possess an advanced level of Access skills and knowledge. Also, the student must have a fair amount of practical experience with the program.

Students who have an advanced familiarity with Microsoft Access but have never done any VBA programming should attend.

Ready to Jumpstart Your IT Career?

CONTACT US NOW!