Go to the Home Page

Microsoft® Access Stage Five

Versions 2002 and 2003

Training
Access 2007 and 2010 (NEW!)

Skill Assessments (2007 or 2010)

Access 2002 and 2003

Skill Assessments (2002 or 2003)

Related Web Sites

Course Objectives:
The aim of this course is to provide participants with the skills necessary to program in Access using the language Visual Basic for Applications.  This course is an introduction to programming, and contains numerous hands-on exercises to automate Access and develop a professional database.

Who Should Attend:
Participants of this course must be completely conversant with the material covered in the Access Stage One, Access Stage Two, Access Stage Three and Access Stage Four Course Outlines.

Course Outline/Table of Contents:

  • Working With The Visual Basic Editor

  • Sub Procedures Or Subroutines

  • Commenting Your Code

  • Creating Many Form Event Procedures

  • Message Box Function and Settings

  • Working with and Declaring Variable Data Types

  • If...Then…Else Statements

  • Converting Data Types

  • General And Standard Procedures

  • Exiting Sub Procedures

  • Select Case Statement

  • Function Procedures

  • Debugging including Debug Toolbar, Breakpoints, Immediate Window, Watch Window and Locals Window

  • Adding Constants

  • Data Scope And Survival including Scope Of A Variable and Survival Of A Variable

  • Do...Loop Statement

  • For...Next Statement

  • With .. End With Statement

  • String Function Reference

  • Filtering And Finding Procedures, Setting Values and Custom Validation Procedures

  • Error Handling including Identifying The Error And Creating Custom Error Response, On Error Goto Statements and Error Codes

  • Microsoft Access Objects And Dao Data Access Objects

  • The Dao Hierarchy

  • Navigating Recordsets including Moving From Record To Record and Finding A Record In A Recordset and Editing Data In Recordsets

  • Using Object Browser And Object Model

Duration: Three or more people two full 6 hour courses will be necessary. One or two people will need 6 two hour sessions.

Copyright                     Disclaimer