This 2-day instructor led course is for advanced Access VBA students.
Students will work with Data, Create Schema, Data Manipulation, Other Data files and Other Applications
With Microsoft Access VBA you will learn Visual Basic for Applications (VBA). VBA is a superset of the Visual Basic command syntax and a rich assortment of functions with the capability to control objects in your application.
With the information provided you will explore commands, functions, properties, and methods and how to use them.
You will learn the two main ways to get at data: Data Access Objects (DAO) and ActiveX Data Objects (ADO). You will learn object models as they apply to the Access Connectivity Engine (ACE), the database engine under the hood of Access. You will learn advanced topics of database analysis, such as retrieving a list of all relationships in your database or discovering all the computers that are connected to your database.