Description:

Upon completion of this course, the student should be able to design and define a relational database; create custom forms and reports for data entry, updating and presentation; and build the necessary queries to support these objects. The student should be able to transfer data into and out of the database from various file formats; use database software to develop Web pages and hyperlinks; and manipulate the data and database with introductory macro, query language and programming skills. The course contains a capstone project in which the student uses all the skills learned to create a working database for a client based on a real-world situation. 2 hrs. 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. Design a 3-5 table relational database from a set of customer reports and documentation.
2. Build a working 3-5 table relational database according to customer requirements.
3. Create the necessary queries, forms, reports, and macros to support a customer's documented requirements (3-5 objects per object type).
4. Create parameter queries, filters, complex criteria matching, action, update queries, and introductory SQL statements.
5. Create text boxes, combo boxes, subforms, list boxes, command buttons, and other bound, unbound, and calculated controls on forms.
6. Create reports using advanced features such as grouping and calculated controls, and graphs.
7. Import and export data from other file types such as text, spreadsheets, and HTML.
8. Enhance the graphical user interface with dialog boxes and GUI screens.
9. Create macros and macro groups, and attach them to command buttons, object events, and toolbars.
10. Build basic functions and event procedures using VBA programming code.

Content Outline & Competencies:

I. Demonstrate a mastery of the introductory concepts learned in CPCA
114

II. Advanced Queries
   A. Build a query using complex query criteria involving multiple
fields
   B. Build a parameter queries
   C. Build a crosstab queries
   D. Analyze redundant data 
   E. Analyze unrelated records 
   F. Create a query to find top values
   G. Create action queries that make tables, append records, delete
records, and update fields
   H. Join tables within a query
   I. Use basic SQL commands to build a query and retrieve data

III. Advanced Forms
   A. Analyze the need for subforms controls and create them
   B. Use tab controls to enhance the design of a form
   C. Create combo boxes
   D. Add calculations to forms

IV. Advanced Reports
   A. Use multiple sorting and grouping fields
   B. Create calculated controls for multiple groups
   C. Create report totals

V. Importing and Exporting Data with other Programs
   A. Exporting Access data to HTML
   B. Export data to a spreadsheet
   C. Import CSV, XML, or other text files
      
VI. Analyze Relationships
   A. Analyze Many-to-Many Relationships
   B. Build One-to-Many Relationships
   C. Build One-to-One Relationships

VII. User Interface Issues
   A. Design and develop an end-user interface for the database
   B. Develop dialog boxes, error message prompts, and command buttons
   C. Create macros to automate common processes
   D. Create command buttons to run macros
   E. Create custom toolbars and menus

VIII. Introduction to database programming statements
   A. Use events to run macros and programming code
   B. Create procedures to update and change database properties
   C. Explain modules and use them to create procedures
   D. Create functions to calculate new values
   E. Test procedures using debug features

IX. Use database startup options for the following purposes:
   A. Setting appropriate levels of security
   B. Making the database easier to use

Methods of Evaluation of Competencies:

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

A minimum of 3 quizzes     50% of grade
A minimum of 10 projects   50% of grade
                          100%

Grade 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.