Follow Us :

Access 2003 VBA

Course_Reference: 
DAC03VBA
Summary: 

This two day course will teach delegates how to use Microsoft Access 2003. The course provides in-depth, hands on training with a focus on real-world application.

PreRequisites: 

 

  • Understand, create and modify table relationships
  • Create left and right query joins
  • Create and modify tables, forms, reports and queries
  • Modify table, form, report and query properties
  • Create advanced parameter queries
  • Use the controls on the toolbox
  • Write basic formulas
  • Format forms and reports
  • Sort and filter data

 

Module 1

 

  • Getting Started
  • Introduction to Programming in Access
  • Why Program in Access?
  • Understanding the Development Environment
  • Using Visual Basic Help

 

Module 2

 

  • Working with Procedures and Functions
  • Understanding Modules
  • Creating a Standard Module
  • Understanding Procedures
  • Creating a Sub Procedure
  • Calling Procedures
  • Using the Immediate Window to Call Procedures
  • Creating a Function Procedure
  • Naming Procedures
  • Organizing Code and Procedures
  • Working with the Code Editor

 

Module 3

 

  • Understanding Objects
  • Understanding Classes and Objects
  • Navigating the Access Object Hierarchy
  • Understanding Collections
  • Using the Object Browser
  • Working with the Application Object
  • Understanding the Form Object
  • Working with Properties
  • Using the With Statement
  • Working with Methods
  • Understanding the DoCmd Object
  • Working with Events
  • Understanding the Order of Events

 

Module 4

 

  • Using Expressions, Variables, and Intrinsic Functions
  • Understanding Expressions and Statements
  • Declaring Variables
  • Understanding Data Types
  • Working with Variable Scope
  • Working with Variable Lifetime
  • Considering Variable Scope and Lifetime Together
  • Using Intrinsic Functions
  • Understanding Constants
  • Using Intrinsic Constants
  • Using Message Boxes
  • Using Input Boxes

 

Module 5

 

  • Controlling Program Execution
  • Understanding Control-of-Flow Structures
  • Working with Boolean Expressions
  • Using the If…End If Decision Structures
  • Using the Select Case…End Select Structure
  • Using the For…Next Structure
  • Using the For Each…Next Structure
  • Using the Do…Loop Structure
  • Guidelines for use of Branching Structures

 

Module 6

 

  • Working with Recordsets
  • Declaring and Creating Object Variables
  • Working with the ADODB Recordset Object
  • Specifying a Recordset Cursor Type
  • Locking Records for Updating
  • Specifying a Recordset Cursor Location - Optional
  • Using the CacheSize Property - Optional
  • Understanding Recordset Cursor Properties - Optional

 

Module 7

 

  • Debugging Code
  • Understanding Errors
  • Using Debugging Tools
  • Setting Breakpoints
  • Setting Break Expressions
  • Using Break Mode during Run Mode
  • Stepping through Code
  • Determining the Value of Expressions

 

Module 8

 

  • Handling Errors
  • Understanding Error Handling
  • Understanding VBA\\\'s Error Trapping Options
  • Trapping Errors with the On Error Statement
  • Understanding the Err Object
  • Writing an Error-Handling Routine
  • Working with Inline Error Handling

 

Description: 

This two day course will teach delegates how to use Microsoft Access 2003. The course provides in-depth, hands on training with a focus on real-world application.

Keywords: 
Microsoft Access, Access 03, Microsoft Office 2003

Software Vendor

IT Technical

Business Skills