Etopia Computer Training
IT Computer Training Experts
Discounts of 25% & Tailored from £295!
25% Off Microsoft Application Courses!

Upcoming Courses

Call for any late availability offers on these upcoming courses.

Training Room Hire

Our Glasgow training room facilities are available for hire.

Microsoft Access VBA

Duration:2 days
Price:£550.00
Locations:Glasgow, Edinburgh
Glasgow Dates:Thu 9th Feb 12,  Tue 10th Apr 12,  Thu 28th Jun 12,  Mon 6th Aug 12
Edinburgh Dates:Thu 9th Feb 12,  Tue 10th Apr 12,  Thu 28th Jun 12,  Mon 6th Aug 12

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 otherfeatures available such as tables, queries, forms, reports, macros and relationships.

Notes

Training is available on all versions