MIS Cases: Solving Small Business Scenarios Using Application Software, 2nd Edition

Index

3–Dimensional workbook

Design principles, 103, 104

Group and ungroup worksheets, 101–102, 104, 111–112, 116–117, 119

see also Formulas

C

Charts, spreadsheet, 81, 88, 94, 106, 113, 120

D

Data mining, 1

Database application development, 1

Analysis phase, 1

Input requirements, 1, 4, 11, 17, 25, 34, 41, 48, 56, 63, 70

Output requirements, 1, 4, 10, 16, 25, 34, 41, 48, 56, 63, 70

Design phase, 1

Implementation phase, 1

Data table, spreadsheet, 125, 127, 132, 134, 139–140

Data validation, spreadsheet, 126, 132, 134, 138–140

see also What-if analysis

Design principles and guidelines, database

Input forms, 6, 13, 20

Queries, 25, 34, 41, 49, 57, 64, 74

Reports, 24, 28, 36, 43, 52, 59, 67, 72, 75

Tables, 5, 11, 17, 48, 56, 63, 71

Design principles and guidelines, spreadsheet

Assumptions (parameters) area, 101, 103, 104, 131, 143, 144

Documentation, 82, 83, 89, 94, 103, 109, 117, 125, 127, 134, 139

Input area, 83, 90, 94, 104, 115, 118, 126, 127, 134, 140

Output (layout) area, 82, 84, 100, 110, 118–119,

Processing area (formulas), 85, 90, 94, 112, 119, 126, 127, 134, 140

Reports (layout), 109–111, 119

Design principles and guidelines, website

Content organization, 147–148, 152

Navigation, 147, 149, 152, 155

Webpage hierarchy, 148

Webpage layout, 147, 151

F

Formula audit, spreadsheet, 126, 127, 134, 140

Formulas, spreadsheet

3-Dimensional formula, 105, 112, 115

Cell addressing (relative ...