COURSE DESCRIPTION

Introduction to database theory and the practical applications of a database.
 Prerequisite: COSC 1401, Microcomputer Applications. 

COURSE FOCUS

Use of a relational database package (Microsoft Access) graphical environment to create business applications.

TEXT AND REFERENCES

Microsoft Access 2003 Comphrensive Concepts and Techniques. Shelly, Cashman, Pratt, and Last; Course Technology 2004. ISBN: 0-619-20040-5

COURSE GOALS

The following list of course goals will be addressed in the course. These goals are
directly related to the performance objectives.

 (* designates a CRUCIAL goal)

  1. Use Microsoft Access user interface

  2. Locate Microsoft Access help system

  3. Define database components

  4. Develop database schema

  5. Apply application design concepts

  6. *Design database table

  7. *Create database table

  8. *Set field and table properties
  9. *Set table-to-table relationships
10. Identify ways to add and edit data
11. *Edit data using datasheet and form view
12. Copy and import data
13. *Use query-by-example (QBE) grid or wizard
14. Set query properties
15. *Create multi-table queries
16. Create calculated fields
17. Create parameterized queries
18. Create crosstab queries
19. Create top-value queries
20. Create select and action queries
21.  *Design and create forms
22. Customize forms and reports
23. Create form OLE object
24.  *Create subform
25.  Use form filter
26.  Describe report components
27.  *Create reports
28.  Customize database reports
29.  Use expressions in reports
30.  Sort and group data in reports
31.  Create, edit, and run macros
32.  Test and troubleshoot macros
33.  Create AutoKeys macro
34.  Customize menus and toolbars
35.  Determine security requirements
36.  Compact a database
37.  *Backup a database
38.  Document a database
39.  *Use Switchboard Manager
40.  Set startup instructions
41.  Design a custom database
42.  Create a custom database
43.  Insert data into a custom database
44.  Test and troubleshoot a custom database
45.  Present a custom database

STUDENT CONTRIBUTIONS

Each student will spend at least 4 hours per week preparing for class. Attendance is critical in this class. Students are responsible for any work missed. All TCC policies will be followed. 

STUDENTS WITH DISABILITIES

If a student requires special accommodations based on a disability, he or she must register with Disability Support Services (DSS) located in the Student Union Building. Students are then required to submit a form from the DSS office to the instructor by the second week of class verifying special assistance approval.
Students are responsible for arranging special accommodations with the guidance and consent of the instructor.

COURSE EVALUATION

The Final Course Grade is computed by the following relationship:

(0.40) Quiz and Assignment  Average + (0.40) Examination Average + (0.20) Final Exam Grade

Grading Scale

100-90 = A  89-80 = B  79-70 = C  69-60 = D  <60 = F

COURSE SCHEDULE