Departmental Course Syllabus

Department: Administrative Computer Technology Revision Date: Fall 2009

San Antonio College * 1300 San Pedro* San Antonio, TX* 78212-4299

Course Number and Title: POFT 1274 Database Applications: MICROSOFT ACCESS 2007

Credit Hours: 2 Hours Hrs/Wk. Lecture: 2 Hrs/Wk. Lab: 1

Instructor: Kim Muschalek

Office: Nail Tech Building Rm. 223 Phone Number: (210) 486-0539 FAX: (210) 486-1727

Email: kmuschalek@alamo.edu Web Address: www.accd.edu/sac/act/kmuschalek

I. Catalog Description: Database Applications provides basic concepts related to currently used database software. Practical applications stress organizing and querying the database to meet users information needs.

II. Pre-requisites, co-requisites and other requirements:

  • Ability to type by touch recommended
  • Consistent access to, or ownership of, Microsoft Access 2007
  • Computer with internet access

III. Text: MICROSOFT OFFICE ACCESS 2007 Complete Concepts and Techniques. (c) 2008, Gary B. Shelly, Thomas J. Cashman, Philip J. Pratt, Thomson Course Technology; ISBN 1-4188-4340-7

IV. Instruction will consist of:

  • Self-paced instructional method presented in textbook
  • One-on-one explanation and problem solving
  • Student independent practice
  • Demonstration

V. Course Content: POFT 1274 provides an introduction to Microsoft Office Access 2007. Topics include creating a database, querying a database, maintaining a database, presenting data in reports and forms, and incorporating date, memo, and OLE fields.

VI. Learning Outcomes and Performance Objectives with their methods of measurement as used to determine the students’ mastery of those outcomes.

 Learning Outcome:

Performance Objectives/Method(s) of measurement for each objective:

Understand Access terminology, the Access window, and the basic characteristics of databases by creating a database, creating a table, defining fields, opening a table, adding records to an empty table, closing a table, and printing the contents of a table, use Access help system, close a database and quit Access.

Method of Measurement : Successfully complete homework assignments and course exams with a minimum of 70% accuracy.

  • Learn how to ask questions in a database by using queries. Students should be able to create and run a query, enter criteria into a query, sort data in a query, join tables, use calculations in a query, and design crosstab queries.

Method of Measurement : Successfully complete homework assignments and course exams with a minimum of 70% accuracy.

  • Students will be able to update records, filter records, change the structure of a database table, change the appearance of a datasheet, add validation rules to a table, enforce referential integrity in a database, order records, create and use indexes.

Method of Measurement : Successfully complete homework assignments and course exams with a minimum of 70% accuracy.

  • Understand and accomplish report creation, sort and group within a report, use multiple tables in a report, understand report design considerations, create and use custom forms, add combo boxes and titles to a form and understand form design considerations.

Method of Measurement : Successfully complete homework assignments and course exams with a minimum of 70% accuracy.

  • Enhance forms with OLE fields, hyperlinks, and subforms. Learn about and use special fields, updating new fields, use advanced form techniques such as subforms, labels, and titles. Use date and memo fields in a query.

Method of Measurement : Successfully complete homework assignments and course exams with a minimum of 70% accuracy.

  • Learn to create and open switchboards, modify a switchboard page, create a pivot tables, change properties in a pivot table, use a pivot table, create a pivot charts, change the chart type, change the pivotchart organization assign axis titles, remove drop areas, add a chart title, save a pivot chart. Students will create and run a macros, add actions to a micro, copy a macro.

Method of Measurement: Successfully complete homework assignments and course exams with a minimum of 70% accuracy.

SCANS Competencies: The following SCANS Competencies are included in this course:

C1 Allocation of time
C3 Materials/Facilities
C5 Acquires and evaluates performance
C6 Organizes and maintains information
C8 Uses computers to process information
C18 Selects technology
C19 Applies technology to task
C20 Maintains and troubleshoots equipment
The following SCANS Foundations are included in this course:
F1 Reading
F4 Mathematics
F5 Listening
F8 Decision Making
F9 Problem Solving
F10 Seeing things in the mind’s eye
F11 Knowing how to learn
F12 Reasoning
F13 Responsibility
F16 Self-management
F17 Integrity/Honesty

