MS Access VBA

Duration: One Day

Interested in this course?

Complete the form and let us know your preferred training date. Our team will contact you to discuss your requirements and arrange a suitable course schedule.

Whether you're booking for yourself or a team, we'll work with you to find a convenient training date.

Prefer to get in touch directly? You can also email us at forrest@forresttraining.com.au, and we'll be happy to assist you.

    Target Audience & Purpose

    Access VBA is for highly skilled developers who wish to add high-end automation.

    Objectives

    By the end of this course participants should be able to:

    • Create and assign macros
    • Understand the advantages and disadvantages of using macros
    • Use forms and modules in the VBA editor
    • Create and work with subroutines and functions
    • Create and work with variables
    • Communicate with the user through input boxes and message boxes
    • Program decision structures using IF and CASE statements
    • Develop a variety of programming loops for repeating operations
    • Use the DoCmd object
    • Use ADO to handle working with data in your programs
    • Use the debugging features of VBA to locate and identify errors
    • Develop error-handling routines to prevent errors.

    Course Inclusions

    • Comprehensive learning materials incl. exercise files
    • Post course telephone support
    • ‘Certificate of Attendance’ on completion of course
    • Morning & afternoon tea

    Course Prerequisites

    This course assumes a sound knowledge of the standard features of Access covered in the Introduction and Advanced courses.

    MS Access VBA Course Content

    Download Exercise Files

    Development Basics
    The Access Development, Environment, The Importance Of Splitting, Databases, Maintaining Links, Using The Database Splitter, Using Queries For Reports And, Forms, Access Run-Time, Understanding Client/Server

    Macros & VBA
    Macro Overview, Creating Macros, Assigning Macros, Creating More Complex Macros, Converting Macros To VBA Code, Why You Shouldn’t Use Macros

    VBA Essentials
    Programming Environment, Overview, The Role Of Forms, Creating A Startup Form, Understanding Modules, Code Behind Forms, Standard Code Modules, Standard Vs Class Modules, Naming Conventions

    VBA Subroutines
    Understanding Modules In Access, The Anatomy Of A Module, Creating A Subroutine, Creating A Function, Calling Procedures, Passing Parameters, Returning Values, Scoping Procedures

    Variable VBA
    Overview Of Variables, Creating String Variables, Option Explicit, Working With Numbers, Dealing With Overflows, Working With Decimals, Working With Dates, Default Values, Scoping Variables, Local Variables, Module-Wide Variables, Passing Parameters, Passing Parameters By Value

    Interactive VBA
    The Act Of Communicating, Creating A Simple Input Box, Creating More Elaborate Input, Boxes, Global Positioning, Simple Message Boxes, Creating Larger Messages, Breaking A Message Line, Customising Icons And Buttons, Message Box Functions, Responding To Different Buttons

    Decisive VBA
    Decisions Overview, Creating An In-Line If, Creating A Block If, Multiple If, Multiple If Using Text, Using Case Statements, Value Ranges In Case Statements, Case Statements With OR, Asking Yes/No Questions

    Looping VBA
    Program Loops, Creating A While Loop, Taking Care Of Counters, Creating An Until Loop, For Each Loops, Exiting From Loops, For Next Loops

    The DoCmd Object
    Overview Of DoCmd, Navigating With DoCmd, Moving Through Records, Filtering Records With DoCmd, Opening A Form With DoCmd, Opening A Report With DoCmd, Closing A Form, Creating Variable Reports

    ActiveX Data Objects – Tables
    ADO Overview, Setting References Using VBA, Create and Remove a Table with ADO, Populate a Form using ADO, Dealing with an Empty Table

    ADO Forms & Recordsets
    Overview of ADO With Forms & Recordsets, Navigating Records in a Form, Adding, Finding, Updating and Deleting a Record

    Debugging VBA
    Debugging Overview, Setting A BreakPoint, Setting Additional Breakpoints, Stepping Through A Procedure, Viewing The Call Stack, Using The Locals And Immediate, Windows, Adding A Watch, Deleting A Watch

    Handling Errors In VBA
    Error Handling Overview, Understanding Common Errors, Creating A Simple Error Handler, Understanding The Error Object, Model, More Elegant Error Handling, Resuming From Errors, Forcing An Error, Creating Custom Errors