$895

Microsoft Access: Programming with VBA: Training at ExecuTrain of Wichita

Event Information

Share this event

Date and Time

Location

Location

ExecuTrain of Wichita

727 North Waco Avenue

Suite 180

Wichita, KS 67203

View Map

Event description

Description

When you create a new database, you typically begin by creating a few database objects such as tables, forms, and reports. Eventually, you reach a point where you need to add some programming to automate certain processes and tie your database objects together. In Access, programming is the process of adding functionality to your database by using Access macros or Visual Basic for Applications (VBA) code. For example, suppose you have created a form and a report, and you want to add a command button to the form that, when clicked, opens the report. Programming, in this case, is the process of creating a macro or VBA procedure and then setting the command button's OnClickevent property so that clicking the command button runs the macro or procedure.

In this introductory Visual Basic for Applications (VBA) training course, you will learn how to manipulate objects in Access with VBA. Specifically, you will learn how to use the Visual Basic editor, work with the object model, create and use variables, and use the selection structure. You will learn to use flow control, create custom dialogs, automate processes, and handle errors.

Each lesson of the class begins with a general overview of a feature and then shows how that feature works in Access. Click here for a detailed outline.


Upon completion of this course students will be able to:

  • Understand how the Visual Basic editor works in Access.
  • Learn to work with the VBA object model.
  • Learn to work with VBA object variables.
  • Learn to work with string variables.
  • Learn to work with date variables.
  • Learn to work with numeric variables.
  • Learn to use the selection structure.
  • Learn to use the Select Case statement and the MsgBox function.
  • Learn to work with the repetition structure.
  • Learn to work with option button, check box, and list box controls.
  • Learn to use Automation.
  • Learn to trap errors.

Please feel free to call or email us with any questions, or to reserve your seat in this course!

For additional Access training in Wichita, visit: http://wichita.executrain.com/access.html

ExecuTrain of Wichita
727 N. Waco, Suite 180
Wichita, KS. 67203
316.267.4000
info@wichita.executrain.com

Share with friends

Date and Time

Location

ExecuTrain of Wichita

727 North Waco Avenue

Suite 180

Wichita, KS 67203

View Map

Save This Event

Event Saved