VBA for Access

Return to scheduleregister-button24

Course Title VBA for Access
Course Number 900-076-EQ
Platform Microsoft Windows
Duration 20 hours
Gouvernement du Québec fee (taxes incl.)
General Public fee (taxes incl.)
Schedule Tuesday 6:00 p.m. to 10:00 p.m.
Prerequisites SQL Beginner and Basic knowledge of database management system
Target Audience Visual Basic for Applications (VBA) is a powerful tool that enables you to automate tasks in Microsoft Office applications. This training course is intended for those who want to learn VBA programming concepts using simple Access databases, and teaches you how to use VBA to automate your work in Microsoft Office Access 2016 applications.
Instructor Khattar Daou
Location Brittain Hall / BH-214

Please note that this is a non-credit course.

Required text: Mastering VBA for Microsoft Office 2016 | Richard Mansfield | ISBN: 978-1-119-22538-6 | Copyright © 2016 by John Wiley & Sons, Inc.


Topics Covered in this Course:

Module 1: Microsoft Access Essentials
 Unit 1: Introduction to VBA
 Unit 2: VBA Conditions
 Unit 3: VBA Looping Structures
 Unit 4: VBA Functions

Module 2: Code Reuse and Data Structures
 Unit 1: User-Defined Functions
 Unit 2: Code Reuse and Standard Modules
 Unit 3: Debugging and Error Handling
 Unit 4: Microsoft Jet Database Engine

Module 3: Complex Forms with VBA
 Unit 1: Creating Simple Custom Dialog Boxes
 Unit 2: Creating Complex Forms