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

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 for Microsoft Access Training

Activia Home page

Home

Activia courses

Courses

Activia prices

Prices

Course dates

Dates

Activia locations

Locations