Microsoft Access Training Courses

Microsoft Access 2000 VBA (2-day) (Not Used)


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 2000 VBA (2-day) (Not Used)

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 2000 VBA (2-day) (Not Used)

Sorry -- we do not arrange scheduled public courses for our Microsoft Access 2000 VBA (2-day) (Not Used) 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 2000 VBA (2-day) (Not Used)

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 Training   Abbey House   18-24 Stoke Road   Slough SL2 5AG
Telephone: 0845 230 6150 (local rate)
[ Close ]

Why Activia for Microsoft Access Training Courses ?

Microsoft Access Training Courses in London, Birmingham, Manchester, Bristol and the South East

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, MS Office, Sage, Adobe, Macromedia, Crystal Reports and Lotus. If you are looking for courses for Microsoft Access, you will find that Activia offers a level of service that is unrivalled in the market, with quality, flexible 1 day Microsoft Access Training Courses at fiercely competitive prices.

Microsoft Access Training

If your requirement is Microsoft Access database software training, we can provide you with training courses from introduction to advanced level at highly competitive prices. You will find that for classes for Microsoft Access, 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, Manchester, Bristol, Berkshire (Berks), Buckinghamshire (Bucks), Hampshire (Hants), Surrey and UK wide

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

Microsoft Access Training Courses in the City of London

Serving the City in Liverpool Street and Fleet Street, and the West End of London, as well as areas like Leytonstone, Walthamstow, Barking, Chingford and Ilford.

Microsoft Access Training Courses in West London

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

Microsoft Access Training in the centre of Bristol

Serving South West England, covering Bristol, Avon and Bath and Radstock in Somerset as well as Clevedon and Chepstow.

Microsoft Access Training Courses in Birmingham City Centre

Serving Warwickshire and the Midlands, covering Birmingham, Walsall and Dudley as well as Wolverhampton, Telford and Tamworth.

Microsoft Access Training in Birmingham South

Serving Warwickshire and the Midlands, covering Solihull, Halesowen and Redditch as well as Coventry, Kidderminster and Worcester.

Microsoft Access Training Courses in Manchester

Serving Lancashire and the North West, covering Manchester, Salford, Stockport and Oldham as well as Bolton, Rochdale, Wigan, Warrington and Macclesfield.

Microsoft Access Training Courses in Reading

Serving Berkshire and the Thames Valley, covering Reading, Theale and Newbury as well as Henley, Bracknell and Basingstoke.

Microsoft Access Training in Slough

Serving Berkshire and the Thames Valley, covering Slough, Windsor and Maidenhead as well as High Wycombe, Uxbridge and Watford.

Microsoft Access Training in Milton Keynes

Serving Buckinghamshire, covering Milton Keynes, Aylesbury and Buckingham, as well as Luton, Bedford, Stevenage, St Albans and Welwyn Garden City.

Microsoft Access Training Courses in Basingstoke

Serving Hampshire, covering Basingstoke, as well as Camberley, Farnborough, Aldershot to the east, and Newbury, Andover and Winchester to the west.

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 Microsoft Access Training, we have an established national UK network of trainers, as well as centres in London, Birmingham, Manchester, Bristol, Slough, Reading, Basingstoke and Milton Keynes, so you can be sure that your training in Access will be delivered in a quality assured and cost effective manner.   For in-house Microsoft Access database software training, you need look no further than Activia.

[ Close ]

Activia Home page

Home

Activia courses

Courses

Activia prices

Prices

Course dates

Dates

Activia locations

Locations

Private Individuals

Private Individuals

Let's talk about quality assured, flexible Microsoft Access Training Courses.
Call Activia to discuss your requirements for Microsoft Access Training.