Access 2003 - Level III

Institution:

Tompkins Cortland Community College

Subject:

Description:

Access 2003 Level III is a MOS preparation workshop designed to teach you proficiency in using more advanced Access features and functions, such as how to: * create Pivot Tables and Pivot Charts for analyzing and comparing large amounts of data * create and use an advanced form by adding a tab control, an option group control, and a subform to it * create and use a macro to open database objects and attach a macro to a command button * create and use macros to automate user-interaction by using the Condition column and SetValue action * use Structured Query Language (SQL) to create queries in Access * use hyperlink and data access pages to link an Access database to the Internet or intranet * work with database utilities to optimize resources and secure data, and use security features to encrypt data from other applications * secure a database by setting a password and specifying user-level and object-level permissions Prerequisites: Access Level II 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.