Font size:


Getting Started

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

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

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

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

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

Working with Recordsets

  • Declaring and Creating Object Variables
  • Working with the DAO Recordset Object

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

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


Lesson 1: Getting Started

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

Lesson 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

Lesson 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

Lesson 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

Lesson 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

Lesson 6: Working with Recordsets

    Declaring and Creating Object Variables
    Working with the DAO Recordset Object

Lesson 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

Lesson 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

Find a class and register in three easy steps:
  • 1. Select Location:
  • 2. Select Date Range:
    to
  • 3. Select Class Type:
    • All Types
    • C Classroom
    • V Virtual Live
    • Cv In-Class Virtual
    • O Online
Virtual Live11/27/2017 9:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>3 days990.001885191
IA Urbandale11/27/2017 9:00:00 AM<span class="course-type type-cv" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'HVILT')" onmouseout="clearHoverInfo()">Cv</span>3 days990.002011144
Virtual Live12/27/2017 8:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>3 days990.001885192
TN Nashville12/27/2017 8:00:00 AM<span class="course-type type-cv" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'HVILT')" onmouseout="clearHoverInfo()">Cv</span>3 days990.002011068
seek-warrow-w
  • 1
arrow-eseek-eitems per page1 - 4 of 4 items