Microsoft Access and Excel

Part 1: Database Cases Using Access - Page 15
Part 1: Database Cases Using Access - Page 16
Tutorial A: Database Design - Page 17
DATABASE DESIGN - Page 18
DATABASE DESIGN RULES - Page 19
DATABASE DESIGN RULES - Page 20
DATABASE DESIGN RULES - Page 21
DATABASE DESIGN RULES - Page 22
DATABASE DESIGN RULES - Page 23
DATABASE DESIGN RULES - Page 24
PRACTICE DATABASE DESIGN PROBLEM - Page 25
PRACTICE DATABASE DESIGN PROBLEM - Page 26
Tutorial B: Microsoft Access Tutorial - Page 27
Tutorial B: Microsoft Access Tutorial - Page 28
Tutorial B: Microsoft Access Tutorial - Page 29
Tutorial B: Microsoft Access Tutorial - Page 30
CREATING QUERIES - Page 31
CREATING QUERIES - Page 32
CREATING QUERIES - Page 33
CREATING QUERIES - Page 34
CREATING QUERIES - Page 35
CREATING QUERIES - Page 36
CREATING QUERIES - Page 37
CREATING QUERIES - Page 38
CREATING QUERIES - Page 39
CREATING QUERIES - Page 40
CREATING QUERIES - Page 41
CREATING QUERIES - Page 42
CREATING QUERIES - Page 43
CREATING QUERIES - Page 44
CREATING QUERIES - Page 45
CREATING QUERIES - Page 46
MAKING SEVEN PRACTICE QUERIES - Page 47
MAKING SEVEN PRACTICE QUERIES - Page 48
MAKING SEVEN PRACTICE QUERIES - Page 49
MAKING SEVEN PRACTICE QUERIES - Page 50
CREATING REPORTS - Page 51
CREATING REPORTS - Page 52
CREATING REPORTS - Page 53
CREATING REPORTS - Page 54
CREATING REPORTS - Page 55
CREATING REPORTS - Page 56
IMPORTING DATA - Page 57
IMPORTING DATA - Page 58
IMPORTING DATA - Page 59
MAKING FORMS - Page 60
MAKING FORMS - Page 61
TROUBLESHOOTING COMMON PROBLEMS - Page 62
TROUBLESHOOTING COMMON PROBLEMS - Page 63
TROUBLESHOOTING COMMON PROBLEMS - Page 64
Case 1: Preliminary Case: Veggie Box Delivery - Page 65
ASSIGNMENT 1: CREATING TABLES - Page 66
ASSIGNMENT 2: CREATING A FORM, QUERIES, AND A REPORT - Page 67
ASSIGNMENT 2: CREATING A FORM, QUERIES, AND A REPORT - Page 68
DELIVERABLES - Page 69
Case 2: Internet Jets Reservation System Database - Page 70
ASSIGNMENT 1: CREATING THE DATABASE DESIGN - Page 71
ASSIGNMENT 2: CREATING THE DATABASE, QUERIES, AND REPORT - Page 72
ASSIGNMENT 2: CREATING THE DATABASE, QUERIES, AND REPORT - Page 73
ASSIGNMENT 2: CREATING THE DATABASE, QUERIES, AND REPORT - Page 74
ASSIGNMENT 3: MAKING A PRESENTATION - Page 75
Case 3: The Intramural Sports Database - Page 76
ASSIGNMENT 1: CREATING THE DATABASE DESIGN - Page 77
ASSIGNMENT 2: CREATING THE DATABASE, QUERIES, AND REPORT - Page 78
ASSIGNMENT 2: CREATING THE DATABASE, QUERIES, AND REPORT - Page 79
ASSIGNMENT 2: CREATING THE DATABASE, QUERIES, AND REPORT - Page 80
ASSIGNMENT 3: MAKING A PRESENTATION - Page 81
Case 4: T-Shirts etc. Order Database - Page 82
ASSIGNMENT 1: CREATING THE DATABASE DESIGN - Page 83
ASSIGNMENT 1: CREATING THE DATABASE DESIGN - Page 84
ASSIGNMENT 1: CREATING THE DATABASE DESIGN - Page 85
ASSIGNMENT 1: CREATING THE DATABASE DESIGN - Page 86
ASSIGNMENT 3: MAKING A PRESENTATION - Page 87
Case 5: The Precious Metal Depository Database - Page 88
ASSIGNMENT 1: CREATING THE DATABASE DESIGN - Page 89
ASSIGNMENT 2: CREATING THE DATABASE, QUERIES, AND REPORTS - Page 90
ASSIGNMENT 2: CREATING THE DATABASE, QUERIES, AND REPORTS - Page 91
ASSIGNMENT 2: CREATING THE DATABASE, QUERIES, AND REPORTS - Page 92
ASSIGNMENT 2: CREATING THE DATABASE, QUERIES, AND REPORTS - Page 93
ASSIGNMENT 2: CREATING THE DATABASE, QUERIES, AND REPORTS - Page 94
ASSIGNMENT 2: CREATING THE DATABASE, QUERIES, AND REPORTS - Page 95
ASSIGNMENT 2: CREATING THE DATABASE, QUERIES, AND REPORTS - Page 96
ASSIGNMENT 3: MAKING A PRESENTATION - Page 97
ASSIGNMENT 3: MAKING A PRESENTATION - Page 98
Part 2: Decision Support Cases Using Excel Scenario Manager - Page 99
Part 2: Decision Support Cases Using Excel Scenario Manager - Page 100
Tutorial C: Building a Decision Support System in Excel - Page 101
Tutorial C: Building a Decision Support System in Excel - Page 102
Tutorial C: Building a Decision Support System in Excel - Page 103
Tutorial C: Building a Decision Support System in Excel - Page 104
Tutorial C: Building a Decision Support System in Excel - Page 105
Tutorial C: Building a Decision Support System in Excel - Page 106
Tutorial C: Building a Decision Support System in Excel - Page 107
Tutorial C: Building a Decision Support System in Excel - Page 108
Tutorial C: Building a Decision Support System in Excel - Page 109
Tutorial C: Building a Decision Support System in Excel - Page 110
Tutorial C: Building a Decision Support System in Excel - Page 111
Tutorial C: Building a Decision Support System in Excel - Page 112
Tutorial C: Building a Decision Support System in Excel - Page 113
Tutorial C: Building a Decision Support System in Excel - Page 114
Tutorial C: Building a Decision Support System in Excel - Page 115
Tutorial C: Building a Decision Support System in Excel - Page 116
SCENARIO MANAGER - Page 117
SCENARIO MANAGER - Page 118
SCENARIO MANAGER - Page 119
SCENARIO MANAGER - Page 120
SCENARIO MANAGER - Page 121
SCENARIO MANAGER - Page 122
SCENARIO MANAGER - Page 123
PRACTICE EXERCISE—TED AND ALICE'S HOUSE PURCHASE DECISION - Page 124
PRACTICE EXERCISE—TED AND ALICE'S HOUSE PURCHASE DECISION - Page 125
PRACTICE EXERCISE—TED AND ALICE'S HOUSE PURCHASE DECISION - Page 126
PRACTICE EXERCISE—TED AND ALICE'S HOUSE PURCHASE DECISION - Page 127
REVIEW OF EXCEL BASICS - Page 128
REVIEW OF EXCEL BASICS - Page 129
REVIEW OF EXCEL BASICS - Page 130
REVIEW OF EXCEL BASICS - Page 131
REVIEW OF EXCEL BASICS - Page 132
REVIEW OF EXCEL BASICS - Page 133
REVIEW OF EXCEL BASICS - Page 134
REVIEW OF EXCEL BASICS - Page 135
REVIEW OF EXCEL BASICS - Page 136
REVIEW OF EXCEL BASICS - Page 137
Case 6: Future Cars Inc. Product Strategy Decision - Page 138
ASSIGNMENT 1: CREATING A SPREADSHEET FOR DECISION SUPPORT - Page 139
ASSIGNMENT 1: CREATING A SPREADSHEET FOR DECISION SUPPORT - Page 140
ASSIGNMENT 1: CREATING A SPREADSHEET FOR DECISION SUPPORT - Page 141
ASSIGNMENT 1: CREATING A SPREADSHEET FOR DECISION SUPPORT - Page 142
ASSIGNMENT 1: CREATING A SPREADSHEET FOR DECISION SUPPORT - Page 143
ASSIGNMENT 1: CREATING A SPREADSHEET FOR DECISION SUPPORT - Page 144
ASSIGNMENT 1: CREATING A SPREADSHEET FOR DECISION SUPPORT - Page 145
ASSIGNMENT 2: USING THE SPREADSHEET FOR DECISION SUPPORT - Page 146
ASSIGNMENT 3: GIVING A PRESENTATION WITH SLIDES - Page 147
Case 7: The Health Care Coverage Decision at Big Dog Collars - Page 148
ASSIGNMENT 1: CREATING A SPREADSHEET FOR DECISION SUPPORT - Page 149
ASSIGNMENT 1: CREATING A SPREADSHEET FOR DECISION SUPPORT - Page 150
ASSIGNMENT 1: CREATING A SPREADSHEET FOR DECISION SUPPORT - Page 151
ASSIGNMENT 1: CREATING A SPREADSHEET FOR DECISION SUPPORT - Page 152
ASSIGNMENT 1: CREATING A SPREADSHEET FOR DECISION SUPPORT - Page 153
ASSIGNMENT 2: USING THE SPREADSHEET FOR DECISION SUPPORT - Page 154
ASSIGNMENT 3: GIVING AN ORAL PRESENTATION - Page 155
ASSIGNMENT 3: GIVING AN ORAL PRESENTATION - Page 156
Part 3: Decision Support Cases Using the Excel Solver - Page 157
Part 3: Decision Support Cases Using the Excel Solver - Page 158
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
USING EXCEL SOLVER - Page 162
USING EXCEL SOLVER - Page 163
USING EXCEL SOLVER - Page 164
USING EXCEL SOLVER - Page 165
USING EXCEL SOLVER - Page 166
USING EXCEL SOLVER - Page 167
USING EXCEL SOLVER - Page 168
USING EXCEL SOLVER - Page 169
USING EXCEL SOLVER - Page 170
USING EXCEL SOLVER - Page 171
USING EXCEL SOLVER - Page 172
USING EXCEL SOLVER - Page 173
USING EXCEL SOLVER - Page 174
USING EXCEL SOLVER - Page 175
USING EXCEL SOLVER - Page 176
EXTENDING THE EXAMPLE - Page 177
EXTENDING THE EXAMPLE - Page 178
EXTENDING THE EXAMPLE - Page 179
EXTENDING THE EXAMPLE - Page 180
EXTENDING THE EXAMPLE - Page 181
EXTENDING THE EXAMPLE - Page 182
EXTENDING THE EXAMPLE - Page 183
EXTENDING THE EXAMPLE - Page 184
USING SOLVER ON A NEW PROBLEM - Page 185
USING SOLVER ON A NEW PROBLEM - Page 186
USING SOLVER ON A NEW PROBLEM - Page 187
USING SOLVER ON A NEW PROBLEM - Page 188
TROUBLESHOOTING SOLVER - Page 189
TROUBLESHOOTING SOLVER - Page 190
TROUBLESHOOTING SOLVER - Page 191
TROUBLESHOOTING SOLVER - Page 192
TROUBLESHOOTING SOLVER - Page 193
TROUBLESHOOTING SOLVER - Page 194
Case 8: Kuhlman’s Department Store Media Problem - Page 195
Case 8: Kuhlman’s Department Store Media Problem - Page 196
ASSIGNMENT 1: CREATING A SPREADSHEET FOR DECISION SUPPORT - Page 197
ASSIGNMENT 1: CREATING A SPREADSHEET FOR DECISION SUPPORT - Page 198
ASSIGNMENT 1: CREATING A SPREADSHEET FOR DECISION SUPPORT - Page 199
ASSIGNMENT 1: CREATING A SPREADSHEET FOR DECISION SUPPORT - Page 200
ASSIGNMENT 1: CREATING A SPREADSHEET FOR DECISION SUPPORT - Page 201
ASSIGNMENT 1: CREATING A SPREADSHEET FOR DECISION SUPPORT - Page 202
ASSIGNMENT 2: USING THE WORKBOOK FOR DECISION SUPPORT - Page 203
ASSIGNMENT 2: USING THE WORKBOOK FOR DECISION SUPPORT - Page 204
ASSIGNMENT 3: GIVING AN ORAL PRESENTATION - Page 205
DELIVERABLES - Page 206
Case 9: Green Jeans, LLC Sales and Operations Plan - Page 207
ASSIGNMENT 1: CREATING A SPREADSHEET FOR DECISION SUPPORT - Page 208
ASSIGNMENT 1: CREATING A SPREADSHEET FOR DECISION SUPPORT - Page 209
ASSIGNMENT 1: CREATING A SPREADSHEET FOR DECISION SUPPORT - Page 210
ASSIGNMENT 1: CREATING A SPREADSHEET FOR DECISION SUPPORT - Page 211
ASSIGNMENT 1: CREATING A SPREADSHEET FOR DECISION SUPPORT - Page 212
ASSIGNMENT 1: CREATING A SPREADSHEET FOR DECISION SUPPORT - Page 213
ASSIGNMENT 1: CREATING A SPREADSHEET FOR DECISION SUPPORT - Page 214
ASSIGNMENT 1: CREATING A SPREADSHEET FOR DECISION SUPPORT - Page 215
ASSIGNMENT 1: CREATING A SPREADSHEET FOR DECISION SUPPORT - Page 216
ASSIGNMENT 2: USING THE WORKBOOK FOR DECISION SUPPORT - Page 217
ASSIGNMENT 3: GIVING AN ORAL PRESENTATION - Page 218
DELIVERABLES - Page 219
DELIVERABLES - Page 220
Part 4: Decision Support Case Using Basic Excel Functionality - Page 221
Part 4: Decision Support Case Using Basic Excel Functionality - Page 222
Case 10: The College Return on Investment Analysis - Page 223
ASSIGNMENT 1: CREATING A SPREADSHEET FOR DECISION SUPPORT - Page 224
ASSIGNMENT 1: CREATING A SPREADSHEET FOR DECISION SUPPORT - Page 225
ASSIGNMENT 1: CREATING A SPREADSHEET FOR DECISION SUPPORT - Page 226
ASSIGNMENT 1: CREATING A SPREADSHEET FOR DECISION SUPPORT - Page 227
ASSIGNMENT 2: USING THE SPREADSHEET FOR DECISION SUPPORT - Page 228
ASSIGNMENT 2: USING THE SPREADSHEET FOR DECISION SUPPORT - Page 229
ASSIGNMENT 2: USING THE SPREADSHEET FOR DECISION SUPPORT - Page 230
ASSIGNMENT 2: USING THE SPREADSHEET FOR DECISION SUPPORT - Page 231
ASSIGNMENT 3: GIVING AN ORAL PRESENTATION - Page 232
Part 5: Integration Cases Using Access and Excel - Page 233
Part 5: Integration Cases Using Access and Excel - Page 234
Case 11: The Baseball Offensive Performance Analysis - Page 235
Case 11: The Baseball Offensive Performance Analysis - Page 236
ASSIGNMENT 1: MAKING QUERIES IN ACCESS - Page 237
ASSIGNMENT 2: USING EXCEL FOR DECISION SUPPORT - Page 238
ASSIGNMENT 2: USING EXCEL FOR DECISION SUPPORT - Page 239
ASSIGNMENT 2: USING EXCEL FOR DECISION SUPPORT - Page 240
ASSIGNMENT 3: DOCUMENTING FINDINGS IN A MEMORANDUM - Page 241
Case 12: The Brewery Index Calculation - Page 242
Case 12: The Brewery Index Calculation - Page 243
Case 12: The Brewery Index Calculation - Page 244
ASSIGNMENT 1: MAKING QUERIES IN ACCESS - Page 245
ASSIGNMENT 2: USING EXCEL FOR DECISION SUPPORT - Page 246
ASSIGNMENT 2: USING EXCEL FOR DECISION SUPPORT - Page 247
ASSIGNMENT 3: DOCUMENTING FINDINGS IN A MEMORANDUM - Page 248
Part 6: Advanced Skills Using Excel - Page 249
Part 6: Advanced Skills Using Excel - Page 250
Tutorial E: Guidance for Excel Cases - Page 251
Tutorial E: Guidance for Excel Cases - Page 252
Tutorial E: Guidance for Excel Cases - Page 253
Tutorial E: Guidance for Excel Cases - Page 254
Tutorial E: Guidance for Excel Cases - Page 255
PIVOT TABLES - Page 256
PIVOT TABLES - Page 257
BUILT-IN FUNCTIONS - Page 258
BUILT-IN FUNCTIONS - Page 259
BUILT-IN FUNCTIONS - Page 260
BUILT-IN FUNCTIONS - Page 261
BUILT-IN FUNCTIONS - Page 262
BUILT-IN FUNCTIONS - Page 263
BUILT-IN FUNCTIONS - Page 264
Part 7: Presentation Skills - Page 265
Part 7: Presentation Skills - Page 266
Tutorial F: Giving an Oral Presentation - Page 267
DRAFTING YOUR REPORT AND PRESENTATION - Page 268
DRAFTING YOUR REPORT AND PRESENTATION - Page 269
CREATING GRAPHICS - Page 270
CREATING GRAPHICS - Page 271
CREATING GRAPHICS - Page 272
CREATING GRAPHICS - Page 273
CREATING GRAPHICS - Page 274
CREATING GRAPHICS - Page 275
CREATING GRAPHICS - Page 276
CREATING GRAPHICS - Page 277
CREATING GRAPHICS - Page 278
CREATING GRAPHICS - Page 279
CREATING GRAPHICS - Page 280
PRACTICING YOUR DELIVERY - Page 281
PRACTICING YOUR DELIVERY - Page 282
PRESENTATION TOOLKIT - Page 283
PRESENTATION TOOLKIT - Page 284
PRESENTATION TOOLKIT - Page 285