MS Access 2007 VBA

Mouse Training

Training

Inhouse

Price on request

The best Access courses

See all

See all

Description

  • Type

    Training

  • Methodology

    Inhouse

  • Duration

    2 Days

This course will provide users that have existing advanced level skills in Access to build on their knowledge. The Visual Basic course 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.

About this course

To maximize the gain you receive from our MS Access 2007 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 Group Onsite Training - Charged at £595 per day. Thats for up to 8 delegates costing less than £75 per person! All prices are excluding VAT and per day. Travel cost outside the M25 applies.
Students per class: 8

See related categories

MS Access 2007 VBA

Price on request

The best Access courses

See all

See all