INSTRUCTOR:

DEPARTMENT:

Computer Applications/Office Technology (CAO)

Lake Tahoe Community College

One College Drive

South Lake Tahoe, CA 96150

PHONE:

OFFICE HOURS:

5:00-6:00 pm
4:00-6:00 pm
5:00-6:00 pm
5:00-6:00 pm

CLASS DATES:

CLASS TIME:

CLASSROOM:

COURSE WEB SITE:

COURSE DESCRIPTION:

This is a comprehensive course in relational database applications using database management software, Microsoft Access 2002. Topics include database design concepts, the development and maintenance of databases, table relationships, normalization, the creation of basic and advanced queries, custom forms, and custom reports.

UNITS: 4

ADVISORY:

CAO 110 Microcomputer Applications or equivalent

Students must be proficient in the Windows environment

STUDENT OUTCOMES:

The successful student will:

Learn relational database concepts and terminology

Design and develop database applications

Normalize database tables

Design and develop basic and advanced queries

Develop custom input forms

Develop custom reports

TEXTBOOK:
New Perspectives on Microsoft Access 2002 - Comprehensive

by Adamski and Finnegan

published by Course Technology 2002

ISBN 0-619-02089-X

SOFTWARE:    Microsoft Access 2002 (or Access 2003)

REQUIRED MATERIALS: USB Flash drive

ATTENDANCE:

Students are expected to attend all class meetings. There will be no make up exams except in the event of an emergency or illness, in which case the student must contact the instructor before the exam is held.

SPECIAL ACCOMMODATIONS:

Students with disabilities who may need accommodations for this class are encouraged to notify the instructor and contact the Disability Resource Center (DRC) early in the quarter so that reasonable accommodations may be implemented as soon as possible. Students may contact the DRC by visiting the Center in Room A205 or by phoning 541-4660 x249 (voice) or 542-1870 (TTY for deaf students). All information will remain confidential,

HOMEWORK ASSIGNMENTS:

Homework assignments are designed to reinforce the learning that takes place in the classroom. Students are expected to spend several hours per week outside of class working on hands-on homework assignments. These assignments should be completed in the college computer labs or off-campus if students have their own access to computers and software. Homework assignments must be turned in to the instructor at the beginning of class on the due date. Late assignments will not be accepted, except in the event of emergency or illness.

EXAMS:

The midterm and final will be written, computer hands-on, open book exams that will test the student's understanding (not memorization) of important concepts and skills learned in the classroom.

GRADING:

Final grades will be determined by points earned on homework assignments and exams. Course points will be distributed as follows:

NOTE: This course can be taken with the Credit/No Credit (CR/NC) option.

            The deadline for applying for CR/NC status is noon on Friday 5/2.

DISHONESTY POLICY
Homework and exams must be completed by each individual student. Joint work, sharing assignments, or cheating will result in a grade of F for the course.

OUTLINE OF TOPICS

TUTORIAL 1 – INTRODUCTION TO MICROSOFT ACCESS 2002

introduction to database management

database terminology

compacting a database

TUTORIAL 2 – CREATING AND MAINTAINING A DATABASE

creating a table

field properties and data types

modifying a table structure

adding, deleting, and modifying records

copying records from an Access database

importing a table from an Access database

TUTORIAL 3 – QUERYING A DATABASE

defining table relationships

normalization (from class notes)

creating a query

setting criteria with AND/OR logic

calculated fields

using aggregate functions AVG, COUNT, MAX, MIN, SUM

grouping record data in a query

TUTORIAL 4 – CREATING FORMS AND REPORTS

creating a form using the Form Wizard

creating a main form and subform

creating a report using the Report Wizard

TUTORIAL 5 – ENHANCING A TABLE’S DESIGN AND CREATING ADVANCED QUERIES AND CUSTOM FORMS

table design: Lookup Wizard, input mask

advanced queries:

          pattern matching

          list of values

          NOT operator

          combined AND/OR logic

          parameter queries

creating custom forms

TUTORIAL 6 – CREATING CUSTOM REPORTS

creating custom reports

conditional values in a calculated field

sorting and grouping data

calculating totals

conditional formatting

TUTORIAL 8 – USING QUERY WIZARDS AND ACTION QUERIES, AND DEFINING TABLE RELATIONSHIPS

specialized queries: Crosstab, Find Duplicates, Find Unmatched, Top Values

action queries: Make Table, Append, Delete, Update

IMPORTANT DATES

back to top