Access Advanced

Return to scheduleregister-button24

Title Access – Advanced
Course number 900-096-EQ
Platform Microsoft Windows
Duration 28 hours
Gouvernement du Québec fee $56.00
General Public fee $666.40
Schedule Tuesday & Thursday 6 p.m. to 10 p.m.
Dates June 18, 20 , 27, 27, July 2, 4, 9
Prerequisites Completion of the course Access Intermediate or equivalent knowledge of database management system
Target Audience This training course is intended for those who want to learn how to create and use Access databases and how to use Visual Basic for Application (VBA) to respond to events on forms and Reports.
Instructor Khattar Daou
Location Brittain Hall – BH-407

NB: This is a non-credit course. Certificate provided for all participants who have conmpleted 80% of the course hours.

Required Textbook:

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

Course Description

This training course is an advanced level of Microsoft Access databases. Participants will advance their skills in designing queries, forms and reports.

Module 1: Introducing Visual Basic for Applications (VBA)
· Unit 1: When to Use VBA Instead of Macros
· Unit 2: VBA Syntax and Statements
· Unit 3: Functions, Procedures and Modules
· Unit 4: Controls Structures

Module 2: Automate Access Forms
· Unit 1: Customizing Command Buttons
· Unit 2: Assign Values to Controls at Run Time
· Unit 3: Using Pop-Up Forms and Dialog Boxes
· Unit 4: Populating Controls on a Form

Module 3: Access as an Event-Driven Application
· Unit 1: Access VBA Programming Model
· Unit 2: Working with Objects and Collections
· Unit 3: Working with Events
· Unit 4: Working with Sets of Records