- Shopping Bag ( 0 items )
Ships from: Batavia, IL
Usually ships in 1-2 business days
Apply Access and Excel effectively and efficiently to solve real-world business problems in this sixth edition of Problem-Solving Cases in Microsoft 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. With updates that include an all new sixth tutorial that covers data analysis techniques, a second integration case, and a 60-day trial of Microsoft Office 2007 software, this book affords readers the most up-to-date, practical education in the most commonly used software programs.
Part 1: 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: Online Workouts Database Case 4: Silent Car Auction Database Case 5: The Charity Database Part 2: Decision Support Cases Using Excel Scenario Manager Tutorial C: Building a Decision Support System in Excel Case 6: Central's Sports Betting Decision Case 7: The School District Funding Decision Part 3: Decision Support Cases 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 4: Decision Support Cases Using Basic Excel Functionality Case 10: The Portfolio Reconstruction Problem Part 5: Integration Cases: Using Access and Excel Case 11: Unusual College GPA Analysis Case 12: The DVD REntal Prediction Part 6: Advanced Skills Using Excel Tutorial E Guidance for Excel Cases Part 7: Presentation Skills Tutorial F Giving an Oral Presentationm