|
Problem-Solving Cases in Microsoft Access and Excel 5th Edition
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.
Part 1: Database Cases Using Access
Tutorial A: Database Design
Tutorial B: Microsoft Access Tutorial
Case 1: Preliminary Case: The College Geeks
Case 2: The Internet Book Swap
Case 3: The E-Commerce Convenience Store Database
Case 4: Just-In-Time Lobsters Database
Case 5: The Crab Shack Employee Database
Part 2: Decision Support Cases Using Excel Scenario Manager
Tutorial C: Building a Decision Support System in Excel
Case 6: Transit Strike Negotiations
Case 7: The Toll Road Leasing Decision
Part 3: Decision Support Cases Using Excel Solver
Tutorial D: Building a Decision Support System Using the Excel Solver
Case 8: The College Mutual Fund Investment Mix Decision
Case 9: Scheduling Grill Manufacturing at Wombat Grills
Part 4: Decision Support Cases Using Basic Excel Functionality
Case 10: The Baseball Park Decision
Part 5: Integration Case: Using Access and Excel
Case 11: Analysis of a Low-Interest-Rate Loan Portfolio
Part 6: Data Analysis Techniques
Tutorial E Guidance for Excel Cases
Part 7: Presentation Skills
Tutorial F Giving an Oral Presentation
|
