Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Microsoft Access VBA - Programming

New – Learn to use VBA to automate tasks and control other applications.

GK# 6740

Course Overview

TOP

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

Schedule

TOP
  • Delivery Format:
  • Date:
  • Location:
  • Access Period:

$

What You'll Learn

TOP

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

Outline

TOP
Viewing outline for:

Virtual Classroom Live Outline

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

Prerequisites

TOP

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.

Who Should Attend

TOP

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

Course Delivery

This course is available in the following formats:

Virtual Classroom Live

Experience expert-led online training from the convenience of your home, office or anywhere with an internet connection.

Duration: 3 day

Classroom Live

Receive face-to-face instruction at one of our training center locations.

Duration: 3 day

Classroom Live

Receive face-to-face instruction at one of our training center locations.

Duration: 3 day

Virtual Classroom Live

Experience expert-led online training from the convenience of your home, office or anywhere with an internet connection.

Duration: 3 day

Request this course in a different delivery format.
Enroll