Now in its Third Annual Edition, Problem-Solving Cases in Microsoft Access and Excel helps build spreadsheet and database skills using realistic business cases and is the perfect complement to a 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.
Now in its third annual edition, this text helps build spreadsheet and database skills using realistic business cases. Each case introduces an interesting and realistic business problem and with the help of tutorials on Access and Excel, trains users in critical thinking and problem-solving using application software.
Ellen F. Monk, Joseph A. Brady
Number Of Pages
Table Of Content
Part 1: Database Cases Using Access Tutorial A: Database Design Tutorial B: Microsoft Access Tutorial Case 1: The Misty Valley Country Inn Case 2: The Outsourcing, Bookkeeping, and Payroll Company Case 3: The Orchid Seller Case 4: The Lawn Mower Repair Business Case 5: The Dream Machine Rental Company Case 6: Challenge Case: The Online Dating Service Part 2: Decision Support Cases Using Excel Scenario Manager Tutorial C: Building a Decision Support System in Excel Case 7: BigState Bank's Call Center Off-Shoring Decision Case 8: The Starr Motor Company Survival Analysis Part 3: Decision Support Cases Using the Excel Solver Tutorial D: Building a Decision Support System Using the Excel Solver Case 9: The Baseball Park Configuration Decision Case 10: Hoobah's Casino Revenue Maximization Problem Part 4: Decision Support Cases Using Basic Excel Functionality Case 11: Master Blaster Division Operating Budget Case 12: The Social Safety Fund 75-Year Budget Case 13: Challenge Case: The Warehouse Location Decision Part 5: Integration Case: Using Access and Excel Case 14: Your Uncle's Portfolio Construction Program Part 6: Presentation Skills Tutorial E: Giving an Oral Presentation