Microsoft Access  - VBADownload Course Outline

This is the basic outline of our Microsoft Access VBA course. Duration: 2 days

Visual Basic for Applications (VBA) is an event driven programming language with an associated integrated development environment (IDE) which is built into most Microsoft Office applications, including Microsoft Access. This course introduces you to the basic concepts that underlie this programming language ans its use to control many aspects of the Access interface.  This course starts you on the journey of writing your own procedures to manipulate user interface features through the automation of forms and controls.

To get the most from this course you don’t need any previous experience of VBA or writing computer programs but you should be a competent Microsoft Access user.

We specialise on on-site training and can come to you to run our course either on your PC's or provide our own high specification equipment. If you want specific training for your staff, we're happy to customise this course to your requirements, adding or removing topics as necessary.

You can get a fixed price quotation, including any travelling or additional expenses here or just see our basic prices here.

Microsoft Access  - VBA course content

Download a PDF course outline using the link on the right.

An Introduction to Event Driven Programming

  • Write procedures that respond the Access Events.

Using the Integrated Development Environment (IDE)

  • Correctly use the Project Explorer to locate Class or Standard Modules.
  • Use the Properties Pane to change object properties.
  • Use the Code Window to write your procedures.

Discovering Access Objects

  • Understand how to reference the components of the Access application; forms, subforms and controls.
  • Use the DoCmd object to manipulate forms.
  • Browse Access Objects in the Access Object Library.

Working with Methods and Properties

  • Change aspects of objects by correctly assigning Properties.
  • Manipulate the behaviour of objects by correctly assigning Methods

An Introduction to DAO

  • Use the Data Access Object Library to manipulate recordsets.

 

 

Constructing Code

  • Use “If Then”, “If Then Else” and “If Then ElseIf” decision structures in your procedures.
  • Use Variables to hold values to be used by the procedure.
  • Use Select Case statements for complex decision structures.
  • Use For…Next…Loops to execute code repeatedly until conditionally stopped.
  • Use On Error statements to control errors in your code.
  • Step through your code to find bugs.

Using the MsgBox and InputBox Functions

  • Display user messages that respond to user actions.
  • Display user messages to prompt the user for an action e.g. “Yes/No” Message Boxes.
  • Collect user information to which the procedure can respond.

Using the Dlookup Function

  • Use the Dlookup Function to retrieve data from unrelated tables.

Using Standard Modules

  • Use Standard Modules to store standard procedures.
  • Call procedures from Standard Modules.
  • Creating Function Procedures