Synopses & Reviews
Apply Excel and Access effectively and efficiently to solve real-world business problems in this fifth edition of Problem-Solving Cases in Microsoft Access and Excel. With six individual tutorials that build a practical knowledge of Microsoft Office 2007 Excel and Access capabilities, this book sets the groundwork for applying these spreadsheet and database skills to actual scenarios. These scenarios take the form of eleven 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 and a 30-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.
About the Author
Joseph A. Brady taught MIS courses at the University of Delaware from 1990 to 2009. Prior to his teaching career, he worked as a financial analyst for E.I. Dupont de Nemours. Dr. Brady has an M.S. degree in Computer Science, an MBA, and a Ph.D. in Education. He is also a Certified Public Accountant. Ellen F. Monk has been teaching Information Systems at the Lerner College of Business and Economics at the University of Delaware since 1989. Prior to her teaching career, Ellen worked as a chemical engineer for Engelhard Industries and W. R. Grace & Cos Davison Chemical Division. Ms. Monk has a B.S. degree in Chemical Engineering, an MBA, and is pursuing her doctoral degree in MIS.
Table of Contents
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