PROBLEM-SOLVING CASES IN MICROSOFT® ACCESS® AND EXCEL®, Twelfth Annual Edition, helps you apply the Access® database management system and Excel® spreadsheet to effectively analyze and solve real-world business problems. Six individual tutorials build a practical knowledge of each software application's capabilities, while 12 all-new case studies present scenarios and problems common in business. Further, a skill-building integration feature requires readers to use Access® and Excel® together on cases, making this the most up-to-date, practical guide for these widely used software programs.
Table of Contents
Part 1: DATABASE CASES USING ACCESS.
Tutorial A: Database Design.
Tutorial B: Microsoft Access.
Case 1: Preliminary Case; The Personal Training Database.
Case 2: Rent-a-Dress Database.
Case 3: The Import Food Market Database.
Case 4: The Music Festival Database.
Case 5: City Bike Rental Database.
Part 2: DECISION SUPPORT CASES USING EXCEL SCENARIO MANAGER.
Tutorial C: Building a Decision Support System in Excel.
Case 6: New England Energy Investment Strategy Decision.
Case 7: The City Hotel Recovery Analysis.
Part 3: DECISION SUPPORT CASES USING MICROSOFT EXCEL SOLVER.
Tutorial D: Decision Support Cases Using Microsoft Excel Solver.
Case 8: Duchess Cruises Ship Assignment Problem.
Case 9: Ed and Carla's Retirement Plan.
Part 4: DECISION SUPPORT CASE USING BASIC EXCEL FUNCTIONALITY.
Case 10: The University Arena Construction Decision.
Part 5: INTEGRATION CASES USING ACCESS AND EXCEL.
Case 11: The College GPA Analysis.
Case 12: The Nonprofit Donor Analysis.
Part 6: ADVANCED SKILLS USING EXCEL.
Tutorial E: Guidance for Excel Cases.
Part 7: PRESENTATION SKILLS.
Tutorial F: Giving an Oral Presentation.