Problem-Solving Cases in Microsoft Access and Excel / Edition 11

Problem-Solving Cases in Microsoft Access and Excel / Edition 11

by Ellen Monk
     
 

View All Available Formats & Editions

ISBN-10: 1133628370

ISBN-13: 9781133628378

Pub. Date: 12/31/2012

Publisher: Cengage Learning

PROBLEM-SOLVING CASES IN MICROSOFT ACCESS AND EXCEL, Twelfth Annual Edition, helps you apply the Access database management system and Excel spreadsheet to effectively analyze and solve real-world business problems. Six individual tutorials build a practical knowledge of each software application's capabilities, while 12 all-new case studies present scenarios and

Overview

PROBLEM-SOLVING CASES IN MICROSOFT ACCESS AND EXCEL, Twelfth Annual Edition, helps you apply the Access database management system and Excel spreadsheet to effectively analyze and solve real-world business problems. Six individual tutorials build a practical knowledge of each software application's capabilities, while 12 all-new case studies present scenarios and problems common in business. Further, a skill-building integration feature requires readers to use Access and Excel together on cases, making this the most up-to-date, practical guide for these widely used software programs.

Product Details

ISBN-13:
9781133628378
Publisher:
Cengage Learning
Publication date:
12/31/2012
Pages:
304
Product dimensions:
10.60(w) x 8.40(h) x 0.70(d)

Table of Contents

Part 1: DATABASE CASES USING ACCESS. Tutorial A: Database Design. Tutorial B: Microsoft Access. Case 1: Preliminary Case; The Personal Training Database. Case 2: Rent-a-Dress Database. Case 3: The Import Food Market Database. Case 4: The Music Festival Database. Case 5: City Bike Rental Database. Part 2: DECISION SUPPORT CASES USING EXCEL SCENARIO MANAGER. Tutorial C: Building a Decision Support System in Excel. Case 6: New England Energy Investment Strategy Decision. Case 7: The City Hotel Recovery Analysis. Part 3: DECISION SUPPORT CASES USING MICROSOFT EXCEL SOLVER. Tutorial D: Decision Support Cases Using Microsoft Excel Solver. Case 8: Duchess Cruises Ship Assignment Problem. Case 9: Ed and Carla's Retirement Plan. Part 4: DECISION SUPPORT CASE USING BASIC EXCEL FUNCTIONALITY. Case 10: The University Arena Construction Decision. Part 5: INTEGRATION CASES USING ACCESS AND EXCEL. Case 11: The College GPA Analysis. Case 12: The Nonprofit Donor Analysis. Part 6: ADVANCED SKILLS USING EXCEL. Tutorial E: Guidance for Excel Cases. Part 7: PRESENTATION SKILLS. Tutorial F: Giving an Oral Presentation.

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >