Access – Advanced

Return to schedule



Space is limited. Register early to avoid disappointment.

Title Access – Advanced NEW!
Duration 28 hours
Emploi-Québec fee $56.00
General Public fee $614,24
Schedule Wednesday
6:00 p.m. to 10 p.m.
Lunch 30 minutes
Dates March 22, 29, April 5, 12, 19, 26, May 3
Prerequisites Basic knowledge of database management system
Target Audience This training course is intended for those who want to learn how to create and use simple Access databases and who wish to develop a fully functional database management system.
Instructor Khattar Daou / BH-213

Course Description

This training course is an advanced level of Microsoft Access databases. Participants will advance their skills in designing queries, forms and reports, get to know advanced Visual Basic concepts, and explore ways in which to make an access database work as a fully functional client-server application.

Topics Covered in this Course

Module 1: Database Management Systems

Unit 1: Introducing Database and Database Management Systems

Unit 2: Understanding Access Tables

Unit 3: Working with Access Queries

Unit 4: Selecting Table Indexes

Unit 5: Tabular Queries


Module 2: Working with Access Forms and Reports

Unit 1: Creating Basic Access Forms

Unit 2: Working with Data on Access Forms or Sub-Forms

Unit 3: Working with Form Controls

Unit 4: Improving Form Usability with VBA

Unit 5: Presenting Data with Access Reports


Module 3: Advanced Programming

Unit 1: Advanced Access Report Techniques with VBA

Unit 2: Using Message Boxes to improve Error Handling

Unit 3: Splitting Access Tables To Improve Performance

Unit 4: Creating a Custom Menu Bar and Main Menu

Unit 5: Managing and Securing a Database


Module 4: Additional Advanced Concepts (as time permits)

Unit 1: Preparing Executable client with dedicated Custom Opening (only allowing the use of designated forms and reports)

Unit 2: Generating Globally unique IDs in a network distributed database with over 25 concurrent active users

Unit 3: Managing Code Version Support (allowing or disallowing specific application version to force client updates)

Unit 4: Interacting with OS specific functions (session username and network time check)

Unit 5: Multi-level Complex Summary Queries with field-value as column headers

Unit 6: Electronic Equivalent User Signatures on a Form