Problem solving cases in Microsoft Access & Excel /

Monk, Ellen F.

Problem solving cases in Microsoft Access & Excel / Ellen F. Monk, Joseph A. Brady, Gerard S. Cook. - 10th annual Ed. - Boston, MA : Course Technology, 2013. - 285p. 28 cm.

PART I: DATABASE CASES USING ACCESS. Tutorial A: Database Design. Tutorial B: Microsoft Access Tutorial. Case 1: Preliminary Case: Sorority Volunteer Database. Case 2: University Speedy Delivery. Case 3: The Subsitute Teacher Booking Database. Case 4: Leasing Luxury Database. Case 5: The Conference Center Reservation Database. PART II: DECISION SUPPORT CASES USING EXCEL SCENARIO MANAGER. Tutorial C: Building a Decision Support System in Excel. Case 6: The Made4U Doughnuts Muffin Decision. Case 7: The U.S. Budget Projection. PART III: DECISION SUPPORT CASES USING EXCEL SOLVER. Tutorial D: Building a Decision Support System Using the Excel Solver Case 8: The New Fund Manager Investment Mix Decision. Case 9: The Golf Club Product Mix Decision. Part IV: DECISION SUPPORT CASES USING BASIC EXCEL FUNCTIONALITY. Case 10: The Hometown Newspaper Cash Flow Crisis. Part V: INTEGRATION CASE: USING ACCESS AND EXCEL. Case 11: The Credit Default Swap Decision. Case 12: The Music Prediction System. PART VI: DATA ANALYSIS TECHNIQUES. Tutorial E: Data Analysis Techniques. PART VII: PRESENTATION SKILLS. Tutorial F: Giving an Oral Presentation

Index

9781133629795 9781133629801

2011945044


Microsoft Excel (Computer file)
Microsoft Access
Electronic spreadsheets
Business--Computer programs
Management information systems
Decision support systems
Problem solving

HF5548.4.M523