Microsoft Access VBA – Programming

Learn via : Virtual Classroom / Online
Duration : 3 Days
  1. Home
  2. Microsoft Access VBA – Programming

Description

    VBA is the programming Interface for Access.

    This Microsoft Access VBA training course will teach you how to manipulate your Access database using VBA (Visual Basic for Applications) code, automating the database.  Access VBA extends the features of the database, providing you with the full power of Visual Basic programming to manipulate Access objects.

     

    What You’ll Learn

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

Outline

The VBA Code Editor

  • Two ways to create modules
  • Using Project Explorer
  • Basic subroutines and comments

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 ans Error handling

  • 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