For training call +44(0)1273 6222 72

Your basket is empty View Cart shopping cart

VBA For Access Training

Just a quick line to let you know how much Ilesh and myself gained from the excellent VBA course we recently attended at your offices. Your facilities are excellent and we were most impressed by the trainer's depth of knowledge and ability to restructure the course dynamically to ensure that we obtained the most relevant training. The two days were not only very informative but also good fun!

Alan Hill - GlaxoSmithKline

MAKE AN ENQUIRY Download Course Outline

This VBA for Access training course is designed for experienced users of Access' advanced features, who wish to extend their knowledge to include the use of Visual Basic for Applications (VBA) within Access.

Prerequisites

This course is for those who possess and advanced understanding of Microsoft Access and are looking to expand their knowledge even further. Ideally, the delegate will have some knowledge of macros in relation to Office applications.


Course Objectives

After attending this VBA for Access course, delegates will be able to:

  • Use VBA for Access for advanced automation features
  • Write and understand Visual Basic code
  • Use VBA to manipulate and edit a database

VBA For Access Training Course Content

Where Code is stored

  • Standard modules
  • Class modules

Development Environment

  • Adding Code to a Form or Report
  • Types of Procedures
  • Entering Code

Running Code

  • Run mode and Design mode
  • Running Code from the development environment
  • Running Code from the host application

Reusing Code

  • Exporting a file
  • Importing a file

Using VB for Applications Using Variables

  • Lifetime and scope of variables
  • Using and writing sub-procedures
  • Using and writing Function procedure

Controlling Programme flow

  • Conditional structures
  • Looping structures
  • Trapping errors

Debugging

  • Using the break mode
  • Using the VB Editor debug features

Using Standard VB

  • Input Boxes
  • Message Boxes
  • Standard VB Functions
  • Functions in your Code

Access Object Module Forms and Form Events

  • Reports and Report Events
  • Creating a Workspace Using the Microsoft Jet Engine
  • Retrieving a Recordset
  • Navigating Records
  • Updating Records
  • Adding Records
  • Querying Data

Using VB

  • Using VB Objects, Methods and Properties to manipulate, read, edit and update data in a Database

Booking

* Required

For in-company or private training please request a quote

 
 

Course Details

  1. Course Title

    VBA For Access Training

  2. Duration

    1 Day

  3. Price Starting From

    £995.00 + VAT

Onsite Training

This course can be run in-company anywhere in the world & we can tailor the content to focus on your requirements.

We regularly provide training in London, Manchester, Bristol and all over the United Kingdom.

Who is this course for?

This course is for those who possess and advanced understanding of Microsoft Access and are looking to expand their knowledge even further. Ideally, the delegate will have some knowledge of macros in relation to Office applications.

New Online Courses  

  +44(0)1273 6222 72 Call now to enquire