Skip to main content

National College Credit Recommendation Service

Board of Regents  |  University of the State of New York

Search Google Appliance

Coopersmith Career Consulting | Evaluated Learning Experience

Microsoft Access (TCH-164)

Location: 
Various, distance learning format.
Length: 

Varies (self-study; self-paced).

Dates: 
July 2013 - Present.
Instructional delivery format: 
Proficiency exam
Learner Outcomes: 
Upon successful completion of the course, students will be able to: create Access databases and populate them to relevant data; query databases by various criteria and create forms for queries; perform basic calculations and statistics within queries; maintain Access databases by updating records, filtering records, setting validation rules, changing the appearance of data sheets and making mass changes within databases; create reports and forms generated from information in Access databases; generate multi-table forms and manipulate these forms using various techniques; utilize advanced Access reporting techniques to manipulate Access reports and forms in a variety of ways; use Structured Query Language (SQL) to manage data relating to Access databases in a variety of ways.
Instruction: 

This self-study course covers functions and features of Microsoft Access 2010. Students study database concepts and the Access environment and learn how to design and create databases. Major topics include: tables, fields, and records, sorting and filtering data, setting field properties and data entry rules, creating queries, forms, and reports.

Credit recommendation: 
In the lower division associate/baccalaureate degree category, 2 semester hours in Computer Applications, Information Management, Information Systems, or as General Elective (8/13).

Top