Skip to Content

Booking Enquiries: 0800 077 36 46 Customer Services: 0800 077 36 24

Microsoft Access Developer Course – VBA in Access Part 1 – Automation

Microsoft Access Developer Course – VBA in Access Part 1 – Automation

Microsoft Access Developer Course – VBA in Access Part 1 – Automation

Price: £480.00+VAT
Duration: 2 Days
Location:Crawley
Date(s):
Print

Is this course right for me?

Our VBA in Access Part 1 – Automation course is designed for existing experienced users of Access who need to use VBA to automate their databases.

Delegates must be able to confidently create fully relational databases including tables, forms, reports and queries before attending this course. Previous programming experience would be an advantage.

Training course objectives:

  • Write your own code for use on command buttons, forms and reports
  • Set up user messages
  • Use the debug tools
  • Write error handling routines and edit Access error messages
  • Write your own functions, e.g. conversion functions, date functions

Versions Available

2003, 2007, 2010

Related Training Courses in Our Range

Objects/properties/events/methods

  • Different events
  • Form events
  • Control events
  • Report events
  • Attaching code

The Visual Basic environment

  • Steps to creating a VBA procedure
  • Class modules
  • Procedures
  • Adding command buttons

Object properties

  • Object properties
  • Setting properties at design time
  • Setting properties at run time
  • Using WITH

Event procedures

  • Writing event procedures
  • Code structure
  • Adding comments

Setting keyboard events

  • Using KeyUp and KeyDown events

Statements and functions

  • Writing statements and functions
  • Input boxes
  • Message boxes

Variables

  • Creating variables
  • Naming conventions
  • Data types
  • Declaring more than one variable
  • Concatenation
  • Scope of variables

Constants

  • Declaring and using constants
  • Scope of constants

Debugging

  • Errors
  • Compiling
  • Setting breakpoints
  • Working in break mode
  • Debug tools

VB error handling

  • Writing error handling routines

Access error handling

  • Replacing standard error message

Conditional statements

  • IF statement
  • SELECT CASE statement
  • Tests

General procedures

  • Scope of procedures
  • Calling procedures
  • Sub procedures
  • Standard modules

Function procedures

  • Creating functions
  • Parameters or arguments
  • Optional arguments
  • Default values