Microsoft Access Training Microsoft Access VBA (2-day) A Two-day training course NOTE: Click on the blue tabs below for more information.

About the Course
aims & attendees

Course Outline
topics covered

Public Courses
with dates & prices

Private Courses
with prices

About the course: Microsoft Access VBA (2-day)

Course Aims

This training course can be covered in 2 or 3 days, depending on the depth of knowledge and expertise required. It is designed to give advanced users of Microsoft Access a solid grounding in the use of Microsoft Visual Basic to automate and enhance their Access applications. It is extremely 'hands on' and enables participants to gain practical experience of the subject, as well as a good understanding of the concepts involved.

Who Should Attend?

Existing users of Microsoft Access who want to automate and enhance their databases using Microsoft Visual Basic.
Note: A thorough knowledge of Microsoft Access is essential, although no knowledge of Microsoft Visual Basic is needed.

Click for the course outline.

Public Courses for Microsoft Access VBA (2-day)

Sorry -- we do not arrange scheduled public courses for our Microsoft Access VBA (2-day) course at the moment.

But if you would like to arrange a private training course, [click here for details] please contact us and we'll be pleased to discuss the best options for you.

Private Courses for Microsoft Access VBA (2-day)

We provide private training courses which can be delivered at our training centre or on your premises, on dates to suit you and your staff.

Course content can either follow the standard outline [click here for details], or be tailored to your requirements at no extra charge.

While we will organise training courses for as many delegates as you wish, we recommend that any class does not exceed 4 delegates to ensure that learning objectives are met.

Prices

For training at our centres or your offices.
Prices vary according to the size of the class, but can be as low as Ł155 per delegate.
At your offices – From Ł499 : Call for more details
At our centres – From Ł549 : Call for more details

Please note : all prices exclude VAT

Click to:
Print the course outline

Course Outline

Starting Simple Automation

Start-Up

Macros

Creating Macros

Editing Macros

Controlling Macro Flow

Conditional Macros

Group Macros

The AutoExec Macro

The AutoKeys Macro

The CommandButton Wizard

Working with Events

Attaching Macros to Objects

The Macro Converter

Writing Code with DoCmd

Editing CommandButton Coding

VBA Syntax

Object, Methods and Properties

The Object Browser

Understanding Modules

Module Format

Local and Global Availability

Calling Routines

Variables, Constants and Arrays

Using Option Explicit

Declarations

Variable Type

Scoping

ReDim

Object Variables (non scalar)

Code Flow

Conditional Structures

Loop Structures

DoEvents

Coding on UserForms

Naming Conventions

Navigation

Validation

Responding to Keyboard Events

Passing Information

User Interaction

Inputbox

ComboBoxes and List Boxes

Creating Filter Screens

Storing User Input

Using Stored Input in Reports

Application Information

Login Information

Activity Information

Record Edit Information

Using VBA to control menus and toolbars

Working with Errors

Building Error Traps

Creating Error Messages

Using the Immediate Window

Breakpoints

Step Code

Using Bookmarks

DAO and ADO

Manipulating Recordsets

SQL Recordsets

Creating Queries

Creating Tables

Using DAO/ADO from Word/Excel

Activia, Regus House, 268 Bath Road, Slough, Berkshire SL1 4DX
Telephone: 0845 230 6150 (local rate)

Access training courses UK | Why Activia
Copywriting for web sitesBook your accredited Microsoft Access Training with Activia

Why Activia for Microsoft Access Training ?

Microsoft Access Training in West London, Birmingham, Slough, London Heathrow and Aylesbury

Activia should be your first choice for training in Access in the UK. We provide you with a full range of classes for job-related Business Skills, HR & Supervision, Sales and Management Development as well as IT applications from Microsoft, Sage, Adobe, Macromedia, Crystal Reports and Lotus. If you are looking for MS Access classes, you will find that Activia offers a level of service that is unrivalled in the market.

Training in MS Access

If your requirement is courses for Microsoft Access, we can provide you with classes at highly competitive prices. You will find that for Microsoft Access classes, Activia will provide more tailored, flexible and focused solutions, and this enables you to get the most from your budget using the minimum of resources.

Courses in London, the Midlands, Berkshire (Berks), Buckinghamshire (Bucks), Surrey, Middlesex and UK wide

We provide Microsoft Access Training courses all over the UK, with modern, fully equipped training centres in the following locations:

West London

Serving London, as well as areas like Brentford, Kew, Watford and Richmond.

London Heathrow

Serving Middlesex and Surrey, covering Uxbridge, Staines, Egham, Sunbury, Hounslow and Twickenham.

Birmingham

Serving Warwickshire and the Midlands, covering Solihull, Dudley and Wolverhampton as well as Coventry, Telford and Worcester.

Slough

Serving Berkshire and the Thames Valley, covering Slough, Reading, Windsor and Maidenhead as well as Bracknell, Newbury and Basingstoke.

Aylesbury

Serving Buckinghamshire, covering Aylesbury, Milton Keynes and High Wycombe, as well as Oxford, Luton and Hemel Hempstead.
Our experienced, high quality trainers will deliver your training to the highest standards and with the maximum effect.

In House Microsoft Access Training Courses across the UK

For in house delivery of Training in MS Access, we have an established national UK network of trainers, as well as centres in London, Birmingham, Slough, London Heathrow and Aylesbury, so you can be sure that your training in Access will be delivered in a quality assured and cost effective manner. For in-house courses for Microsoft Access, you need look no further than Activia.

[ Close ]

Activia's Quick Course Finder
Welcome to Activia's easy-to-use Quick Course Finder Just click on any heading (in black) or section (in blue) to go straight to where you need to be Or click here to close the Quick Course Finder and return to the page you were on
Staff Development Training MasterClasses	Professional & Management Training	IT Applications Training
[ Close Quick Course Finder ]

Microsoft Access Training

Microsoft Access VBA (2-day)

A Two-day training course

About the course: Microsoft Access VBA (2-day)

Course Aims

Who Should Attend?

Public Courses for Microsoft Access VBA (2-day)

Private Courses for Microsoft Access VBA (2-day)

Prices

Course Outline

Starting Simple Automation

Working with Events

The Macro Converter

VBA Syntax

Understanding Modules

Variables, Constants and Arrays

Code Flow

User Interaction

Application Information

Using VBA to control menus and toolbars

Working with Errors

DAO and ADO

Why Activia for Microsoft Access Training ?

Microsoft Access Training in West London, Birmingham, Slough, London Heathrow and Aylesbury

Training in MS Access

Courses in London, the Midlands, Berkshire (Berks), Buckinghamshire (Bucks), Surrey, Middlesex and UK wide

West London

London Heathrow

Birmingham

Slough

Aylesbury

In House Microsoft Access Training Courses across the UK

Activia's Quick Course Finder

Staff Development Training

MasterClasses

Professional & Management Training

IT Applications Training

writeEMtxtLink('../sage/sage.asp','','courseFinderLink1','Sage <span class=&#34;addText&#34;> training</span></h3>'); writeEMtxtLink('../sage/line50.asp','','courseFinderLink2','Sage Line 50 Training'); writeEMtxtLink('../sage/payroll.asp','','courseFinderLink2','Sage Payroll Training');

writeEMtxtLink('../lotus/lotus.asp','','courseFinderLink1','Lotus <span class=&#34;addText&#34;> training</span></h3>'); writeEMtxtLink('../lotus/notes.asp','','courseFinderLink2','Lotus Notes Training'); writeEMtxtLink('../lotus/domino.asp','','courseFinderLink2','Lotus Domino Training');