Problem Solving Cases in Microsoft Access and Excel

by Monk, Ellen; Brady, Joseph

• ISBN13: 9780538482202
• ISBN10: 0538482206
• Edition: 8th
• Format: Paperback
• Copyright: 2010-08-24
• Publisher: Course Technology

Summary

PROBLEM-SOLVING CASES IN MICROSOFT ACCESS AND EXCEL helps you apply Access and Excel effectively and efficiently to solve real-world business problems. With 6 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 new case studies, which introduce problems that today's business professionals are likely to face. The cases allow you to apply the information gleaned from the tutorials to solve the problems. With features like integration cases that require readers to use both Access and Excel together, this book affords 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: Sorority Volunteer Database

University Speedy Delivery

The Subsitute Teacher Booking Database

Leasing Luxury Database

The Conference Center Reservation Database

Decision Support Cases Using Excel Scenario Manager

Building a Decision Support System in Excel

The Made4U Doughnuts Muffin Decision

The U.S. Budget Projection

Decision Support Cases Using Excel Solver

Building a Decision Support System Using the Excel Solver

The New Fund Manager Investment Mix Decision

The Golf Club Product Mix Decision

Decision Support Cases Using Basic Excel Functionality

The Hometown Newspaper Cash Flow Crisis

Integration Case: Using Access and Excel

The Credit Default Swap Decision

The Music Prediction System

Data Analysis Techniques

Data Analysis Techniques

Presentation Skills

Giving an Oral Presentation

Table of Contents provided by Publisher. All Rights Reserved.