The most up-to-date, practical guide for these popular software programs, PROBLEM-SOLVING CASES IN MICROSOFT® ACCESS AND EXCEL, 13th Annual Edition, helps you effectively apply the Access database management system and Excel spreadsheet to analyze and solve real-world business problems. Six user-friendly tutorials build your practical knowledge of each software application's capabilities, while 12 all-new case studies present scenarios and problems common in today's business practice. In addition, a skill-building integration feature enables you to use Access and Excel together on cases—equipping you with skills you can immediately apply on the job.
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.