Skip to main content

Print Page
Home / Training Courses / Microsoft Access VBA (2 days)

Microsoft Access VBA (2 days)

Training Description

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

The Course Suits

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

Training Benefits

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

Course Timetable

The course focuses on practical work within the product giving delegates ample opportunity to use their PC skills through a series of graded exercisesTopics covered include:
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 SelectionsCreate 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

© PTP/AVBA

Please Choose from the list below:

Microsoft Access VBA (2 days) training course available to book:

Microsoft Access VBA (2 days) courses
Training Location Training Date Training Price Book Trainging
London (IT Centre) 02-04-2012 £695.00 Book Microsoft Access VBA (2 days) Course Online
London (IT Centre) 02-07-2012 £695.00 Book Microsoft Access VBA (2 days) Course Online
London (IT Centre) 01-10-2012 £695.00 Book Microsoft Access VBA (2 days) Course Online

Book inhouse

To book the Microsoft Access VBA (2 days) course as an in-house programme click here (£1600 per day for up to 10 delegates)

date:  change date

Book One to One

To book 1- to-1 coaching based on the Microsoft Access VBA (2 days) course click here (£600 per session)

date:
 change date am pm

Book U-Choose

To book the Microsoft Access VBA (2 days) course through our U-Choose product select location below (£425 per delegate min 2 delegates):

date:  change date
location:

Related Items:
There's no related items for that course.