Visual Basic for Applications in Microsoft Access Training

Download Course Contents

VBA in Access 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.

 

This is a Rare Course and it can be take up to 3 weeks to arrange the training.

  • 1. Do you have limited Window for training?
  • 2. Can you only spend 4-hours per day?
  • 3. Do you want to start training immediately?
  • If your answer is yes to any one of the above, you need 1-on-1- Training
The 1-on-1 Advantage
Methodology
Flexible Dates
4-Hour Sessions
  • View video
  • The course will be free if we are not able to start within 7 days of booking.
  • Only applicable for courses on which this logo appears.

Your will learn:

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
  • Declaring Variables
  • Declaring Arrays
  • Declaring Constants
  • Declaring Object Variables
  • Using Intrinsic Functions
  • Using Message Boxes
  • Using Input Boxes
  • 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
  • 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
Live Online Training (Duration : 16 Hours) Fee On Request
Group Training Date On Request
1-on-1 Training
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

1-On-1 Training is Guaranteed to Run (GTR)
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Classroom Training is available. Enquire for the fee Click
Comfort Track

If you think 32 hours is too long. We can offer Comfort Track for 16 hours

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

 

Request More Information

Add Name and Email Address of participant (If different from you)

FAQ's


Yes, fee excludes local taxes.
The Fee includes:
  • Courseware
Yes, Koenig Solutions is a Microsoft Learning Partner