Microsoft Access-Advanced CEMS-987

Course Name: Microsoft Access-Advanced
Course Number: CEMS-987
Category: Distance Learning
Description The Microsoft Access-Advanced course employs a combination of instructor-led study and self-guidance to cover the basic to intermediate features of Microsoft Access.

Using a preset table of information, the instructor will walk you through using Access to produce professional customized database systems and management concepts. Macros and the advantages of the Wizards supported by Access will be covered in an in-depth manner. Microsoft Access-Advanced will also examine essential topics such as creating and modifying advanced tables, creating and modifying forms, defining queries, using advanced report features, using Access tools, using data from the Internet and other sources, and more.

Because this course will include a structured tutorial approach followed by case-oriented problem-solving exercises for learning the powerful spreadsheet software, you will gain much hands-on experience.

At the conclusion of the course not only will you have the skills required for certification on the Core Level of MS Access, you will also 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 This course is offered in Distance 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
Requires the following prerequisite(s):

CEMS-985 - Microsoft Access
The prerequisite(s) listed above are mandatory for registration. You will be asked to produce proof of qualification on the first day of class
Software Requirement: Online course – MS Access 2000 or higher.
Section Cost Term Dates Meeting Times Campus Action
425 $424.00 202101 2021-01-12 to
2021-04-20
Times Days
No times
defined
-
Distance Online Full
426 $424.00 202101 2021-02-03 to
2021-05-11
Times Days
No times
defined
-
Distance Online Full
427 $424.00 202101 2021-03-02 to
2021-06-08
Times Days
No times
defined
-
Distance Online Add
435 $1,649.41 202105 2021-05-11 to
2021-08-17
Times Days
No times
defined
-
Distance Online Add
438 $424.00 202105 2021-06-01 to
2021-09-07
Times Days
No times
defined
-
Distance Online Add
439 $424.00 202105 2021-07-02 to
2021-10-08
Times Days
No times
defined
-
Distance Online Add
440 $424.00 202105 2021-08-03 to
2021-11-09
Times Days
No times
defined
-
Distance Online Add
Legend for Days
M - Monday T - Tuesday W - WednesdayR - Thursday F - Friday S - Saturday U -Sunday
TBA - To Be Announced