Instructor Led Using Expressions Training Classes
From Mullan Training
VB Access



...g with procedures and functions
understanding objects
using expressions, variables and intrinsic functions.
mastering how to control program execution
working with forms and controls
working with the PivotTable object.
Debugging code
handling errors to ensure minimal downtime while building and effecting the program.
COURSE CONTENT
The VBA Programming Environment
When to
more...
VB Excel


...g with procedures and functions
understanding objects
using expressions, variables and intrinsic functions.
mastering how to control program execution
working with forms and controls
working with the PivotTable object.
debugging code & handling errors to ensure minimal downtime while building and effecting the program.
COURSE CONTENT
Introduction
What is a Macro
more...
From Computer Training Source, Inc.
Microsoft Access VBA
.... 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 use 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
more...
From Training Connection
Excel VBA Training
...
Use Variables of various Data Types
Manipulate Data using Expressions
Declare and use Variables of correct Scope
Declare and use Procedures of correct Scope
Create Sub and Function Procedures
Call one Procedure from other
Unit 3: Control Structures
Use Decision Structures to create procedures that execute code
Use Loop structures to execute code repeatedly
Unit
more...
