"Problem Solving Cases in Microsoft[registered] Access and Excel[registered], Annual 10/e, International Edition" helps students apply the Access[registered] database management system and Excel[registered] spreadsheet to effectively analyze and solve real-world, business problems. Six individual tutorials in the text build a practical knowledge of each software application's capabilities, while twelve all-new case studies present scenarios and problems common in business. Further, a skill-building integration feature requires students to use Access[registered] and Excel[registered] together on cases, making this the most up-to-date, practical guide for these widely used software programs. Instructor support materials are accessible by a Cengage Brain username and password. Designed to facilitate classroom instruction, these resources include six new Hall of Fame cases, along with new solution files, syllabus, and Student Data Files.
Auflage
International ed of 10th revised ed
Sprache
Verlagsort
Verlagsgruppe
Zielgruppe
Für höhere Schule und Studium
Editions-Typ
Maße
Höhe: 246 mm
Breite: 189 mm
Dicke: 20 mm
ISBN-13
978-1-133-62980-1 (9781133629801)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Klassifikation
Gerry Cook has been the instructor for the Operations Management Technology program at Delaware Technical & Community College since its inception in 2007. Prior to his teaching career, he worked as a Process Engineer and Engineering Manager in manufacturing for Mannington Mills, James River Corporation, and Mobil Chemical in a career spanning 27 years. Mr. Cook has a B.S. degree in Industrial Engineering from Lehigh University and an MBA from Oklahoma City University. Joseph A. Brady taught M.I.S. courses at the University of Delaware from 1990 to 2009. Prior to his teaching career, he worked as a financial analyst for E.I. Dupont de Nemours. Dr. Brady has an M.S. degree in Computer Science, an M.B.A., and a Ph.D. in Education. Professor Ellen F. Monk has been teaching Information Systems at the Lerner College of Business and Economics at the University of Delaware since 1989. Prior to her teaching career, Ms. Monk worked as a chemical engineer for Engelhard Industries and W. R. Grace & Cos Davison Chemical Division. Ms. Monk has a B.S. degree in Chemical Engineering, an MBA, and is pursuing her doctoral degree in MIS.
PART I: DATABASE CASES USING ACCESS. Tutorial A. Database Design. Tutorial B. Microsoft Access. Case 1. Preliminary Case: The Fireplace Shop. Case 2. Decorative Concrete Database. Case 3. Collective Coupons Tracking Database. Case 4. The Moveable Art Database. Case 5. The Animal Loan Database. PART II: DECISION SUPPORT CASES USING EXCEL SCENARIO MANAGER. Tutorial C. Building a Decision Support System in Excel. Case 6. Buffalo Ben's Game Ranch Expansion Decision. Case 7. The Fruit Pie Investment Decision. PART III: DECISION SUPPORT CASES USING MICROSOFT EXCEL SOLVER. Tutorial D. Building a Decision Support System Using Microsoft Excel Solver. Case 8. Desert Airlines Aircraft Assignment Problem. Case 9. Premier Plastics Line Scheduling Plan. PART IV: DECISION SUPPORT CASE USING BASIC EXCEL FUNCTIONALITY. Case 10. The State Pension Funding Problem. PART V: INTEGRATION CASES USING ACCESS AND EXCEL. Case 11. The Common Stock Analysis. Case 12. The Teacher Evaluation System. PART VI: ADVANCED SKILLS USING EXCEL. Tutorial E: Guidance for Excel Cases PART VII: PRESENTATION SKILLS. Tutorial F. Giving an Oral Presentation.
