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.
|Product dimensions:||10.60(w) x 8.40(h) x 0.70(d)|
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.