Access – Advanced

Return to schedule



Space is limited. Register early to avoid disappointment.

Title Access – Advanced NEW!
Platform Microsoft Windows
Duration 28 hours
Gouvernement du Québec fee $96.00
General Public fee $631.63
Schedule Monday and Wednesday from 6 p.m. to 10:00 p.m.
Dates November 1, 6. 8, 13, 15, 20, 22
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-214

Required Textbook: New Perspectives Microsoft Office 365 & Access 2016: Comprehensive 1st Edition | Mark Shellman | © 2017 ISBN: 978-1305880139 | Published by Nelson Higher Education


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: Analyzing Data for Effective Decision Making
 Unit 1: Introducing Database and Database Management Systems
 Unit 2: Advanced Tables Design
 Unit 3: Working with Access Action Queries
 Unit 4: Analyzing Data in Access

Module 2: Collecting Data with Well-Designed Forms
 Unit 1: Developing a Consistent User Interface
 Unit 2: Creating Forms with Sub-Forms
 Unit 3: Creating a Well-Designed Navigation Form
 Unit 4: Automating Tasks by Creating Basic Macros

Module 3: Developing Effective Reports
 Unit 1: Presenting Data with Access Reports
 Unit 2: Using Advanced Access Report Techniques
 Unit 3: Defining Conditional Formatting Rules in a Report
 Unit 4: Developing Reports with Sub-Reports