Skip to main content
Photo of a student studying in a library

Course Description

Schoolcraft is excited to offer traditional credit face-to-face, hybrid, online, and remote classes for Fall 2020 while providing students a safe experience based on recent COVID-19 concerns.

Please see the COVID-19 web page to learn more. Keep checking the schedule for additions on our New, Added, and Late Starting Courses web page.

Computer Information Systems - CIS 225

Database Management Systems

3 Credit Hours
3 Lecture Hours

Course Description

This course covers a popular relational database, Microsoft Access, in depth. Emphasis is on creating, editing, sorting, linking and querying databases. Forms, switchboards and custom reports will be created. Advanced topics include designing and creating a complete application system, as well as programming in SQL. Emphasis will also be on understanding the concepts behind database management system design to prepare students to be both users and developers.

Prerequisites

(A requirement that must be completed before taking this course.)

  • None.

Recommended

Course Competencies

Upon successful completion of the course, the student should be able to:

  • Demonstrate database skills learned with hands-on assignments.
  • Apply the concepts of database design by completing realistic case studies.
  • Explore the capabilities of Access using the online help facility and other materials.
  • Use Access Wizards such as Lookup Wizard, Form and Report Wizards, Control Wizards, etc.
  • Create queries including query calculations, parameter queries, crosstab queries, action queries, top value queries, compound criteria and view SQL query statements.
  • Maintain a database.
  • Interface with other applications to Access.
  • Create forms and reports.
  • Design a switchboard with multiple pages as a graphical user interface using macros.
  • Administer a database system.

Course Schedule

 CourseSectionCourse TitleLocationCredit HoursInstructorsSeats Available ⁄Capacity ⁄WaitlistStatusFeeDays-Time-Room

Fall; 2020; COMPUTER INFORMATION SYSTEMS; No of Weeks : 15; Begins : 08/31/2020

 225142739Database ManagementONL3Towner M11/31/0Open$12.00 
 225142824Database ManagementRMT3Lee C20/24/0Open$52.00T  02:00 PM-04:52 PM WEBWEB

Key: Day of the Week

  • T = Tuesday
  • R = Thursday
  • S = Saturday
  • X = Sunday