Excel Foundation

Excel Advanced

Excel Visual Basic

Access Foundation

Access Advanced

Access Visual Basic

Word Foundation

Word Advanced

Outlook Foundation

PowerPoint Foundation

Project Foundation

Visio Foundation

FrontPage Foundation

Dreamweaver Foundation

PageMaker Foundation

IT Training

Business Finance and Budgeting

Team Leadership and Management

  Microsoft Access Visual Basic


3 Days

Principal Topics

Macro Revision

Limitation of Macros

Why use Visual Basic?

Overview of Functions & Subprocedures

Understanding Event Procedures & Modules

The concepts of object based code

The three types of Event - Form, Section & Control

Writing and using a User Defined Function

Passing parameters to a Function

Using Macro commands in Visual Basic

Step Mode

The Immediate Window

Methods and Properties

Controlling program flow

Creating and Declaring Variables

Using the Debug Window

Trapping Run-time errors

Using MsgBox and InputBox

Calling one Procedure from another


Using VB to Call SQL statements

Using VB to control Excel

Using VB to send e-mail

Copyright ©2006-2013

vb training leeds, vba training leeds, excel vba, access vba, pc training in leeds, computer training in yorkshire, pc training in yorkshire, computer training in leeds, microsoft access vb, microsoft excel vb training, microsoft powerpoint training, microsoft training, microsoft word, office 2000, excel training leeds, access training leeds, office training leeds, office 2007, leeds vba, leeds visual basic, leeds training