Microsoft Access

Microsoft Access (TCH-164)
Location:
Various: distance learning format

Length:
Varies (self-study; self-paced)

Dates:
July 2013 - Present.

Subject Area:
Computers and Information Technology

Number of Credits:
2

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.

Instructions:
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 General Elective (8/13)(8/18 revalidation).