MS Access 2003 VBA

Mouse Training

Training

In London

Price on request

The best Access courses

See all

See all

Description

  • Type

    Training

  • Location

    London

  • Duration

    2 Days

This course will provide users that have existing advanced level skills in Access to build on their knowledge. It will focus on automating repitive tasks in Access using the VBA programming language. Suitable for: Advanced Access users whom need to start automating database tasks or simply complex database sequences.

Facilities

Location

Start date

London
See map
7th Floor Crystal Gate 28-30 Worship Street, EC2A 2AH

Start date

On request

About this course

To maximize the gain you receive from our MS Access 2003 VBA training course, it is recommended that you have attended our MS Access Advanced course or that you are at a similiar level.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

Course Contents

Macros

  • Creating Macros
  • Assigning Macros to Controls
  • Group Macros
  • Conditional Macros
  • The AutoExec Macro
  • The AutoKeys Macro

VBA

  • An overview
  • The Environment
  • Working with Modules
  • Converting Macros -DOCMD
  • Events

Coding Structutes

  • Control Structures
  • Looping Structures

Functions

  • Purpose
  • Creating and using Functions

Variables

  • Option Explicit
  • Variable Type
  • Scoping a Variable
  • Testing Variable Contents

User Interaction

  • MsgBox
  • InputBox

Debugging and Error Handling

  • Breakpoints
  • Stepping Code
  • The Immediate Window
  • Creating Error Traps

Data Access Objects (DAO)

  • The Workspace Session
  • Manipulating Recordsets
  • Creating Queries
  • Creating Tables

Active X Controls

  • VBA Menus and Toolbars
Time: The course starts at 09:30 and runs until 16:30.

The course is run on a date that suits you! We do not run public scheduled courses.

Additional information

Payment options: All our courses are charged at a flat rate per day. One to One - Charged at £450 per day Training our Training centre - Charged at £695 per day All prices are excluding VAT and per day. Travel cost outside the M25 applies.

See related categories

MS Access 2003 VBA

Price on request

The best Access courses

See all

See all