Description:

This course provides an introduction to the concepts and real-world applications of microcomputer relational database software. Foundational database competencies, including building tables, defining fields, relating tables, entering and editing data, filtering, and sorting will be covered. Students will query the database to select, calculate and summarize information. Students will build and customize forms and reports. 1 hr. lecture/wk.

Associated Costs: These are additional (out-of-pocket) expense considerations that students should expect in addition to the course tuition, fees, and textbooks. $10 to $20.

Supplies: Refer to the instructor's course syllabus for details about any supplies that may be required.

Textbook(s): For information see - http://bookstore.jccc.net

Course Fees: NONE

Course Objectives:

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

1. Relate the purpose and advantages of using relational database software to real world information management problems.
2. Create field names, define field data types, identify primary keys, and edit the appropriate field properties in building and modifying tables.
3. Add, delete, copy, and edit records in a datasheet and form.
4. Link tables with appropriate relationships.
5. Sort and filter data.
6. Build queries to select, calculate, and summarize fields and records.
7. Create and modify forms to enter and maintain data.
8. Build and modify reports.

Content Outline & Competencies:

I. Database Concepts
   A. Explain the purposes for a database
   B. Describe the advantages of a database
   C. Define the terms: Field, Record, Table, Primary Key Field, Query,
Form, Report 

II. Database Software Overview
   A. Create and modify a table structures
   B. Enter and update data using datasheets  
   C. Create and modify select and summary queries 
   D. Enter and update data using a query datasheet 
   E. Create and modify data entry forms
   F. Enter and update data using a form
   G. Create and modify reports 

III. Database Structure
   A. Compare and contrast different field types 
   B. Compare, contrast, and apply different relationships, including:
      1. One-to-One
      2. One-to-Many
      3. Many-to-Many
   C. Use referential integrity

IV. Queries
   A. Create select queries
   B. Develop criteria to limit the recordset using logical and
mathematical operators
   C. Create calculated fields 
   D. Create summary fields using functions such as Sum, Average, and
Count
   E. Apply simple and complex filters

V. Forms
   A. Create forms with a wide variety of bound and unbound controls
   B. Modify controls 

VI. Reports
   A. Use report sections and controls to create simple and complex
reports
   B. Use expressions to create calculations on groups of records

VII. Database Management
   A. Compact a database
   B. Backup a database

Methods of Evaluation of Competencies:

Evaluation of student mastery of course competencies will be accomplished using the following methods:

A minimum of two quizzes:        50% of grade
A minimum of five projects:      50% of grade
                                100%

Grading Criteria:
   90 - 100%   A
   80 -  89%   B
   70 -  79%   C
   60 -  69%   D
    0 -  59%   F

Caveats: NONE

Disabilities:

If you are a student with a disability, and if you will be requesting accommodations, it is your responsibility to contact Access Services. Access Services will recommend any appropriate accommodations to your professor and his/her director. The professor and director will identify for you which accommodations will be arranged.

JCCC provides a range of services to allow persons with disabilities to participate in educational programs and activities. If you desire support services, contact the office of Access Services for Students With Disabilities (913) 469-8500, ext. 3521 or TDD (913) 469-3885. The Access Services office is located in the Success Center on the second floor of the Student Center.