Access 2016: VBA Programming Training
Course Length: 1 day
Delivery Methods:
Available as private class only
Course Overview
This VBA Programming for Access 2016 training course is designed for experienced Access users who want to learn ActiveX Data Objects, control structures, and the basics of VBA programming.
Course Benefits
- Learn to use VBA within Microsoft Access.
Microsoft Certified Partner
Webucator is a Microsoft Certified Partner for Learning Solutions (CPLS). Our curriculum has been tested and approved by ProCert Labs, the official tester of Microsoft courseware, and has been found to meet the highest industry standards of instructional quality.
Course Outline
- Visual Basic Editor
- Visual Basic for Applications
- Using the Visual Basic Editor
- The Visual Basic Interface
- Working in Visual Basic Editor
- Using the Visual Basic Editor in Access
- Close Event Procedure
- Save and Run a Procedure
- Object Programming
- The Object Model
- Getting Help in the Object Browser
- Event Procedures and Macros
- Using the Object Model in Access
- The Access Object Model
- Programming Basics
- Data Basics
- Scope of Variables
- Naming Variables
- Using Variables to Accept User Input
- Control Structures
- Decision Structures
- Loop Structures
- Custom Dialog Boxes
- User Forms
- Events
- Debugging and Error Handling
- Errors
- Debugging
- Error Handling
Class Materials
Each student will receive a comprehensive set of materials, including course notes and all the class examples.
Class Prerequisites
Experience in the following is required for this VBA class:
- Expertise in Microsoft Access