Course Code: 1017

Access Programming in VBA

Class Dates:
3 Days
Class Time:
Office, Database


  • Course Overview
  • This instructor-led course looks at the critical aspects of application development using Microsoft Access. You'll dig deep into forms, tables, queries, and reports, and explore modules as you learn to use Visual Basic for Applications (VBA). You'll learn how to programmatically display and manipulate data on forms and reports. What is Access VBA

    VBA stands for Visual Basic for Applications. Visual Basic is, by far, the most widely used programming language in the world. It has been estimated that Visual Basic programmers outnumber every other programmer added together! VBA is no different from regular Visual Basic except that it can only be used to add features to Microsoft Office applications (such as Access, Excel, PowerPoint, Word, Project and Visio) rather than to write free-standing applications.

  • Audience
  • To get the most out of Programming in Microsoft Access, you should understand how to create and use all the interactive Access objects: Tables, queries, forms, and reports. You should have taken Access Level 1, Level 2 and Level 3 or the associated knowledge. Programming experience in any language is helpful, but not required. Access 2010 Level 1: Introduction to Microsoft Access Access 2010 Level 2: Intermediate Topics Access 2010 Level 3: Advanced Topics.
    Much of what you learn in our VBA course will also be relevant to writing custom VBA extensions to other office applications too.

    If you are an Expert-level Access user and still can't make Access do what you need then this course is definitely for you.

    If you want to develop robust, professional and polished Access applications for re-sale this course will show you how.


Course Details

  • Advantages of Access and VBA
  • Understanding Where Access fits in Office
  • Understanding Access Programming Choices
  • Macros
  • Using SQL
  • Using VBA
  • Using the Visual Basic Editor
  • First Look at the Visual Basic Editor
  • Explaining VBA Modules
  • Entering and Running Code, Debugging Code, Saving Code
  • Getting Help on Code, Coding Shortcuts
  • Good Coding habits
  • Using a naming Convention
  • Indenting
  • Documenting
  • Using Variables, Constants, and Data Types
  • Declaring Variables and Constants
  • VBA Data Types
  • Referencing Syntax
  • Case Study: Using Form References
  • Using Built-In Functions
  • What Are Functions?
  • Converting Data Types
  • Working with Date Functions
  • Using Mathematical Functions
  • Using Financial Functions
  • Manipulating Text String
  • Formating Values
  • Domain Aggregate Functions
  • Using the Is Fnctions
  • Interation
  • Case Study: Add Work Days
  • Building Procedures
  • Types of Procedures
  • Passing Arguments
  • Error Handling
  • Conditional and Looping Statements
  • Introduction Flow of control Statements
  • Using If ... Then...Else
  • Using Select Case
  • Using For...Net
  • Using Do Loops
  • Using GoTo
  • Case Study: Calculating Bonuses
  • Working with Arrays
  • Introduction Arrays
  • Declaring a Fixed-Size Array
  • Understanding an Array's Indexx
  • Working with Array Elements
  • Arrays with Multiple Dimensions
  • Expanding to Dynamic Arrays
  • Object and event-Driven Coding
  • Understanding Objects
  • Invoking Methods
  • Using Collections
  • Working with an Object Model
  • Creating Objects
  • Working with Events
  • Understanding Scope and Lifetime
  • Scope Explained
  • Procedure-Level Variables
  • Module-Level Variables and Constants
  • Public Variables and Constants
  • Measuring the Lifetime of a Variable or Constant
  • Using Static Variables
  • Case Study: Tracking the Current User
  • Working with Forms
  • Opening and Closing Forms
  • The Form Module
  • Form and Control Properties
  • Form Events
  • Case Study: Adding to a Combo Box
  • More on Event-Driven Coding
  • Responding to Events
  • The Event Sequence for Controls
  • Focus Evetns, Data Events, Control Specific Events
  • The Event Sequence for Forms
  • Navigation Events
  • Canceling Events
  • Case Study: Validating Data
  • Working with Selection Controls
  • Selection Controls
  • Populating a List Control
  • Adding to the List - Or Not
  • Updating a Table/Quer List
  • Working with Option Groups
  • Working with MultiSelect Controls
  • Case Study: Selecting Multiple Items
  • Working with Other Controls
  • Working with Text Boxes
  • Key Properties of Text Boxes
  • Tracking the Focus
  • Working with Check Boxes, Radio Buttons, or Toggle Buttons
  • Working with Subforms
  • Working with the Tag Property
  • Case Study: An Audit Trail
  • Working with Reports
  • An Introduction to the Report Module and Events
  • Opening and Closing Reports
  • Passing Argument Using OpenArgs
  • Populating the Report
  • Handling Report -Level Errors
  • Working with Subreports
  • Case-Study: Product Catalog