Problem Solving Cases in Microsoft Access and Excel

by Monk,Ellen

• ISBN13: 9780324789102
• ISBN10: 0324789106
• Edition: 7th
• Format: Paperback
• Copyright: 2009-04-17
• Publisher: Cengage Learning

Summary

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.

Table of Contents

Database Cases Using Access

Database Design

Microsoft Access Tutorial

Preliminary Case: Nature Tourism

Textbook Leasing

Parks Summer Job Database

The Car Share Reservation Database

The Gourmet Tea Inventory Database

Decision Support Cases Using Excel Scenario Manager

Building a Decision Support System in Excel

The Choc-a-bloc Candy-Making Decision

The Fair Trade Shop Decision

Decision Support Cases Using Excel Solver

Building a Decision Support System Using the Excel Solver

The Bakery Bread Production Problem

Big State University Freshman Acceptance Problem

Decision Support Cases Using Basic Excel Functionality

Non-Bored Games Operating Budget

Integration Case: Using Access And Excel

The Hometown Tree Farm Analysis

The Golf Tour Game Prediction

Data Analysis Techniques

Data Analysis Techniques

Presentation Skills

Giving an Oral Presentation

Table of Contents provided by Publisher. All Rights Reserved.