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 Visual Basic for Applications (VBA). Learn the basics of using Access VBA to automate your database application which can potentially reduce your database size saving disk space, lessen memory usage, make the database application run more efficiently, and make the database more 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: $379

Two-Day Class Meets 8:30am-4:00pm (13 hours)
Code Dates Location Instructor
G5597 Mon., Nov. 24 & Tues., Nov. 25West 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: $379

Two-Day Class Meets 8:30am-4:00pm (13 hours)
Code Dates Location Instructor
G5598 Mon., Dec. 8 & Tues., Dec. 9West CountyFrank Richey

Programming Applications of Access: Level 3

(Prerequisite: Programming Applications of Access: Level 2 or equivalent experience.) Learn how to make your code more efficient, expand your knowledge of VBA ADO coding techniques using recordsets, and save time and effort through automation. Learn 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: $379

Two-Day Class Meets 8:30am-4:00pm (13 hours)
Code Dates Location Instructor
G5397 Thurs., Oct. 9 & Fri., Oct. 10West CountyFrank Richey
G5599 Mon., Dec. 15 & Tues., Dec. 16West 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.