Problem-solving Cases In Microsoft Access And Excel

This book is a guide to using Microsoft Access and Excel to solve business problems. It covers six different tutorials, each of which builds on the previous one. There are twelve all-new case studies, each of which presents a real-world business problem and a solution using either Access or Excel. The book also includes a skill-building integration feature that requires readers to use Access and Excel together on cases.

Problem-Solving Cases In Microsoft[Registered] Access[Registered] And Excel[registered], 11E, International Edition helps you apply the Access[registered] database management system and Excel[registered] spreadsheet to effectively analyze and solve real-world, business problems. Six individual tutorials 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 readers to use Access[registered] and Excel[registered] together on cases, making this the most up-to-date, practical guide for these widely used software programs.
Review:
PART I. DATABASE CASES USING ACCESS. Tutorial A. Database Design. Tutorial B. Microsoft Access. Case 1. Case 2. Case 3. Case 4. Case 5. PART II. DECISION SUPPORT CASES USING EXCEL SCENARIO MANAGER. Tutorial C. Building a Decision Support System in Excel. Case 6. Case 7. PART III. DECISION SUPPORT CASES USING MICROSOFT EXCEL SOLVER. Tutorial D. Building a Decision Support System Using Microsoft Excel Solver. Case 8. Case 9. PART IV. DECISION SUPPORT CASE USING BASIC EXCEL FUNCTIONALITY. Case 10. PART C. INTEGRATION CASES USING ACCESS AND EXCEL. Case 11. Case 12. PART VI: ADVANCED SKILLS USING EXCEL. Tutorial E: Guidance for Excel Cases PART VII: PRESENTATION SKILLS. Tutorial F. Giving an Oral Presentation.