Problem-Solving Cases Using Ms Access and Excel 1st Edition  (English, Paperback, Brady Joseph)

Apply Access and Excel effectively and efficiently to solve real-world business problems in this edition of Problem-Solving Cases Using MS Access and Excel. With six individual tutorials that build a practical knowledge of Microsoft Office 2007 Access and Excel capabilities, this book sets the groundwork for applying these spreadsheet and database skills to actual scenarios. These scenarios take the form of 12 all new case studies, which introduce problems that are likely to face today's business professionals and allow readers to apply the information gleaned from the tutorials to solve them.

Key Features

• Presents 12 entirely new cases that introduce realistic business problems common in today's marketplace
• Offers six tutorials that reflect Microsoft Office 2007 Access and Excel. These tutorials prepare students for real-life use of Access and Excel and build spreadsheet and database skills
• Provides two integration cases that require students to use both Access and Excel together.

Table Of Contents
Part I: Database Cases Using Access

• Tutorial A: Database Design Tutorial B: Microsoft Access Tutorial
• Case 1: Preliminary Case: Furniture Rentals
• Case 2: Volunteer Vacations
• Case 3: The Charity Database
• Case 4: Online Workouts Database
• Case 5: Silent Car Auction Database

Part II: Cases in Decision Support Using Excel Scenario Manager

• Tutorial C: Building a Decision Support System in Excel
• Case 6: The School District Funding Decision
• Case 7: Central's Sports Betting Decision

Part III: Cases in Decision Support Using Excel Solver

• Tutorial D: Building a Decision Support System Using the Excel Solver
• Case 8: The Hometown University Menu Planning Decision
• Case 9: The Hometown Christmas Tree Production Decision

Part IV: Cases in Decision Support Using Basic Excel Functionality

• Case 10: The Portfolio Reconstruction Problem

Part V: Integration Cases: Using Access and Excel

• Case 11: The DVD Rental Prediction
• Case 12: Unusual College GPA Analysis

Part VI: Advanced Skills Using Excel

• Tutorial E Guidance for Excel Cases

Part VII: Presentation Skills Tutorial F Giving an Oral Presentation