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
Pre-requisities	Familiarity with Windows. Must have ACCESS2016 software in order to work on this course.