CST 257 - Database MS Access

Credits: 3

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.

Prerequisite(s): Any microcomputer class
Corequisite(s): None
Lecture Hours: 45 Lab Hours: 0
Meets MTA Requirement: None
Pass/NoCredit: Yes

Outcomes and Objectives

Discuss the features of database management systems (DBMS) software and implement those feature using MicroSoft Access.
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
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
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