Problem Solving Cases with Microsoft Access and Excel / Edition 6

Problem Solving Cases with Microsoft Access and Excel / Edition 6

by Joseph Brady, Ellen Monk
     
 


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… See more details below

Overview


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.

Product Details

ISBN-13:
9781423902133
Publisher:
Cengage Learning
Publication date:
01/28/2008
Edition description:
Older Edition
Pages:
240
Product dimensions:
8.60(w) x 10.68(h) x 0.48(d)

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

Read More

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >