Access – Intermediate

Return to scheduleregister-button24

Title Access – Intermediate
Course number 900-095-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:00 p.m.
Dates May 21, 23, 28, 30, June 4, 6, 11
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 Access databases and who wish to develop a fully functional database management system.
Instructor Khattar Daou
Location Brittain Hall – BH-407

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

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 Intermediate level of Microsoft Access databases. Participants will advance their skills in designing queries, forms and reports.

Designing a Database
· Unit 1: Designing a Database – The Database Design
· Unit 2: Backing-Up, Compacting, Encrypting, and Recovering a Damaged Database
· Unit 3: Adding, Editing, Finding, and Sorting Data
· Unit 4: Importing, Exporting, and Attaching Tables

Module 2: Designing Query as the Basic for a Form or Report
· Unit 1: Creating Calculated Fields and Calculating Totals in Queries
· Unit 2: Creating Multiple-Table Queries
· Unit 3: Creating Parameter and Crosstab Queries
· Unit 4: Changing Data with Action Queries

Module 3: Developing Effective Forms
· Unit 1: Using Controls to Customize a Form
· Unit 2: Creating Form/Sub-Form
· Unit 3: Using Expression in Forms
· Unit 4: Looking Up a Value from a Table

Module 4: Developing Effective Reports
· Unit 1: Designing Reports, Creating & Adjusting Controls
· Unit 2: Creating Report/Sub-Report
· Unit 3: Using Expression in Reports
· Unit 4: Sorting and Grouping Data