Microsoft Access CEMS-985

Course Name: Microsoft Access
Course Number: CEMS-985
Category: Distance Learning
Description Microsoft Access presents a structured tutorial approach for all you need to know about this powerful database package, allowing you to manipulate and query data to customize the reports that you need.

Case-oriented problem solving exercises will take you through the basic to intermediate features of Microsoft Access. You will cover areas that include creating, editing and printing as well as querying and linking databases. More specifically, the course will delve into: creating a database table, creating relationships between database tables, creating reporting, mailing labels and charts; importing and exporting data, creating Web pages using Database Wizards, and more.

The Microsoft Access course provides you the Microsoft Office User Specialist (MOUS) skills required for certification on the Core Level of MS Access.

Upon successful completion of this course you will be able to:

Create, maintain and edit database records, files and tables;
Create related tables using primary key field, foreign key field and one-to-many relationships;
Plan and create tables, queries, lists, forms and reports for efficient data display and access;
Create files and tables with data exports, including Web pages with hyperlinks.
Notes Unique Software Requirements:
This course requires Access 2016 for Windows. You will not be able to complete the course with any other version of Access.
This course is offered in Online format only.

Please email online@centennialcollege.ca or visit www.centennialcollege.ca/dl or call 46-289-5000 Extension 2555
Associated Programs
7046 - Microsoft Office Application Support
7167 - Geographic Information Systems
Pre-requisities
Familiarity with Windows. Must have ACCESS2016 software in order to work on this course.
Section Cost Term Dates Meeting Times Campus Action
425 $421.00 202201 2022-01-11 to
2022-04-19
Times Days
No times
defined
-
OntarioLearn Add
426 $421.00 202201 2022-02-01 to
2022-05-10
Times Days
No times
defined
-
OntarioLearn Add
427 $421.00 202201 2022-03-01 to
2022-06-07
Times Days
No times
defined
-
OntarioLearn Add
435 $421.00 202205 2022-05-11 to
2022-08-17
Times Days
No times
defined
-
OntarioLearn Add
438 $421.00 202205 2022-06-01 to
2022-09-07
Times Days
No times
defined
-
OntarioLearn Add
439 $421.00 202205 2022-07-04 to
2022-10-11
Times Days
No times
defined
-
OntarioLearn Add
440 $421.00 202205 2022-08-02 to
2022-11-08
Times Days
No times
defined
-
OntarioLearn Add
Legend for Days
M - Monday T - Tuesday W - WednesdayR - Thursday F - Friday S - Saturday U -Sunday
TBA - To Be Announced