Tompkins Cortland Community College

CAPS133 - Advanced Databases


This course focuses on advanced concepts and techniques in the use of a relational database management program. Students will learn how to establish relationships and manipulate data in multiple tables using Access. Topics include enforcing referential integrity, linking multiple tables in queries, using forms with sub-forms, generating reports with grouping and sub-reports, using calculated controls in forms and reports, and creating switchboards. Students taking this course in an online format must have access to a computer with Microsoft Office. Prerequisites: CAPS 131; prior completion or concurrent enrollment in MATH 090, RDNG 116 and ENGL 100 if required by placement testing. 1 Cr. (2 Lec., 2 Lab. for 5 weeks) Fall and spring semesters.