Packed with hands-on applications, PROBLEM-SOLVING CASES IN MICROSOFT® ACCESS and EXCEL, 13th Annual Edition, helps students apply the Access database management system and Excel spreadsheet to effectively analyze and solve real-world business problems. Six user-friendly tutorials in the text build practical knowledge as they walk students step-by-step through each software application's capabilities, while 12 all-new case studies present scenarios and problems common in real-life practice. There is a wealth of instructor resources provided online. In addition, 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.
Table of Contents
PART I: DATABASE CASES USING ACCESS.
Tutorial A: Database Design.
Tutorial B: Microsoft Access.
Part II: DECISION SUPPORT CASES USING EXCEL SCENARIO MANAGER.
Tutorial C: Building a Decision Support System in Excel.
PART III: DECISION SUPPORT CASES USING MICROSOFT EXCEL SOLVER.
PART IV: DECISION SUPPORT CASE USING BASIC EXCEL FUNCTIONALITY.
PART V: INTEGRATION CASES USING ACCESS AND EXCEL.
PART VI: ADVANCED SKILLS USING EXCEL.
Tutorial E: Guidance for Excel Cases.
PART VII: PRESENTATION SKILLS.
Tutorial F: Giving an Oral Presentation.