Visual Basic for Applications in Microsoft Access Training

VBA in Access Certification Training Course Overview

This VBA for Access training course is designed for experienced users of Access' advanced features, who wish to extend their knowledge to include the use of Visual Basic for Applications (VBA) within Access.

 

Visual Basic for Applications in Microsoft Access Training (Duration : 16 Hours) Download Course Contents

Live Virtual Classroom
Group Training 600 Date On Request
1-on-1 Training (GTR) 700
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here
Hire Our Trainers! Click here

Course Modules

Module 1: 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
Module 2: Using Variables Arrays and Constants
  • Declaring Variables
  • Declaring Arrays
  • Declaring Constants
  • Declaring Object Variables
Module 3: Using Functions Message Boxes and Input Boxes
  • Using Intrinsic Functions
  • Using Message Boxes
  • Using Input Boxes
Module 4: 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
Module 5: 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
Download Course Contents

Request More Information

Course Prerequisites

This course is for those who possess and advanced understanding of Microsoft Access and are looking to expand their knowledge even further. Ideally, the delegate will have some knowledge of macros in relation to Office applications.

 

Course Objectives :

After attending this VBA for Access course, delegates will be able to:

  • Use VBA for Access for advanced automation features
  • Write and understand Visual Basic code
  • Use VBA to manipulate and edit a database