1300 888 724

8.30am to 5:30pm AEST (Mon-Fri)

Access Visual Basic for Applications Course

(4.83 out of 5) 38 Student Reviews

About the Course

This 3 day course teaches participants to develop programs in VBA for Microsoft Access. A project is undertaken throughout the course to reinforce the concepts . The aim of the project is to put into practice the skills taught during formal sessions, and to foster good coding practices. Special emphasis will be placed on re-usability of code blocks, creation of efficient coding structures and application of standard and consistent VBA coding syntax.

Who should do this course?

This is an advanced level course designed for people who have a thorough working knowledge of Microsoft Access, but need to learn VBA Programming techniques to improve their skills and productivity.

Prerequisites

This course is designed for participants with little or no knowledge of programming, however a sound working knowledge of Microsoft Access is essential, including formatting, reports, queries and relational databases.

Course Details

Course Dates

  • Sydney Class Dates

    Book Now

    Level 11, 32 Walker Street, North Sydney , NSW 2060

    22 - 24 Nov 17 Wed - Fri
    14 - 16 Feb 18 Wed - Fri
    30 Apr - 02 May 18 Mon - Wed
    25 - 27 Jul 18 Wed - Fri
    16 - 18 Oct 18 Tue - Thu
  • Melbourne Class Dates

    Book Now

    Level 12, 379 Collins Street, Melbourne , VIC 3000

    15 - 17 Nov 17 Wed - Fri
    12 - 14 Feb 18 Mon - Wed
    07 - 09 May 18 Mon - Wed
    01 - 03 Aug 18 Wed - Fri
    22 - 24 Oct 18 Mon - Wed
  • Brisbane Class Dates

    Book Now

    Level 6, 371 Queen Street, Brisbane , QLD 4000

    06 - 08 Dec 17 Wed - Fri
    26 - 28 Feb 18 Mon - Wed
    23 - 25 May 18 Wed - Fri
    20 - 22 Aug 18 Mon - Wed
    14 - 16 Nov 18 Wed - Fri
  • Canberra Class Dates

    Level 1, 33 Ainslie Place, Canberra , ACT 2601

    Classes scheduled on demand in Canberra

    Please Join our waitlist and we'll notify you when a new class is scheduled or contact us to disucss your training needs.

  • Adelaide Class Dates

    19 Young Street, Adelaide , SA 5000

    Classes scheduled on demand in Adelaide

    Please Join our waitlist and we'll notify you when a new class is scheduled or contact us to disucss your training needs.

  • Perth Class Dates

    Level 1, 140 St Georges Terrace, Perth , WA 6000

    Classes scheduled on demand in Perth

    Please Join our waitlist and we'll notify you when a new class is scheduled or contact us to disucss your training needs.

Course Units

Expand full topic list

Unit 1: VBA Essentials

See topics

  • Understanding The Programming Environment
  • Exploring The Object Model
  • Navigating With Forms
  • Creating A StartUp Form
  • The VBA Editor Window
  • Working With The Project Explorer
  • Working With The Properties Window
  • Understanding Modules
  • Viewing The Code Behind Forms
  • Standard Code Modules
  • Understanding Naming Conventions

Unit 2: VBA Subroutines

See topics

  • Understanding Modules In Access
  • Understanding Procedures
  • Anatomy Of A Module
  • Creating A Subroutine
  • Creating A Function
  • Calling Procedures
  • Passing Parameters
  • Returning Values
  • Scoping Procedures

Unit 3:Using Variables

See topics

  • Understanding Variables
  • Understanding Data Types
  • Creating And Using Variables
  • Implicit And Explicit Declarations
  • Working With Numbers In VBA
  • Dealing With Overflows
  • Working With Decimals In VBA
  • Working With Dates In VBA
  • Default Values
  • Understanding The Scope Of Variables
  • Procedure Level Scoping
  • Module Level Scoping
  • Passing Variables By Reference
  • Passing Variables By Value

Unit 4: Making Decisions

See topics

  • Understanding The If Statement
  • Creating A Single-Line If Statement
  • Creating A Block If Statement
  • Creating Multiple If Statements
  • Assignment: Creating If Statements
  • Using If For Multiple Text Conditions
  • Understanding The Select Case Statement
  • A Simple Select Case Statement
  • Value Ranges In Select Case Statements
  • Using Select Case Statements With OR

Unit 5: Interacting with users

See topics

  • Understanding Input Boxes
  • Using The InputBox Function
  • Using InputBox Function Arguments
  • Understanding Message Boxes
  • Creating A Simple Message Box
  • Creating A Longer Message
  • Breaking A Message Line
  • Displaying Buttons And Icons
  • Using The Message Box Function
  • Responding To Different Buttons

Unit 6:The DoCmd Object

See topics

  • Understanding DoCmd
  • Navigating With DoCmd
  • Moving Through Records
  • Filtering Records With DoCmd
  • Opening And Closing A Form With DoCmd
  • Opening A Report With DoCmd
  • Creating Variable Reports

Unit 7: Looping in VBA

See topics

  • Understanding Loops
  • Understanding For Loops
  • Creating A While Loop
  • Working With Counters
  • Creating An Until Loop
  • For…Each Loops
  • Exiting From Loops
  • For...Next Loops
  • Assignment: Creating Loops

Unit 8: Debugging VBA

See topics

  • Understanding Debugging
  • Setting A Breakpoint
  • Setting Additional Breakpoints
  • Stepping Through A Procedure
  • Viewing The Call Stack
  • Using Locals And Immediate Windows
  • Adding A Watch

Unit 9 : Form Validation

See topics

  • Data Validation Overview
  • Validating Between Fields
  • Highlighting the Current Field
  • Highlight ALL Required Fields
  • Adding to Combo Boxes using the NotInList Event
  • Value Lists
  • Table/Query Lists (Single Selection in ComboBox)
  • Table/Query Lists (Multiple Columns in ComboBox)
  • Requesting a Change (via Email)

Unit 10: Controlling User Access Level

See topics

  • Retrieving User Roles
  • Using the Allow… Properties
  • Disable / Enabling Controls and Menu Options
  • Using OpenArgs
  • The Tag Property
  • The Form Timer Event

Unit 11: Setting References

See topics

  • Setting References
  • Available References
  • Locating Other Libraries
  • Late Vs. Early Binding
  • Using Outlook – Early Binding
  • Using Outlook – Late Binding

Unit 12: Using an External Reference - File Dialogs

See topics

  • FileDialog Object Members
  • Creating a File Dialog
  • Selecting a Single File Only
  • Creating a File Type Filter
  • Selecting Multiple Files
  • Creating a Generic File Dialog module
  • Defining the File Types (as optional arguments)
  • Storing the returned file path
  • Storing Multiple Values – using an Array
  • Extending the Project

Unit 13: Working with Files and Folders

See topics

  • Features of the Microsoft Scripting Runtime Library
  • Using the FileSystemObject
  • Working with Folders
  • Creating Folders
  • Deleting Folders
  • Checking for Contents of a Folder
  • Consolidating the Create/Delete/Review Routines
  • Copy Folder
  • Move Folder
  • Next Steps
  • Working with Files
  • Adding Files
  • Writing To a Text File
  • Copying and Moving Files
  • Deleting Files

Unit 14: Audit Logging Routines

See topics

  • Capturing User Login/Logout Details
  • User Login Routine
  • User LogOut Routine
  • Logging Form/Report Interaction
  • Logging the Opening Time
  • Logging the Closing Time
  • Retaining Full Data History
  • Further Considerations

Unit 15: Error Handling

See topics

  • VBA Error Handling
  • Error Handling Logic
  • Creating a Standard Error Handling Routine
  • Logging Errors
  • Extending Error Handling
  • Keeping the User Informed of the System State

Unit 16: Code Commenting & Template Creation

See topics

  • Adding Detailed Comments – A Structured Approach
  • Creating a Database Template
  • Importing Objects into the Template DB
  • Exporting Objects as Text Files

Unit 17: Using the Access Developer Tools

See topics

  • Creating a Database Template

Unit 18: Access Recordsets

See topics

  • ADO
  • The Connection Object
  • Command Object
  • RecordSet Object
  • Removing References to SET Variables
  • DAO
  • Creating a DAO Recordset
  • Working with DAO Recordsets
  • Bound Forms & SubForms (Using Queries)
  • Change From Bound To UnBound (Using RecordSets)
  • Creating The Forms RecordSet
  • Completing the Navigational Elements
  • Adding New Records
  • Editing Records
  • Deleting Records
  • Completing The Unbound Form
  • Adding Error Trapping
  • Dealing with Code Duplication

Related Courses:

Course Reviews

(4.90 out of 5) Jarrad V [ 21 August, 2017 ]
Dom's knowledge has been valuable to my understanding. His real world examples and teaching method have been instrumental in making me confident to referring this course to others.
(5.00 out of 5) Michael [ 26 April, 2017 ]
Thoroughly enjoyed the course and learnt alot. I asked Daniel with a current VBA problem from my work and we were able to come up with a solution step by step.
(4.90 out of 5) Andrew L [ 21 March, 2016 ]
Course work was relevant, challenging and engaging. Covered a lot of scope but good focus on key and important features. An enjoyable course with a very knowledgeable and experienced instructor. Thank you for the course.
(4.90 out of 5) KIARASH M [ 28 May, 2015 ]
Very nice work by Daniel - I learned a lot of programming techniques as well as how to strategize my work

Enquire Now

Fill in your details to have a training consultant contact you to discuss your training needs.

Your details

Other Ways To Get In Touch

You can also Book Online or call us on 1300 888 724

Back to Top