Problem-Solving Cases in Microsoft Access and Excel, Fourth Annual Edition

by Monk, Ellen; Brady, Joseph

• ISBN13: 9781418837068
• ISBN10: 1418837067
• Edition: 4th
• Format: Paperback
• Copyright: 2006-01-18
• Publisher: Course Technology

Summary

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.

Table of Contents

Preface	iv
PART 1 Database Cases Using Access
Tutorial A Database Design	2	(11)
Tutorial B Microsoft Access Tutorial	13	(97)
Case 1 Preliminary Case: The Fitness Club	61	(8)
Case 2 The Flying Club	69	(7)
Case 3 Country Kitchen Classics Database	76	(10)
Case 4 The Modeling Agency Database	86	(10)
Case 5 The Ambulance Service Database	96	(14)
PART 2 Decision Support Cases Using Excel Scenario Manager
Tutorial C Building a Decision Support System in Excel	110	(49)
Case 6 Eastern Coffee's Labor Negotiations Budget	136	(9)
Case 7 Freedom National Bank's Buyout Decision	145	(14)
PART 3 Decision Support Cases Using the Excel Solver
Tutorial D Building a Decision Support System Using the Excel Solver	159	(70)
Case 8 The Public TV Fundraising Decision	181	(8)
Case 9 The Condominium Development Decision	189	(12)
PART 4 Decision Support Cases Using Basic Excel Functionality
Case 10 Wonderful Software's Pension Plan Decision	201	(12)
PART 5 Integration Case: Using Access and Excel
Case 11 The Stock Portfolio Restructuring	213	(16)
PART 6 Presentation Skills
Tutorial E Giving an Oral Presentation	229	(21)
Index	250