Description:

Upon successful completion of this course, the student should be able to demonstrate database development skills by effectively identifying the types of projects that should be developed using Microsoft Access rather than a spreadsheet; build tables that can be related to each other in order to eliminate data entry duplication; customize forms and reports; create basic and advance queries; and define relational integrity between tables. The student should also be able to create basic and advanced queries with single and multiple tables using Boolean logic. The student should be able to identify and implement methods of troubleshooting and explain ways of getting additional help. 1 hr. lecture/wk.

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. Identify methods of data collections and create an appropriately structured table.
2. Explain the differences between flat-file and relational databases, and identify the strengths and weaknesses of each one.
3. Create and combine the multiple tables.
4. Use the Table Lookup feature to retrieve information.
5. Create and customize reports and forms.
6. Define relational integrity between multiple tables.
7. Create basic and advanced queries to retrieve appropriate information.
8. Use queries to globally change information.
9. Use a database file to create a mail-merge document.
10. Create single and multi-dimensional crosstabs and graphs.
11. Troubleshoot a table to determine solutions to existing problems.
12. Identify multiple options for acquiring additional help.

Content Outline & Competencies:

I. Collecting Appropriate Data
   A. Map and implement a data collection strategy
   B. Determine whether a flat-file or relational database is required
   C. Analyze all data for availability

II. Building Tables
   A. Build multiple table structures
   B. Enter and enhance table data
   C. Globally enter data
   D. Create links to lookup tables
   E. Use data validation techniques

III. Linking Tables
   A. Determine the fields that need to be linked for forms and reports
   B. Link fields and tables in forms
   C. Link fields and tables in reports
   D. Create relational integrity between fields and tables

IV. Performing Basic and Advanced Queries
   A. Conduct single and multiple field Boolean searches and selection
   B. Analyze the outcome of a query before running it
   C. Identify and analyze query failures
   D. Run a query using multiple tables
   E. Make calculations with queries
   F. Select records that don’t meet specified criteria

V. Demonstrating Basic and Advanced Form Design
   A. Develop form designs
   B. Build forms based on single tables
   C. Build forms based on multiple tables
   D. Set defaults in forms
   E. Create calculated fields in forms

VI. Demonstrating Basic and Advanced Report Design
   A. Develop report designs
   B. Build forms based on single tables
   C. Build forms based on multiple tables
   D. Set defaults in forms
   E. Create calculated fields in forms

VII. Creating Crosstabs, Graphs, and Graphics in Forms and Reports
   A. Determine the need for crosstabs, graphs, and graphics
   B. Create crosstabs
   C. Create graphs
   D. Import graphic images
   E. Scan graphic images

VIII. Creating Macros, Styles, and Templates to Increase Efficiency,
Effectiveness, and Accuracy
   A. Record, edit, play, and delete macros
   B. Use existing templates to decrease development time
   C. Save modified templates
   D. Create, assign, edit, and delete styles

IX. Troubleshooting Tables, Queries, Forms, and Reports
   A. Determine when there is an existing problem
   B. Use sample data to confirm results
   C. Troubleshoot error messages
   D. Check for common errors

X. Seeking Additional Help
   A. Find answers to frequently asked questions
   B. Find database related publications
   C. Use the Internet

Methods of Evaluation of Competencies:

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

   Tests                 30% of grade   
   In-Class Exercises    20% of grade   
   Projects              50% of grade   
      Total             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.