UMSL logo

Computer Education & Training Center

Access VBA

Access VBA (Visual Basic for Applications)

Master skills in programming using Access Visual Basic for Applications (VBA) by taking an instructor-led class at the Computer Education & Training Center at UMSL.

Programming Applications of Access: Level 1

(Prerequisite: Intermediate Applications of Access and Introduction to Programming Concepts or equivalent experience.) Increase the speed and efficiency of your databases and create customized applications through Access VBA (Visual Basic for Applications). Learn the basics of using Access VBA to automate your database application which can potentially reduce your database size, lessen memory usage, and make using the database more efficient and user-friendly. Topics include an introduction to events and understanding the difference between the various programming modules to help in deciding where to write your VBA code. Additional topics include the use of variables and constants, how to programmatically open forms reports, queries, built-in functions such as the Nz function, the difference between subprocedures and functions, basic error trapping, and filtering the forms and reports opened by your VBA code. The use of an Option Group properties is also discussed. [Course Outline]
Fee: $399

Two-Day Class Meets 8:30am-4:00pm (13 hours)
Code Dates Location Instructor
E8265 Wed., Oct. 4 & Thurs., Oct. 5West CountyFrank Richey

Programming Applications of Access: Level 2

(Prerequisite: Programming Applications of Access: Level 1 or equivalent experience.) Build on your knowledge of Access programming using more advanced VBA programming code. Learn how to use ActiveX Data Objects (ADO) coding techniques and Recordset objects to work with your data. Develop error-free applications using formal error-trapping techniques to trap, collect, and respond to errors. Additional topics include using loops to repeat operations and programming your applications using ActiveX controls. [Course Outline]
Fee: $399

Two-Day Class Meets 8:30am-4:00pm (13 hours)
Code Dates Location Instructor
E8266 Thurs., Oct. 19 & Fri., Oct. 20West CountyFrank Richey

Programming Applications of Access: Level 3

(Prerequisite: Programming Applications of Access: Level 2 or equivalent experience.) Learn to code more efficiently, expand your knowledge of VBA ADO coding techniques using recordsets, and save time and effort through automation. Understand how to use recordsets to modify record data record-by-record, as well as make bulk record changes, create and delete objects using code, and establish relationships between objects using VBA code. Examine useful application optimization techniques, such as variable arrays, connection objects, and constants. Other topics include importing data from an external database, text file, or Excel spreadsheet and automating by creating and controlling Excel and Outlook from an Access database. [Course Outline]
Fee: $399

Two-Day Class Meets 8:30am-4:00pm (13 hours)
Code Dates Location Instructor
E8267 Wed., Nov. 1 & Thurs., Nov. 2West CountyFrank Richey

If you would like to register for a course, call (314) 984-9000 or register online.

We also have classes on the Access Database covering basic topics as well as more advanced applications in macros and design.