CAP 230 - Database Applications
3 Credits (PREREQUISITE: CAP 110 OR DEPARTMENTAL PERMISSION)
In this course, students will develop expertise using spreadsheets and databases to prepare to take the Microsoft Office Specialist Certification exam for Excel. In addition to reviewing basic Excel skills, students will learn how to apply advanced formulas and functions, create PivotTables, manage large worksheets and analyze data to solve business or scientific problems. Students will also learn how to manage an Access database table, create forms, run queries and design reports. Students will practice using Microsoft Office 2010 efficiently by integrating data from Word, PowerPoint, Access and Excel to create integrated business documents. CS cl (F, Sp, Su)