For training call +44(0)1273 6222 72

Your basket is empty View Cart shopping cart

VBA For Access Training

  1. / home
  2. microsoft-office-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

Upcoming Dates

Aberdeen, UK

  1. 16 Oct 2020
  2. MORE DATES

Belfast, UK

  1. 16 Oct 2020
  2. MORE DATES

Birmingham, UK

  1. 16 Oct 2020
  2. MORE DATES

Bournemouth, UK

  1. 16 Oct 2020
  2. MORE DATES

Brighton, UK

  1. 16 Oct 2020
  2. MORE DATES

Bristol, UK

  1. 16 Oct 2020
  2. MORE DATES

Cambridge, UK

  1. 16 Oct 2020
  2. MORE DATES

Cardiff, UK

  1. 16 Oct 2020
  2. MORE DATES

Dublin, UK

  1. 16 Oct 2020
  2. MORE DATES

Edinburgh, UK

  1. 16 Oct 2020
  2. MORE DATES

Glasgow, UK

  1. 16 Oct 2020
  2. MORE DATES

Leeds, UK

  1. 16 Oct 2020
  2. MORE DATES

Liverpool, UK

  1. 16 Oct 2020
  2. MORE DATES

London, UK

  1. 16 Oct 2020
  2. MORE DATES

Manchester, UK

  1. 16 Oct 2020
  2. MORE DATES

Milton Keynes, UK

  1. 16 Oct 2020
  2. MORE DATES

Newcastle, UK

  1. 16 Oct 2020
  2. MORE DATES

Norwich, UK

  1. 16 Oct 2020
  2. MORE DATES

Nottingham, UK

  1. 16 Oct 2020
  2. MORE DATES

Reading, UK

  1. 16 Oct 2020
  2. MORE DATES

Sheffield, UK

  1. 16 Oct 2020
  2. MORE DATES

Southampton, UK

  1. 16 Oct 2020
  2. MORE DATES

Virtual, UK

  1. 16 Oct 2020
  2. MORE DATES

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.

Related Courses

Looking for Online Training?

AgilePM, PRINCE2® & MSP® eLearning

A flexible, cost-effective way to gain your AgilePM, PRINCE2 & MSP qualifications online with our APMG accredited AgilePM eLearning, PRINCE2 eLearning & MSP eLearning packages.

ITIL®, PRINCE2®, PRINCE2 Agile®, MSP®, M_o_R®, P3O®, MoP®, MoV® courses on this website are offered by The Knowledge Academy, ATO of AXELOS Limited. ITIL®, PRINCE2®, PRINCE2 Agile®, MSP®, M_o_R®, P3O®, MoP®, MoV® are registered trade marks of AXELOS Limited. All rights reserved.