PROBLEM-SOLVING CASES IN MICROSOFT® ACCESS® AND EXCEL®, Eleventh 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 twelve 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.
Instructor support materials can be found in the Instructor Downloads section of www.cengage.com/coursetechnology, and are accessible by Single-Sign On (SSO) username and password. Designed to facilitate classroom instruction, these resources include six new Hall of Fame cases, along with new solution files, syllabus, and Student Data Files.
Table of Contents
PART 1: DATABASE CASES USING ACCESS.
Tutorial A: Database Design.
Tutorial B: Microsoft Access.
Case 1: Preliminary Case: The Outdoor Club.
Case 2: Ties To Go Database.
Case 3: Sweet Snacks Database.
Case 4: The Organic Farm Database.
Case 5: Creative Cakes Database.
PART 2: DECISION SUPPORT CASES USING EXCEL SCENARIO MANAGER.
Tutorial C: Building a Decision Support System in Excel.
Case 6: Crystal Lake Park Expansion Strategy Decision.
Case 7: The Postal Service Analysis.
PART 3: DECISION SUPPORT CASES USING MICROSOFT EXCEL SOLVER.
Tutorial D: Building a Decision Support System Using Microsoft Excel Solver.
Case 8: Global Electronics Assignment Problem.
Case 9: Appliance World Warehouse Inventory Management.
PART 4: DECISION SUPPORT CASE USING BASIC EXCEL FUNCTIONALITY.
Case 10: The Social Safety Net Analysis.
PART 5: INTEGRATION CASES USING ACCESS AND EXCEL.
Case 11: The Golf Pro Effectiveness Analysis.
Case 12: The State Lottery Analysis.
PART 6: ADVANCED SKILLS USING EXCEL.
Tutorial E: Guidance for Excel Cases.
PART 7: PRESENTATION SKILLS.
Tutorial F: Giving an Oral Presentation.