VBA Programming with Access

VBA Programming with Access

Duration:
2 Days
Aims:

This course would benefit advanced users of Microsoft Access responsible for managing very large and variable amounts of data, or teams, who want to learn how to program features and functions to improve the accessibility and usability of their data.

Objectives:

On completion of this course, delegates will understand the fundamentals of VBA, including working with procedures and functions, understanding objects, using expressions, variables and intrinsic functions. They will have mastered how to control program execution, working with forms and controls, working with the PivotTable object. Finally the course also includes modules on debugging code, handling errors to ensure minimal downtime while building the program.

Pre-Requistites

A high proficiency of Microsoft Access is essential, or completion of our Microsoft Access Advanced course.

Versions

Courses are delivered in 2007, 2010, 2013, 2016.

What will I learn?
Getting Started
  • - Introduction to Access programming
  • - Understanding the development environment
Developing with Procedures and Functions
  • - Understanding and creating modules
  • - Defining procedures
  • - Creating a sub-procedure
  • - Calling procedures
  • - Utilising the immediate window to call procedures
  • - Making and naming a function procedure
  • - Working using 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
Utilising Intrinsic Functions, Variables and Expressions
  • - Defining expressions and statements
  • - How to declare variables
  • - Determining data types
  • - Programming with variable scope
  • - Harnessing intrinsic functions
  • - Defining constants and using intrinsic constants
  • - Adding message boxes and using input boxes
  • - How to declare and use object variables
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 ADODB recordset object
  • - Specifying a recordset cursor type
  • - Locking records for updating
  • - Specifying a recordset cursor location – optional
  • - Using the cache size property – optional
  • - Understanding recordset cursor properties - optional
Debugging the Code
  • - Defining errors
  • - Working with debugging tools
  • - Determining breakpoints
  • - How to step through code
  • - Working with break mode during run mode
  • - Identifying the value of expressions
Handling Errors
  • - Understanding error handling
  • - Understanding VBA's error trapping options
  • - Trapping errors with the on error statement
  • - Understanding the error object
  • - Writing an error handling routine
  • - Working with inline error handling
Related courses
Run this
course at
your offices
Request a quote
Speak to a friendly advisor

call

0333 344 6630

or visit our

Online Chat
Trustpilot