Tailored Courses for IT and Business Professionals

Professional Database Development using Microsoft Access

The copyright on these mind maps has been protected. However we are very happy to provide unprotected versions to anyone who sends an email, stating their reason for interest.

Objectives

This course provides a professional level introduction to programming MS Access databases.

Duration

Two Days

Delegates will learn ...

  • Macros, Modules and VBA
  • VBA Variables
  • VBA Code Structures
  • Working with VBA Objects
  • The Microsoft Access Object Model
  • Interacting with other datasources
  • Debugging

Who Should Attend

Delegates should be professional developers or advanced users of MS Access, or delegates who have completed the Bindon.net "Power User" course.

Prerequisites

Bindon.net MS Access Power User course or equivalent.

Topics covered

Some examples of where we're heading

  • Use of VBA code to build advanced MS Access Database solutions

Macros, Modules and VBA

  • The Limited occasions when you need to use MS Access "Macros"
  • Form and Report Modules
  • Event, Sub and Function Procedures
  • Stand-alone modules
  • Global settings and functions
  • Referencing "Objects" in code
  • Expression Builder

VBA Variables

  • Datatypes - types of data
  • Why use "Option Explicit"?
  • "Scope" of variables - Dim, Public and Private
  • Variants
  • Object Variables - use "Set"
  • Arrays, Lists, Collections and Stacks

VBA Code Structures

  • Code units
  • Loops
  • Conditional structures
  • "Error" or "Exception" Handling

Working with VBA Objects

  • Properties, Methods and Events
  • The Ordering of Events
  • Object Hierarchies
  • Collections of Objects
  • Interacting with Collections
  • Collections are Objects
  • For Each and With

The Microsoft Access Object Model

  • Form Properties, Methods and Events
  • Control Properties, Methods and Events
  • Report Properties, Methods and Events
  • Programatic control of Data Access

Interacting with other datasources

  • Linking
  • Relinking
  • Automating Importing and Exporting
  • Interacting with Web Services form MS Access

Debugging

  • Types of "errors"
  • Runtime, designtime and breakmode
  • Windows to control debugging
  • Setting break points
  • Using the debugging tools
  • The "Immediate" window
  • Coding for easier debugging
  • Situations that are difficult to debug