Description
CENGAGE INDIA Problem Solving Cases In Microsoft Access And Excel 12Th Edn 2015 by Gerard S. Cook ET AL
PROBLEM-SOLVING CASES IN MICROSOFT® ACCESS® AND EXCEL®, Twelfth Annual Edition, helps students apply the Access® database management system and Excel® spreadsheet to effectively analyze and solve real-world business problems. Six individual tutorials in the text 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 students to use Access® and Excel® together on cases, making this the most up-to-date, practical guide for these widely used software programs.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