Courses

All courses are designed to last one day. Each student receives a Manual covering all of the course contents, access to all the sample files used during the course and a Certificate. Click on the course (Introduction, Intermediate, Advanced or Bridging) below for more information:

Bridging Courses are intended for students who have a working knowledge of VBA through use of one of the other applications and wishes to use VBA in a new Application. Each Bridging Course covers the unique features of the application VBA and assumes that the student has a working knowledge of Visual Basic programming.

We reserve the right to change the contents of the courses. While every effort will be made to adhere to the overviews below, occasionally influences beyond our control (for example, time or teaching environment) may effect the the topics covered. Positive changes can also prevail whereby students may wish to cover additional or alternative topics to suit their needs or requirements - please feel free to contact us if you want to discuss in advance any customisation of the course contents.

Excel VBA Courses

The objective of this course is to provide the student with the knowledge and confidence to write Visual Basic Code in the Excel environment. The course is structured so that the student is producing code quickly and is aware of the applications requirements, limitations and security implications. Emphasis is placed on writing well structured and effective code. This is an intensive course and a basic knowledge of Excel is required. Course contents:

Introduction	Security Creating a Personal Workbook The Visual Basic Editor Subroutines Range Object The Active Cell Operators Variables Triggering Code to Run
Building Formal  Control Structures	Comparison Operators If .. Then Decision Structures For loops Do loops Select Case Decision Structures
The Excel Object Model	Objects Collections Referring to Objects and Collections in Code Properties Methods
Using Visual  Basic Functions	InputBox Function MsgBox Function
Triggering Code to Run	Using the Menu Bar Using a Shortcut Key on the Keyboard Using a Toolbar Icon Using the Menu Bar Using a ActiveX Control Button On an Area, Hot Spot, or Graphic Object (Shape) More about the Macro Window Write an Excel Add-in

The objective of this course is to provide the student with the knowledge and ability to build on the topics covered in the Introduction level course and use the more sophisticated features available in the Excel Visual Basic environment. This is an intensive course and prior knowledge of the basics of Visual Basic coding is required. Course contents:

Visual Basic Editor	Code or Module Window Running a Single Line of Code (Immediate Window) Monitoring Variable Values (Locals Windows) Looking-up Properties, Methods etc. (Object Browser) Monitoring Variable Values (Watch Window) Checking a Variable Value (Quick Watch) Running your Code Breakpoints Break Mode Bookmarks Executing a different Next Statement Conditional Compilation
User Forms	Creating a Form Designing Forms Working with Controls Controls Rounding-Off a Form Design Tools
Standard Dialog Boxes	Using the File Open Dialog Box Using the File Save As Dialog Box
Office Objects	Office Objects Map Command Bars File Search Object

The objective of this course is to provide the student with the knowledge and ability to build on the topics covered in the Introduction and Intermediate level courses and use the advanced features available in the Excel Visual Basic environment. This is an intensive course and prior knowledge of the basics of Visual Basic coding is required. Course contents:

Reading and Writing Data Files	Accessing Files Reading Data Writing Data
Working across Applications	Accessing other Applications Controlling other Applications Objects Word Objects Access Objects Visio Objects
Using Dynamic link Libraries	Using Dynamic Link Libraries Windows Libraries

Word VBA Courses

~~~~~ Under Development ~~~~~ 

The objective of this course is to provide the student with the knowledge and confidence to write Visual Basic Code in the Word environment. The course is structured so that the student is producing code quickly and is aware of the applications requirements, limitations and security implications. Emphasis is placed on writing well structured and effective code. This is an intensive course and a basic knowledge of Word is required. Course contents:

Introduction	Security Creating a Personal Workbook The Visual Basic Editor Subroutines Range Object The Selection Object Operators Variables Triggering Code to Run
Building Formal  Control Structures	Comparison Operators If .. Then Decision Structures For loops Do loops Select Case Decision Structures
Objects	Objects Collections Referring to Objects and Collections in Code Properties Methods
Using Visual  Basic Functions	InputBox Function MsgBox Function
Triggering Code to Run	Using the Menu Bar Using a Shortcut Key on the Keyboard Using a Toolbar Icon Using the Menu Bar Using a ActiveX Control Button On an Area, Hot Spot, or Graphic Object (Shape) More about the Macro Window Write an Excel Add-in

~~~~~ Under Development ~~~~~ 

The objective of this course is to provide the student with the knowledge and ability to build on the topics covered in the Introduction level course and use the more sophisticated features available in the Word Visual Basic environment. This is an intensive course and prior knowledge of the basics of Visual Basic coding is required. Course contents:

Visual Basic Editor	Code or Module Window Running a Single Line of Code (Immediate Window) Monitoring Variable Values (Locals Windows) Looking-up Properties, Methods etc. (Object Browser) Monitoring Variable Values (Watch Window) Checking a Variable Value (Quick Watch) Running your Code Breakpoints Break Mode Bookmarks Executing a different Next Statement Conditional Compilation
User Forms	Creating a Form Designing Forms Working with Controls Controls Rounding-Off a Form Design Tools
Command Bars	The Principles Command Bar (Menu Bar or Toolbar Bar or Shortcut Bar) Command Bar Control (Button, Box or Pop-up)

~~~~~ Under Development ~~~~~ 

The objective of this course is to provide the student with the knowledge and ability to build on the topics covered in the Introduction and Intermediate level courses and use the advanced features available in the Word Visual Basic environment. This is an intensive course and prior knowledge of the basics of Visual Basic coding is required. Course contents:

Reading and Writing Data Files	Accessing Files Reading Data Writing Data
Working across Applications	Accessing other Applications Controlling other Applications Objects Excel Objects Access Objects Visio Objects
Using Dynamic link Libraries	Using Dynamic Link Libraries Windows Libraries

Access VBA Courses

The objective of this course is to provide the student with the knowledge and confidence to write Visual Basic Code in the Access environment. The course is structured so that the student is producing code quickly and is aware of the applications requirements, limitations and security implications. Emphasis is placed on writing well structured and effective code. This is an intensive course and a basic knowledge of Access is required. Course contents:

Introduction	Using the Visual Basic Editor Creating Procedures Understanding Variables
Understand Objects, Collections, Properties and Methods	Objects and Collections Properties Methods
Building Formal  Control Structures	Comparison Operators If .. Then Decision Structures For loops Do loops Select Case Decision Structures
Using Visual  Basic Functions	The InputBox Function The MsgBox Function The DoCmd Method
Manage Forms	Forms and Controls Form Events
Use Recordsets	Recordsets Types of Recordsets The RecordSet Object and it's properties/methods Using Recordsets to manipulate Table contents Form Recordsets
Use TableDefs	TableDefs Creation of TableDefs (Create a Table automatically through code)