OST 2853 - Spreadsheet and Database Management OST 2853 - Spreadsheet and Database Management You will learn to use Excel to manage finances, as well as to work with formulas, charts and graphics, and to develop a professional worksheet. You will work with logical functions and integrate Excel with other Windows Programs. You will learn about data tables and scenario management, how to use pivot tables. We will cover the five Access object types (tables, queries, forms, reports, and pages) at a deeper level then in CGS1101. You will learn to use Access to plan and create databases, which includes using, and designing tables, queries, forms, and reports. You will also work with data import and export features as well as data access pages, relational database concepts, build and modify table relationships. Parallel: College Transfer (A.A. and A.S)
Prerequisites: CGS2100, CGS1000