Access Advanced

Return to scheduleregister-button24

Title Access – Advanced
Platform Microsoft Windows
Duration 28 hours
Gouvernement du Québec fee $56.00
General Public fee $651.91
Schedule Tuesday  6 p.m. to 10:00 p.m.
Dates March 26, April 2 ,9,16 ,23, 30 , May 7
Prerequisites Completion of the course SQL- I 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 simple Access databases and who wish to develop a fully functional database management system.
Instructor Khattar Daou / BH-407

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