Management Problem Solving Using Excel, Access and the World Wide Web
 

 
 
 
 
 
 
 


To obtain an evaluation copy of Solve it! call sales at 1-800 416-6786 or print the PDF files below


ISBN: 1-930581-96-3

Solve it! for Windows
Version 5.0 for Office 2003

Sample Cases:
Chapter 3: Case 2(Excel)
Chapter 5: Case 2(Access)

Instructor manual samples:
Excel Solution Sample
Access Solution Sample


Data files for Case 2(Excel)
Data files for Case 2(Access)

You can review a sample Excel and Access case by clicking on the blue highlighted cases in the Tables of Content below. In order to view a sample case, you will need a copy of Acrobat Reader. If you do not have a copy of Acrobat, click here.


Table of Contents
Preface

Chapter 1:

Introduction to Solve it!
Learn Through Discovery
Industry Standard
Classic Business Problems
WEB Exercises and Cases
Documentation Included
The Skills Matrix
How to Use Solve it!

Chapter 2:

Introduction to Spreadsheet Software
Introduction to Microsoft Excel
Spreadsheet Design Principles

Chapter 3:

Spreadsheet Management Software Cases

Case 1: Practical Cleaners
Case 2: Clarkson Cosmetics
Case 3: Lightning Roofing Payroll
Case 4: Atksinson Investment Advisors
Case 5: The Town of Barnhart
Case 6: CC Jelly, Inc.
Case 7: Hanson's Hardware
Case 8: Universal Plastics, Inc.
Case 9: Ready Replicating
Case 10: Elder Wire Services
Case 11: Agro Industries
Case 12: Upton Assembly
Case 13: Fedorita Fruit Importers

Chapter 4:

Introduction to Database Software
What Is a Database?
What Is a Database Management System?
Comparative Advantages of Database Packages
Windows-based Databases
Introducing Microsoft Access for Windows
Getting Started - Access2003 for Windows

 

 

Chapter 5:

Database Management Software Cases
Case 1: Huntington Finishes Supplies Inc.
Case 2: WERNER, SCHMIDT, DAWKINS & KINDREY
Case 3: Merit Office Furniture
Case 4: BestHealth Pharmacy
Case 5: Greeley University
Case 6: True Tones I
Case 7: Coleman Contractors
Case 8: To-Be-Sure Rentals Inc.
Case 9: Sand Dollar Hotel
Case 10: True Tones II
Case 11: Madison Outfitters I
Case 12: Madison Outfitters II

Chapter 6:

Internet Cases
Case1: TravelExtra.com Web Portal
Case2: MyOwnJob.com
Case3: Benefit Programs Center
Case 4: Dunfrey Investements
Case 5: Wavetree Telecom
Case 6: Sound By Design
Case 7: Worldmarket Consulting
Case 8: Henderson Import/Export
Case 9: Greenwich Industries





ISBN: 1-930581-97-1


Solve it! for Windows
Version 4.0 for Office 2003



Sample Cases:
Chapter 3: Case 3(Excel)
Chapter 5: Case 4(Access)

Instructor manual samples:
Excel Solution Sample
Access Solution Sample


Data files for Case 3 (Excel)
Data files for Case 4 (Access)


You can review a sample Excel and Access case by clicking on the blue highlighted cases in the Tables of Content below. In order to view a sample case, you will need a copy of Acrobat Reader. If you do not have a copy of Acrobat, click here.






Table of Contents
Preface

Chapter 1:

Introduction to Solve it!
Learn Through Discovery
Industry Standard
Classic Business Problems
WEB Exercises and Cases
Documentation Included
The Skills Matrix
How to Use Solve it!

Chapter 2:

Introduction to Spreadsheet Software
Introduction to Microsoft Excel
Spreadsheet Design Principles




Chapter 3:

Spreadsheet Management Software Cases
Case 1: Supply Depot
Case 2: Sampson Clothiers
Case 3: The Confidential Executive Payroll
(data files for this case)
Case 4: Brooks Investment Advisers
Case 5: The Town of Madras
Case 6: Low-Carb Pastries, Inc.
Case 7: Pacific Condiments
Case 8: NAE Oregon, Inc.
Case 9: Reliable Storage
Case 10: Otis Lumber Company
Case 11: Desert Industries
Case 12: Troy Technology

Chapter 4:

Introduction to Database Software
What Is a Database?
What Is a Database Management System?
Comparative Advantages of Database Packages
Windows-based Databases
Introducing Microsoft Access for Windows
Getting Started - Access2003 for Windows.



  

Chapter 5:

Database Management Software Cases
Case l: Finishing Touch Supplies Inc.
Case 2: James and Van Patten Attorneys-at-Law
Case 3: Edwards Furniture
Case 4: ValueRite Pharmacy
(data files for this case)
Case 5: Bridgehampton University
Case 6: Sound by Design I
Case 7: Davidson Contractors
Case 8: Hightower Rentals Inc.
Case 9: Tierra Del Mar Hotel
Case 10: Sound by Design II
Case 11: Montgomery Outfitters I
Case 12: Montgomery Outfitters II


Chapter 6:

Internet Business Cases
Introduction to the Web Cases
Case 1: BestResults.com Web Portal Case 2: TrainOnline.com
Case 3: Innovative Benefit Programs
Case 4: Willamette Investments
Case 5: Proxis Corporation
Case 6: Sound By Design III
Case 7: Sustainable Consulting
Case 8: Northwest Import/Export
Case 9: Fairmount Industries


 

©2005 Azimuth Interactive, Inc. (800) 416-6786 ext 14. All rights reserved.