Learn how to analyze and successfully solve today's real business problems using the latest Microsoft® Office Access database management system and the most recent version of Excel spreadsheet tools. Packed with hands-on learning opportunities, Monk/Brady/Mendelsohn's PROBLEM-SOLVING CASES IN MICROSOFT® ACCESS AND EXCEL, 16E features five individual tutorials designed to build your practical knowledge as you walk step-by-step through the capabilities of each software application. Twelve all-new case studies challenge you to use the software applications to resolve scenarios and problems you are likely to encounter on the job. In addition, a unique emphasis on skill-building integration demonstrates how to use Access and Excel together to resolve challenges within each case. Trust today's most up-to-date, practical guide for mastering critical Access and Excel skills in a business context.
Part I: DATABASE CASES USING ACCESS.
Tutorial A. Database Design.
Tutorial B. Microsoft Access.
Case 1. Preliminary Case: Dog Hikes.
Case 2. The Parks and Recreation Database.
Case 3. The Senior Concierge Database.
Case 4. The Fresh Fish Database.
Case 5. The Volunteer Fire Company Database
Part II: DECISION SUPPORT CASES USING MICROSOFT EXCEL SCENARIO MANAGER.
Tutorial C. Building a Decision Support Systems in Excel.
Case 6. The Ski Resort Investment Decision.
Case 7. The College Town Budget.
Part III: DECISION SUPPORT CASES USING MICROSOFT EXCEL SOLVER.
Tutorial D. Building a Decision Support System Using Microsoft Excel Solver.
Case 8. Rose Tree Regional Airline.
Case 9. The Auto Maker Product Mix Problem.
Part IV: DECISION SUPPORT CASE USING BASIC ACCESS AND EXCEL FUNCTIONALITY.
Case 10. The Donation Letter Analysis.
Part V: INTEGRATION CASES USING MICROSOFT ACCESS AND EXCEL.
Case 11. San Francisco Fire Incidents.
Case 12. San Francisco Fire Incidents: Advanced Analysis.
Part VI: ADVANCED SKILLS USING EXCEL.
Tutorial E. Guidance for Excel Cases.
