Access Programming

 Email this information to yourself or a friend

 Remind me of this course at a later date

Official Program Description

Access Basic Programming

jump to schedules and register button

Learn how to create powerful applications using Access. You will explore programming constructs such as objects, arrays, functions, and debugging.

Who Should Attend

This class is geared towards experienced Access users who are interested in programming with the Visual Basic language.


Appropriate introductory and advanced courses plus several weeks of practice. No programming experience is required.

Attend and You Will Learn

Getting Started Functions

  • Introduction to programming in Access
  • Why program in Access?
  • Creating a macro
  • Understanding modules
  • Creating a standard module
  • Understanding the development environment
  • Using the Project Explorer
  • Using the Properties Window
  • Using the Code Window

 Working with Procedures and Functions

  • Understanding procedures
  • Creating a sub procedure
  • Creating a function procedure
  • Calling procedures and function
  • Working with code

Objects, Properties, Methods and Events

  • Understanding objects and collections
  • Understanding properties
  • Understanding methods
  • Understanding events

Understanding the Access Object Hierarchy

  • Understanding access objects
  • Using the object browser
  • Controlling the application object
  • Understanding the forms collection and form object
  • Understanding the controls collection and control object
  • Using the "with" statement
  • Understanding the reports collection and report object
  • Understanding the DoCmd object
  • Using the screen object

Using Variables, Arrays and Constants

  • Declaring variables
  • Declaring arrays
  • Declaring constants
  • Declaring object variables

Using Functions, Message Boxes and Input Boxes

  • Using intrinsic functions
  • Using message boxes
  • Using input boxes

Controlling Program Execution

  • Using control structures
  • Working with conditional expressions
  • Using the If...Then...End If structure
  • Using the If...Then...Else...End If structure
  • Using the select case...End select structure
  • Using the Do...Loop structure
  • Using the For...Next structure

Debugging Code

  • Understanding errors
  • Using debugging tools
  • Stepping through code and setting break points
  • Understanding error events
  • Understanding the err object
  • Using the On Error statement
  • Writing an Error handling routine
  • Compiling all procedures


  Access Programming
  2016 - TTS - Sep - Dec 2015   Status:  Available
In-Class:   Wed, Thu 9:00AM - 4:30PM
16 Dec 2015 to 17 Dec 2015
Class Schedule: 2 Sessions
Contact Hours: 12.0
Course Fee(s):
Gov't & Non-Profit Registration Fee non-credit    $349.00
Registration Fee non-credit    $449.00
Potential Discount(s):
  1.20 CEUs
Location:   On Campus