ESSEX COUNTY COLLEGE Business Division CIS 137 Exploring Microsoft Office Access – Course Outline Course Number & Name: CIS 137 Exploring Microsoft Office Access Credit Hours: 3.0 Contact Hours: Lecture: 3.0 Lab: N/A Other: N/A Prerequisites: Grade of or better in CIS 107 “C” Co-requisites: None Concurrent Courses: None Course Outline Revision Date: Fall 2010 Course Description: This course introduces students to the windows concepts, entering and updating records in a database, performing reporting and query functions with multiple databases, and the differences between Excel and Access. Students will be exposed to step-by- step instruction using MS Access to create and maintain databases. Students will be able to plan, create and manipulate databases for typical business needs. Course Goals: Upon successful completion of this course, students should be able to do the following: explain and demonstrate common database skills; create and design Access databases using related data; create and use queries; and create and interpret useful and professional reports. Measurable Course Performance Objectives (MPOs): Upon successful completion of this course, students should specifically be able to do the following: Explain and demonstrate common database skills: discuss features of an Access database; explain and demonstrate skills related to storage and memory, file management, and soft table data; and use Access to manage data and describe relationship windows Create and design Access databases using related data: design data and create tables with the data; share data with Excel, create and run a query, and use the query wizard; and discuss large databases
ESSEX COUNTY COLLEGE Business Division CIS 137 – Exploring Microsoft Office Access Course Outline Course Number & Name: CIS 137 Exploring Microsoft Office Access Credit Hours: Contact Hours: 3.0 Lecture: 3.0 Lab: N/A Other: N/A Prerequisites: Grade of “C” or better in CIS 107 Co-requisites: None Concurrent Courses: None Course Outline Revision Date: Fall 2010 Course Description: This course introduces students to the windows concepts, entering and updating records in a database, performing reporting and query functions with multiple databases, and the differences between Excel and Access. Students will be exposed to step-by- step instruction using MS Access to create and maintain databases. Students will be able to plan, create and manipulate databases for typical business needs. Course Goals: Upon successful completion of this course, students should be able to do the following: explain and demonstrate common database skills; create and design Access databases using related data; create and use queries; and create and interpret useful and professional reports. Measurable Course Performance Objectives (MPOs): Upon successful completion of this course, students should specifically be able to do the following: Explain and demonstrate common database skills: discuss features of an Access database; explain and demonstrate skills related to storage and memory, file management, and soft table data; and use Access to manage data and describe relationship windows Create and design Access databases using related data: design data and create tables with the data; share data with Excel, create and run a query, and use the query wizard; and discuss large databases
cis.137.outline.f2010.docx