Skip to main content

National College Credit Recommendation Service

Board of Regents  |  University of the State of New York

Coopersmith Career Consulting | Evaluated Learning Experience

Return to Coopersmith Career Consulting

Microsoft Access (TCH-164)

Course Category: 
Computers and Technology - Coopersmith Career Consulting
Length: 

Varies (self-study; self-paced).

Location: 
Various; distance learning format.
Dates: 
July 2013 - Present.
Instructional delivery format: 
Online/distance learning
Learner Outcomes: 

Upon successful completion of this course, students will be able to: create Access databases and populate them with 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; and 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 baccalaureate/associate degree category, 2 semester hours in Computer Applications, Information Management, Information Systems, or as a General Elective (8/13) (8/18 revalidation) (5/23 revalidation). 

Top