Course Title: MS Excel and Access II
Title Abbreviation: MS EXCEL and ACCESS II
Department: OBT
Course #: 135
Credits: 5
Variable: No
IUs: 5
CIP: 520302
EPC: 547
REV: 2021
Course Description
Use Microsoft Excel for PCs to apply advanced formatting techniques to spreadsheets and charts, write complex formulas and use advanced functions, use What-if Analysis tools, manage and analyze worksheet data, and automate tasks with templates and macros. Use Microsoft Access for PCs to design a relational database, enhance the design of tables, use advanced query and filter techniques, and design custom forms and reports.
Prerequisite
Prerequisite: OBT 134 with a "D" or higher.
Contact Hours (based on 11 week quarter)
Lecture: 55
Lab: 0
Other: 0
Systems: 0
Clinical: 0
Intent: Distribution Requirement(s) Status:
Vocational Preparatory Required for ATA degree, Required for certificate
Equivalencies At Other Institutions
Learning Outcomes
After completing this course, the student will be able to:
General Education Learning Values & Outcomes
Revised August 2008 and affects outlines for 2008 year 1 and later.
Course Contents