Delta College logo

Database MS Access

Course NumberCST 257
Credits3
Lab Hours0
Lecture Hours45
Course DescriptionPrerequisite: Any microcomputer class. Emphasizes the advantages of database processing, modeling, and design. Discusses design concepts from the standpoint of the user. Uses Microsoft ACCESS. Credit may be earned in CST 257 or CIS 260, but not both. (45-0)


Outcomes and Objectives

Discuss the features of database management systems (DBMS) software and implement those feature using MicroSoft Access.
Objectives:
  1. Describe and demonstrate queries, sorting, indexes, labels, reports, updates, input forms, graphs and calculations
  2. Describe and be able to create database structures using the various field types
  3. Explain the methods of implement linking and embedding objects from Excel and MS Word
  4. Explain the methods and implement some of the common tool box features found in Visual Basis

Discuss the features of database design and its practical usage
Objectives:
  1. Describe and apply rules of database design including 1st and 2nd normal forms
  2. Explain and implement a database application to a user in Venn diagram and logic set form
  3. Explain and implement a relational database model
  4. Identify and set-up a key relations between files using primary and foreign keys

Complete a project in a group setting
Objectives:
  1. Recognize the different time constraints of tasks and its relation to people
  2. Plan and organize tasks within a group
  3. Share output and receive input from other team members




1961 Delta Road, University Center MI 48710 | 989-686-9000 | info@delta.edu
Delta College is an Equal Opportunity Organization, committed to excellence through inclusiveness and diversity.
Copyright ©