Now in its Second 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 a compelling business problem and, with the help of tutorials on Microsoft Access and Excel, trains users in critical thinking and problem solving. Readers will use Microsoft Access and Excel throughout the book to work through the case material. The scenarios found in the text reflect real business situations, ranging from small, privately-owned companies to large corporations.
Part 1: Database Cases Using Access
Tutorial A: Database Design
Tutorial B: Microsoft Access Tutorial
Case 1: Preliminary Case: The Mountain-Biking Club
Case 2: The Equestrian Club
Case 3: The Yoga Class
Case 4: The Animal Rehabilitation Clinic
Case 5: The Airline Reservation System
Part 2: Decision Support Cases Using Excel Scenario Manager
Tutorial C: Building a Decision Support System in Excel
Case 6: The POURQUOI Company Advertising Campaign
Decision
Case 7: The Baseball Team Purchase Decision
Part 3: Decision Support Cases Using the Excel Solver
Tutorial D: Building a Decision Support System Using the Excel
Solver
Case 8: The Golf Course Architecture Problem
Case 9: The New Wave Mutual Fund Investment Mix Problem
Part 4: Decision Support Case Using Basic Excel Functionality
Case 10: The BigBiz Cash Budget Decision
Case 11: The Merger Exchange-Ratio Analysis
Part 5: Integration Case Using Access and Excel
Case 12: Atlantis University's Applicant-Acceptance Decision
Part 6: Presentation Skills
Tutorial E: Giving an Oral Presentation