Problem-Solving Cases in Microsoft Access and Excel, Fourth Annual Edition / Edition 4
by Ellen Monk, Joseph Brady
Now in its Fourth Annual Edition, Problem-Solving Cases in Microsoft Access and Excel helps build spreadsheet and database skills using brand new realistic business cases and is the perfect complement to any computer literacy or MIS course. Each case introduces an interesting and realistic business problem and, with the help of tutorials on Microsoft Access and
… See more details belowOverview
Now in its Fourth Annual Edition, Problem-Solving Cases in Microsoft Access and Excel helps build spreadsheet and database skills using brand new realistic business cases and is the perfect complement to any computer literacy or MIS course. Each case introduces an interesting and realistic business problem and, with the help of tutorials on Microsoft Access and Excel, trains users in critical thinking and problem solving using application software. The new scenarios added to this edition reflect real business situations, ranging from small, privately-owned companies to large corporations.
Product Details
- ISBN-13:
- 9781418837068
- Publisher:
- Cengage Learning
- Publication date:
- 01/18/2006
- Edition description:
- Older Edition
- Pages:
- 272
- Product dimensions:
- 8.50(w) x 10.90(h) x 0.80(d)
Table of Contents
Preface | ||
Pt. 1 | Database Cases Using Access | |
Tutorial A | Database Design | 2 |
Tutorial B | Microsoft Access | 13 |
Case 1 | Preliminary Case: The Cafeteria Paper Products Business | 55 |
Case 2 | The Sailboat Rental Business | 60 |
Case 3 | The Adult Education Program | 65 |
Case 4 | The Plant Nursery | 72 |
Case 5 | The Stock Portfolio | 81 |
Pt. 2 | Decision Support Cases Using Excel Scenario Manager | |
Tutorial C | Building a Decision Support System in Excel | 87 |
Case 6 | Preliminary Case: King Pictures' Movie-Pricing Decision | 113 |
Case 7 | The Aphrodite Shoe Company Manufacturing and Marketing Decision | 122 |
Pt. 3 | Decision Support Cases Using Excel Solver | |
Tutorial D | Building a Decision Support System Using Excel's Solver | 137 |
Case 8 | The Product Mix at Bernie's Restaurant | 158 |
Case 9 | The University Curriculum Design Problem | 167 |
Pt. 4 | Decision Support Case: Without Scenario Manager or Solver | |
Case 10 | The Mega Corporation's ERP Decision | 178 |
Pt. 5 | Integration Case: Using Excel and Access | |
Case 11 | NanoHexamics' Marketing Analysis | 193 |
Pt. 6 | Presentation Skills | |
Tutorial E | Giving an Oral Presentation | 205 |
Customer Reviews
Average Review: