Follow Us :

Microsoft Access VBA Introduction

Course_Reference: 
E2-AVBA
Manufacturer: 
0
Training_Provider: 
112
Summary: 

The skills and knowledge acquired in Microsoft Access VBA Introduction are sufficient to be able to use and operate the software at an efficient level.

PreRequisites: 

Microsoft Access VBA Introduction assumes the delegate has completed the Access Fundamentals and Access Specialised courses or has equivalent knowledge.

Audience: 

Microsoft Access VBA Introduction is designed for users who are keen to extend their understanding and knowledge of the software.

Objectives: 

At the completion of Microsoft Access VBA Introduction you should be able to:

  • work with objects
  • use the Object Browser
  • identify collection objects
  • use the Controls collection.
  • manipulate data by declaring variables
  • combine data by using expressions
  • get user input
  • create Sub and Function procedures, and call one procedure from another.
  • use decision structures and loop structures.
  • identify ActiveX Data Objects (ADO) architecture and collections, connect to a database, work with a

Recordset, and create a parameter query.

  • identify compile-time, run-time, and logical errors
  • use the debugging tools
  • write error-handling code

Create powerful applications

Objects, Properties and Methods

Synchronising Forms

Storing Return Values

Learn basic programming structures

Working with Modules

Creating Sub Procedures

Calling Sub Procedures

Work with conditional statements and loops

The If Statement

The Do Command

Looping

Create custom message boxes

Evaluating a Message box

Responding to User

Selections

Create Custom functions

Using Built-in Functions

Creating Custom Functions

Calling Function Procedures

Interact with Excel or Word

Opening Other Applications

Destroying Object Variables

Adding Data

Write error-handling code

Stepping Through Code

Using the Intermediate Window

Setting a Watch on a Variable

Validating User Input

Checking for Null Values

Offering Choices

Description: 

The skills and knowledge acquired in Microsoft Access VBA Introduction are sufficient to be able to use and operate the software at an efficient level.

Keywords: 
ADO, ActiveX Data Objects, Basics, Recordset, Access Fundamentals,

Software Vendor

IT Technical

Business Skills