VII. Course requirements and grade computation.

A. College Requirements:

A written, comprehensive final examination, not to exceed two and one-half hours in length, shall be given at the end of each semester for each course at the regularly scheduled time. Any exceptions to these requirements must be approved by the appropriate dean. Other examinations are given at the discretion of the instructor.

A student who must be absent from a final examination should petition that instructor for permission to postpone the examination. A student absent without permission from a final examination is graded “F.” Postponed examinations result in a grade of “I.” The final exam must be taken within 120 calendar days from the end of the semester or the grade automatically becomes an “F.” (San Antonio College Bulletin, Faculty Handbook - January 1995)

B. Departmental Requirement:

Assignments -------------------------------------------------------- 50%

Includes software projects as listed on the assignment sheet.

Tests ---------------------------------------------------------------- 25%

Two comprehensive written tests consisting of T/F, Multiple Choice, and Fill-in-the-Blank will be given.

Final Examination ------------------------------------------------- 25%

Comprehensive written test consisting of T/F, Multiple Choice, and Fill-in-the-Blank will be given.

C. Instructor Requirements: Consistent attendance by staying on schedule-according to the applicable due date schedule is required. Students who do not turn in assignments for two consecutive weeks will be dropped from the course for lack of attendance. If a student is dropped from the class for excessive absences, a grade of WN will be recorded. Late work will be accepted but will be penalized 20 points.

VIII. College Policies:

A. San Antonio College does not discriminate on the basis of race, religion, color, national origin, sex, age, or disability with respect to access, employment programs or services.

B. Students are urged not to bring children to either a class or a lab. Minors under the age of twelve (12) must not be left unattended on campus. College Academic Council - April, 1998

C. ADA Statement: “As per Section 504 of the Vocational Rehabilitation Act of 1973 and the Americans with Disabilities Act of 1990, if accommodation is needed contact the Office of DisABILITY Support Services, CAC 124C, Phone: (210) 733-2347.

D. A Rapid Response Team exists for the purpose of responding to emergencies. If you have a disability that will require assistance in the event of a building evacuation, notify Disability Support Services, Chance Academic Center 124C, Phone: (210) 733-2347.

E. Academic Dishonesty: Students may be subject to disciplinary proceedings resulting

in an academic penalty or disciplinary penalty for academic dishonesty. Academic Dishonesty includes, but is not limited to, cheating on a test, plagiarism and collusion. For additional information refer to the “Student Code of Conduct” in the San Antonio College Bulletin.

F. Students are required to silence all electronic devices (e.g., pagers, cellular phones, etc.) when in classrooms, laboratories and the library. College Academic Council, 01/ 2000.

G. San Antonio College Attendance Policy: Regular and punctual attendance at all classes and laboratories, day and/or evening, is required. A student absent for any reason is responsible for all work missed. Both tardiness and early departure from class are forms of absenteeism. The instructor establishes the policy with regard to each.

Absences of each student are recorded without exception. The counting of absences begins on the first day of class. A student absent the equivalent of two weeks of instruction in a 16-week semester may be dropped by the instructor. If a student is dropped from a class for excessive absences, the instructor will record a grade of “W’ (withdraw). It is the student’s responsibility to ensure that the withdrawals have been submitted.

H. San Antonio College is a smoke free campus.

I. ACCD DPS Emergency Phone Numbers:

ACCD DPS Emergency Phone (210) 222-0911

ACCD DPS General Phone (210) 208-8099

ACCD DPS Weather Phone (210) 208-8189 (For information on college closures)

  • Students must also abide by the policies, procedures, and rules set forth in the “Student Code of Conduct” and all other policies set forth in the San Antonio College Bulletin.

 
 

[SAC][ACCD][ Instructor Homepage ]