Problem solving cases in microsoft access and excel

PROBLEM-SOLVING CASES IN MICROSOFT® ACCESS® AND EXCEL®, Annual 10E, Int. ed. 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 are accessible by a Cengage Brain username and password. Designed to facilitate classroom instruction, these resources includesix new Hall of Fame cases, along with new solution files, syllabus, and Student Data Files. INDICE: PART I: DATABASE CASES USING ACCESS..Tutorial A. Database Design..Tutorial B. Microsoft Access..Case 1. Preliminary Case: The Fireplace Shop..Case 2. Decorative Concrete Database..Case 3. Collective Coupons Tracking Database..Case 4. The Moveable Art Database..Case 5. The Animal Loan Database..PART II: DECISION SUPPORT CASES USING EXCEL SCENARIO MANAGER..Tutorial C. Building a Decision Support System in Excel..Case 6. Buffalo Ben's Game Ranch ExpansionDecision..Case 7. The Fruit Pie Investment Decision..PART III: DECISION SUPPORT CASES USING MICROSOFT EXCEL SOLVER..Tutorial D. Building a Decision SupportSystem Using Microsoft Excel Solver..Case 8. Desert Airlines Aircraft Assignment Problem..Case 9. Premier Plastics Line Scheduling Plan..PART IV: DECISION SUPPORT CASE USING BASIC EXCEL FUNCTIONALITY..Case 10. The State Pension Funding Problem..PART V: INTEGRATION CASES USING ACCESS AND EXCEL..Case 11. The Common Stock Analysis..Case 12. The Teacher Evaluation System..PART VI: ADVANCED SKILLS USING EXCEL..Tutorial E: Guidance for Excel Cases.PART VII: PRESENTATION SKILLS..Tutorial F. Giving an Oral Presentation.

• ISBN: 978-1-133-62980-1
• Editorial: South Western College
• Encuadernacion: Rústica
• Páginas: 250
• Fecha Publicación: 16/03/2012
• Nº Volúmenes: 1
• Idioma: Inglés