Problem-Solving Cases Using MS Access and Excel

0.0

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