Microsoft Access Programming With VBA

In Access VBA you will learn how to extend the functionality of Access using a programming language called Visual Basic for Applications (VBA). With VBA you can create code which will allow you to automate the functionality of your database.

You will learn how to use the individual elements of this powerful programming language in order to design, develop and run VBA code. This 3 day course allows students a hands-on approach to visual basics. This course covers the 2013, 2010, and 2007 versions.

Course Objectives:

• Understand the VBA development environment
• Create modules, sub procedures, and function procedures
• Work with objects, properties, methods, and events
• Learn about the Access object hierachy
• Understand variables and constants
• Work with expressions and statements
• Use intrinsic functions
• Work with control-of-flow structures
• Work with the Recordset object
• Understand errors and debug code
• Trap and handle errors in code