Synopses & Reviews
Apply Access and Excel effectively and efficiently to solve real-world business problems in this seventh 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 database and spreadsheet 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. The seventh edition continues to offer a tutorial covering data analysis techniques and a second integration case, affording readers the most up-to-date, practical education in the most commonly used software programs.
About the Author
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 and Co.'s Davison Chemical Division. Ms. Monk has a B.S. degree in Chemical Engineering, an M.B.A., and is pursuing her doctoral degree in M.I.S.Joseph A. Brady taught M.I.S. 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 M.B.A., and a Ph.D. in Education.
Table of Contents
'PART I. DATABASE CASES USING ACCESS. Tutorial A. Database Design. Tutorial B. Microsoft Access Tutorial. Case 1. Preliminary Case: Sorority Volunteer Database. Case 2. University Speedy Delivery. Case 3. The Subsitute Teacher Booking Database. Case 4. Leasing Luxury Database. Case 5. The Conference Center Reservation Database. PART II. DECISION SUPPORT CASES USING EXCEL SCENARIO MANAGER. Tutorial C. Building a Decision Support System in Excel. Case 6. The Made4U Doughnuts Muffin Decision. Case 7. The U.S. Budget Projection. PART III. DECISION SUPPORT CASES USING EXCEL SOLVER. Tutorial D. Building a Decision Support System Using the Excel Solver Case 8 .The New Fund Manager Investment Mix Decision. Case 9. The Golf Club Product Mix Decision. PART IV. DECISION SUPPORT CASES USING BASIC EXCEL FUNCTIONALITY. Case 10. The Hometown Newspaper Cash Flow Crisis. PART V. INTEGRATION CASE: USING ACCESS AND EXCEL. Case 11. The Credit Default Swap Decision. Case 12. The Music Prediction System. PART VI. DATA ANALYSIS TECHNIQUES. Tutorial E. Data Analysis Techniques. PART VII. PRESENTATION SKILLS. Tutorial F. Giving an Oral Presentation.\n
'