Browse all IT training courses

Access VBA Programming Introduction

Click here for a PDF version

Introduction

Microsoft Access is one of the world’s leading database packages. Good databases can become brilliant systems when VBA is used to customise what it does. 

Objectives

To teach the basics of Visual Basic programming within Access including automatic/background processing of data. The trainees will learn how to create a Wizard, interact with the user, process data in the background and run queries from user input. 

Designed for

Experienced users of Access. No previous experience of programming is required. 

Duration

2 Days 

Topics

  • Programming Basics
  • The Visual Basic Editor
  • Objects & Properties
  • Methods & Arguments
  • Message Boxes
  • Input Boxes
  • Include comments
  • Event Driven Procedures
  • Variables
  • Create variables
  • Variable types
  • Setting variables
  • Scope of Variables
  • Data Processing
  • Find records
  • Update records
  • Recordsets
  • Create recordsets
  • Loops
  • Edit and Update Records
  • Query by Form
  • SQL
  • The Querydefs collection
  • Advanced Programming
  • Debug
  • Calling Procedures
  • Trapping Errors
  • Passing variables to other procedures

Follow-up

Individual consultancy and tuition as required 

Get in Touch

Pricing Guide:

  • 1

    £495 per head

  • 4

    £130 per head

  • 8

    £70 per head

Ask us about training for roll-outs and bespoke systems.

…and every course includes

  • Custom-building the course for you
  • Free post-course support helpline
  • All course materials
  • Trainer expenses