VBA for Access

Return to scheduleregister-button24

Course Title VBA for Access
Course Number 900-076-EQ
Platform Microsoft Windows
Duration 28 hours
Emploi-Québec fee (taxes incl.)
$96
General Public fee (taxes incl.)
$631.63
Schedule Saturday 9:00 a.m. to 4:30 p.m.
TBA
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-408

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

TOP