Problem Solving Cases in Microsoft Access and Excel

Cover......Page 1
Title Page......Page 5
Copyright......Page 6
Brief Contents......Page 9
BOOK ORGANIZATION......Page 11
TECHNICAL INFORMATION......Page 13
ACKNOWLEDGEMENTS......Page 14
Part 1: Database Cases Using Access......Page 15
REVIEW OF TERMINOLOGY......Page 17
DATABASE DESIGN......Page 18
DATABASE DESIGN RULES......Page 19
PRACTICE DATABASE DESIGN PROBLEM......Page 25
CREATING TABLES......Page 27
CREATING QUERIES......Page 31
MAKING SEVEN PRACTICE QUERIES......Page 47
CREATING REPORTS......Page 51
IMPORTING DATA......Page 57
MAKING FORMS......Page 60
TROUBLESHOOTING COMMON PROBLEMS......Page 62
BACKGROUND......Page 65
ASSIGNMENT 1: CREATING TABLES......Page 66
ASSIGNMENT 2: CREATING A FORM, QUERIES, AND A REPORT......Page 67
DELIVERABLES......Page 69
BACKGROUND......Page 70
ASSIGNMENT 1: CREATING THE DATABASE DESIGN......Page 71
ASSIGNMENT 2: CREATING THE DATABASE, QUERIES, AND REPORT......Page 72
DELIVERABLES......Page 75
BACKGROUND......Page 76
ASSIGNMENT 1: CREATING THE DATABASE DESIGN......Page 77
ASSIGNMENT 2: CREATING THE DATABASE, QUERIES, AND REPORT......Page 78
DELIVERABLES......Page 81
BACKGROUND......Page 82
ASSIGNMENT 2: CREATING THE DATABASE, QUERIES, AND REPORT......Page 83
DELIVERABLES......Page 87
BACKGROUND......Page 88
ASSIGNMENT 1: CREATING THE DATABASE DESIGN......Page 89
ASSIGNMENT 2: CREATING THE DATABASE, QUERIES, AND REPORTS......Page 90
DELIVERABLES......Page 97
Part 2: Decision Support Cases Using Excel Scenario Manager......Page 99
SPREADSHEET AND DSS BASICS......Page 101
SCENARIO MANAGER......Page 117
PRACTICE EXERCISE—TED AND ALICE'S HOUSE PURCHASE DECISION......Page 124
REVIEW OF EXCEL BASICS......Page 128
BACKGROUND......Page 138
ASSIGNMENT 1: CREATING A SPREADSHEET FOR DECISION SUPPORT......Page 139
ASSIGNMENT 2: USING THE SPREADSHEET FOR DECISION SUPPORT......Page 146
DELIVERABLES......Page 147
BACKGROUND......Page 148
ASSIGNMENT 1: CREATING A SPREADSHEET FOR DECISION SUPPORT......Page 149
ASSIGNMENT 2: USING THE SPREADSHEET FOR DECISION SUPPORT......Page 154
DELIVERABLES......Page 155
Part 3: Decision Support Cases Using the Excel Solver......Page 157
Tutorial D: Building a Decision Support System Using Excel Solver......Page 159
ADDING EXCEL SOLVER TO THE EXCEL RIBBON......Page 160
USING EXCEL SOLVER......Page 161
EXTENDING THE EXAMPLE......Page 177
USING SOLVER ON A NEW PROBLEM......Page 185
TROUBLESHOOTING SOLVER......Page 189
BACKGROUND......Page 195
ASSIGNMENT 1: CREATING A SPREADSHEET FOR DECISION SUPPORT......Page 197
ASSIGNMENT 2: USING THE WORKBOOK FOR DECISION SUPPORT......Page 203
ASSIGNMENT 3: GIVING AN ORAL PRESENTATION......Page 205
DELIVERABLES......Page 206
BACKGROUND......Page 207
ASSIGNMENT 1: CREATING A SPREADSHEET FOR DECISION SUPPORT......Page 208
ASSIGNMENT 2: USING THE WORKBOOK FOR DECISION SUPPORT......Page 217
ASSIGNMENT 3: GIVING AN ORAL PRESENTATION......Page 218
DELIVERABLES......Page 219
Part 4: Decision Support Case Using Basic Excel Functionality......Page 221
BACKGROUND......Page 223
ASSIGNMENT 1: CREATING A SPREADSHEET FOR DECISION SUPPORT......Page 224
ASSIGNMENT 2: USING THE SPREADSHEET FOR DECISION SUPPORT......Page 228
DELIVERABLES......Page 232
Part 5: Integration Cases Using Access and Excel......Page 233
BACKGROUND......Page 235
ASSIGNMENT 1: MAKING QUERIES IN ACCESS......Page 237
ASSIGNMENT 2: USING EXCEL FOR DECISION SUPPORT......Page 238
DELIVERABLES......Page 241
BACKGROUND......Page 242
ASSIGNMENT 1: MAKING QUERIES IN ACCESS......Page 245
ASSIGNMENT 2: USING EXCEL FOR DECISION SUPPORT......Page 246
DELIVERABLES......Page 248
Part 6: Advanced Skills Using Excel......Page 249
DATA TABLES......Page 251
PIVOT TABLES......Page 256
BUILT-IN FUNCTIONS......Page 258
Part 7: Presentation Skills......Page 265
PLANNING YOUR PRESENTATION......Page 267
DRAFTING YOUR REPORT AND PRESENTATION......Page 268
CREATING GRAPHICS......Page 270
PRACTICING YOUR DELIVERY......Page 281
PRESENTATION TOOLKIT......Page 283
Index......Page 286