Problem-Solving Cases in Microsoft Access and Excel / Edition 5
by Joseph Brady, Ellen Monk, Ellen F. Monk
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
… See more details belowOverview
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.
Product Details
- ISBN-13:
- 9781423901396
- Publisher:
- Cengage Learning
- Publication date:
- 06/05/2007
- Edition description:
- Older Edition
- Pages:
- 230
- Product dimensions:
- 8.50(w) x 10.70(h) x 0.50(d)
Table of Contents
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
Customer Reviews
Average Review: