Microsoft Access-Advanced CEMS-987

Course Code CEMS-987
Course Name Microsoft Access-Advanced
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 both CE and Distance Learning formats.
Contact Telephone 416-289-5207
Contact E-mail ce@centennialcollege.ca
Associated Certificates
Register Online https://secure.centennialcollege.ca/webreg
Section Cost Semester Start Date End Date Meeting Times Campus
415 $412.00 Fall 2017 2017-09-12 2017-12-19
Times Days
No times defined -
Distance Online
417 $412.00 Fall 2017 2017-10-02 2018-01-08
Times Days
No times defined -
Distance Online
418 $412.00 Fall 2017 2017-11-01 2018-02-07
Times Days
No times defined -
Distance Online
425 $412.00 Winter 2018 2018-01-16 2018-04-24
Times Days
No times defined -
Distance Online
426 $412.00 Winter 2018 2018-02-01 2018-05-10
Times Days
No times defined -
Distance Online
427 $412.00 Winter 2018 2018-03-01 2018-06-07
Times Days
No times defined -
Distance Online
435 $412.00 Summer 2018 2018-05-15 2018-08-21
Times Days
No times defined -
Distance Online
438 $412.00 Summer 2018 2018-06-01 2018-09-07
Times Days
No times defined -
Distance Online
439 $412.00 Summer 2018 2018-07-03 2018-10-09
Times Days
No times defined -
Distance Online
440 $412.00 Summer 2018 2018-08-01 2018-11-07
Times Days
No times defined -
Distance Online
Legend for Days
M - Monday T - Tuesday W - Wednesday R - Thursday F - Friday S - Saturday U - Sunday
TBA - To Be Announced