CECM 226 - XP Level II

Institution:

Tompkins Cortland Community College

Subject:

Description:

You will learn to: -normalize tables to reduce redundancy, set relationships between tables, and implement referential integrity -use the Lookup Wizard to create lookup lists in table Design view and use subdatasheets to enter data in related tables -create an input mask in Design view, use the Input Mask Wizard, set different properties of a field in Design view, and set validation rules for entering data in a field -create self-joins, inner joins, and outer joins, create calculated fields in a query, create queries to add, modify, and delete data from tables, and create queries to create a new table -use queries to view summarized and grouped data from tables, create crosstab queries to summarize grouped data, create parameter queries, and set indexes in a table -use controls to add graphics and calculated fields to a form, add combo boxes to a form, and add unbound controls to a form -customize headers and footers in a report, use the HideDuplicates property in a report, use functions to add calculated values, and use subreports to view data from related tables in a report -create and modify charts in forms and reports Prerequisites: Access Level I or equivalent knowledge.

Credits:

3.00

Credit Hours:

Prerequisites:

Corequisites:

Exclusions:

Level:

Instructional Type:

Lecture

Notes:

Additional Information:

Historical Version(s):

Institution Website:

www.TC3.edu

Phone Number:

(607) 844-8211

Regional Accreditation:

Middle States Association of Colleges and Schools

Calendar System:

Semester

The Course Profile information is provided and updated by third parties including the respective institutions. While the institutions are able to update their information at any time, the information is not independently validated, and no party associated with this website can accept responsibility for its accuracy.