This course runs for a duration of 3 Days.
The class will run daily from 9:00 AM CST to 3:45 PM CST.
Class Location: Virtual LIVE Instructor Led - Virtual Live Classroom.
Overview
Students learn the Visual Basic for Applications language as well as the Access classes and objects needed to create VBA scripts to automate Access. Participants create procedures and functions using the VBA language and Access objects. As well, debugging and error handling techniques are reviewed.
This class is appropriate for users of Access 2013, 2016, 2019, or 365.
Getting Started
Working with Procedures and Functions
Understanding Objects
Using Expressions, Variables, and Intrinsic Functions
Controlling Program Execution
Working with Recordsets
Debugging Code
Handling Errors
Appendix - Working with the ADO Recordset Object