Welcome to Premier

Your people are your most precious asset. Whether you are an existing Premier client, or a new customer looking to experience our services for the first time, welcome

ACCESS VISUAL BASIC
Introduction to Programming
What is Visual Basic for Applications?
Event -driven procedures
Modules and code behind forms

MODULES & PROCEDURES
The module toolbar
Sub and function procedures
Databases and projects

USER DEFINED FUNCTIONS
Creating user defined functions
Arguments and returned values
Access built in functions
Using user defined functions in queries and forms

EVENT PROCEDURES
The code builder
Form, report, control, and section events
Referring to form and report controls
Incorporating macro actions

VARIABLES, CONSTANTS AND ARRAYS
Implicit and explicit declaration
Scope of variables
VBA data types
Arrays and user defined data types

BRANCHING AND LOOPING STRUCTURES
Branching - If.End If and Select Case Looping - Do Loop and For Next

USER INTERACTION
The input box and message box
The common dialog control

DEBUGGING VBA
Types of Error
Using the immediate window setting
Break points
Correcting errors

ERROR HANDLING
On error statement
Trapping error code

ACTIVE X DATA OBJECTS
DAO or ADO?
Microsoft Access Architecture
Open objects and collections
Database engine objects
Setting object variables
Handling recordsets
Locating and editing data
Handling queries
Adding and deleting objects to collections
Using transactions

CREATING LIBRARIES
Add in manager

4 Ravey Street
London EC2A 4QP
t: +44(0)20 7729 1811
f:+44(0)20 7729 9412
information@premiercs.co.uk