CIA 170 - Access

Number of Credits: 3
Create, manage, and search databases; design forms; create queries; produce and format reports; and apply concepts of database software using the Microsoft Access software package. This course prepares students to complete the MOS Microsoft Access 2019 Expert Certification exam which is completed as the final exam. Certification is not guaranteed. An additional $80 fee is required. Basic technology skills are recommended. (Formerly offered as OFFC-170; credit will not be awarded for both). (Fall term) Three hours lecture. Three Credits. Three billable hours.

Pre-requisite(s): exemption/completion of ENG 001.
Course Objectives: Upon successful completion of this course, students will be able to:
1. Manage databases using Microsoft Access software. Specific
skills include modify database structure, manage table
relationships and keys, print and export data. (PG1, PG2)
2. Create and modify tables using Microsoft Access software.
Specific skills include create and manage tables and table
records and create and modify fields. (PG1, PG2)
3. Create and modify queries using Microsoft Access software.
Specific skills include create, modify and run queries. (PG1,
PG2)
4. Modify forms using Microsoft Access software. Specific skills
include configure form controls and format forms. (PG1, PG2)
5. Modify reports using Microsoft Access software. Specific
skills include configure report controls and format reports.
(PG1, PG2)