Etopia Computer Training

Training Room Hire

Our Glasgow training room facilities are available for hire.

Microsoft Access VBA Programming IT Training Course

Duration:2 days
Price:£550.00
Locations:Glasgow, Edinburgh
Glasgow Dates:Wed 21st Feb 18,  Wed 21st Mar 18,  Mon 23rd Apr 18,  Wed 23rd May 18,  Fri 20th Jul 18
Edinburgh Dates:

Dates above and cost (excludes VAT) are for joining a scheduled course.

 Or book a Two Day Private Group from £1195 + VAT or book 1-to-1 from £450 + VAT for One Day Overview  £900 + VAT for two days 1-to-1. 

Two Day Course

This course teaches experienced Access users about the greater advantages to be gained by
combining the built-in features of Access with the programming capabilities of Visual Basic for
Applications (VBA). The course is designed to give delegates a thorough overview of programming
within the Access environment, enabling them to improve the functionality of their Access
databases, whilst providing a useful introduction to VB programming.

Course Aims to enable delegates to:

Work with objects, use the Object Browser, identify collection objects, and use the Controls
collection. Manipulate data by declaring variables, combine data by using expressions, get user
input, create Sub and Function procedures, and call one procedure from another. Use decision
structures and loop structures. Identify compile-time, run-time, and logical errors; use the debugging
tools; and write error-handling code.

Course Content

Create powerful applications

  • Objects, Properties and Methods
  • Synchronising Forms
  • Storing Return Values

Learn basic programming structures

  • Working with Modules
  • Creating Sub Procedures
  • Calling Sub Procedures

Work with conditional statements and loops

  • The If Statement
  • The Do Command
  • Looping

Create custom message boxes

  • Evaluating a Message box
  • Responding to User Selections

Create Custom functions

  • Using Built-in Functions
  • Creating Custom Functions
  • Calling Function Procedures

Interact with Excel or Word

  • Opening Other Applications
  • Destroying Object Variables
  • Adding Data

Write error-handling code

  • Stepping Through Code
  • Using the Intermediate Window
  • Setting a Watch on a Variable

Validating User Input

  • Checking for Null Values
  • Offering Choices

Follow-on Courses

Microsoft Excel VBA

Requirements before booking this course:

This is a generic course and is suitable for users of any version of Microsoft Access. This course isparticularly beneficial for those with a sound knowledge of Access who are familiar with other features available such as tables, queries, forms, reports, macros and relationships.

Notes

Training is available on all versions