VBA Training - Access VBA

Duration

2 days

Objectives

Enable delegates to start developing Access-based applications, using VBA:

  • Familiarise with the VBA Editor and environment
  • Learn to write code in the VBA language
  • Explore the Access object model and the Access and ADODB VBA libraries.

Prerequisites

Delegates should have experience of using Access to a good intermediate level, being able to create/modify Tables, Queries and Forms using the respective Design Views. Delegates should have basic familiarity with SQL for Queries.

Topics

  • Introduction: Why VBA?
     
  • The VBA Editor
    • Project Explorer
    • Code Window
    • Immediate Window
    • Object Libraries & the Object Browser
    • A First Procedure
    • Getting Code from Elsewhere
       
  • VBA Code
    • More on Variables & Types
    • Control constructs: conditionals, loops
    • Procedures: subs and functions
    • Comments, etc.
       
  • Debugging
    • Setting breakpoints
    • Debug Mode
    • Locals and Watch windows
       
  • Exploring the Access object model
    • Collections and object references
    • Application, Form, Report
       
  • Programming Access Forms
    • Form Properties
    • Object Structures
    • Form and Control Events
    • Controlling Controls
       
  • Error Handling
     
  • Custom Functions
    • A change-case function
       
  • SQL & Recordsets
    • Action Queries: update using custom function
    • Select Queries
    • ADODB library: Connections and Recordsets
    • Using Recordsets: merge data, interactive update
       
  • Integrating with other Office Applications
    • Object Library References
    • Pass Data Values between Access and Excel
[Roy MacLean - IT] [VBA Training - Introduction to VBA] [VBA Training - Excel VBA] [VBA Training - Access VBA] [VBA Training - Word VBA] [VBA Training - Advanced VBA] [VBA Training - Excel Access Integration] [MS Office Training - Excel Advanced] [DITA Training - Introduction]