Skip to main content
National College Credit Recommendation Service
Coopersmith Career Consulting | Evaluated Learning Experience
Microsoft Access (TCH-164)
Various; distance learning format.
Varies (self-study; self-paced).
Instructional delivery format:
Upon successful completion of this proficiency exam, 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.
This self-study proficiency exam 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.
In the lower division baccalaureate/associate degree category, 2 semester hours in Computer Applications, Information Management, Information Systems, or as General Elective (8/13) (8/18 revalidation).