Catalog Course Search Details

 Department:    CIS

 Course #:    147

 Credits:    3

 Variable:     No

 IUs:    3

 CIP:    110301

 EPC:    514

 REV:    2018

 Course Description  

Introduction to the use of microcomputer database software for home and office. Provides an understanding of database software in general and Microsoft Access in particular, as a productive and useful tool.

 Prerequisite  

Prerequisite: computer literacy and file management skills are strongly recommended.

Contact Hours (based on 11 week quarter)

Lecture: 33

Lab: 0

Other: 0

Systems: 0

Clinical: 0

Intent: Distribution Requirement(s) Status:  

Vocational Preparatory Required for ATA degree, Required for certificate  

Equivalencies At Other Institutions

Learning Outcomes

After completing this course, the student will be able to:

1. Create Databases.
2. Design Queries.
3. Maintain Data.
4. Create Forms and Reports.
5. Develop Advanced Forms.
6. Create Macros.

General Education Learning Values & Outcomes

Revised August 2008 and affects outlines for 2008 year 1 and later.

2. Critical Thinking

Definition: The ability to think critically about the nature of knowledge within a discipline and about the ways in which that knowledge is constructed and validated and to be sensitive to the ways these processes often vary among disciplines.

Outcomes: Students will be able to . . .
2.1 Identify and express concepts, terms, and facts related to a specific discipline.
2.3 Identify, interpret, and evaluate pertinent data and previous experience to reach conclusions.

6. Individual Awareness & Responsibility

Definition: Understanding, managing, and taking responsibility for one’s learning and behavior in varied and changing environments.

Outcomes: Students will be able to . . .
6.2 Demonstrate standards of professionalism in manner, appearance, and setting appropriate to the context, including the classroom, workplace, and community.

8. Mathematical Reasoning

Definition: Understanding and applying concepts of mathematics and logical reasoning in a variety of contexts, both academic and non-academic.

Outcomes: Students will be able to . . .
8.2 Correctly apply logical reasoning and mathematical principles to solve problems.
8.3 Interpret information and reasoning expressed mathematically (for example in spreadsheets, diagrams, charts, formulas, etc.).
8.4 Communicate mathematical information effectively.

Course Contents

1. Database Creation
2. Database Query Design.
3. Database Maintenance.
4. Form and Report Creation.
5. Advanced Form Development.
6. Macro Writing.