Problem Solving Cases In Microsoft® Access and Excel

Ellen Monk, Joseph Brady, Gerard Cook, Emillio Mendelsohn (Autoren)

Buch | Softcover

304 Seiten

2015 | 13th edition
CENGAGE Learning Custom Publishing (Verlag)
978-1-305-40872-2 (ISBN)

Titel erscheint in neuer Auflage

Artikel merken

Helps you effectively apply the Access database management system and Excel spreadsheet to analyze and solve real-world business problems. In this title, six tutorials build your practical knowledge of each software application's capabilities, while 12 all-new case studies present scenarios and problems common in today's business practice.

The most up-to-date, practical guide for these popular software programs, PROBLEM-SOLVING CASES IN MICROSOFT® ACCESS AND EXCEL, 13th Annual Edition, helps you effectively apply the Access database management system and Excel spreadsheet to analyze and solve real-world business problems. Six user-friendly tutorials build your practical knowledge of each software application’s capabilities, while 12 all-new case studies present scenarios and problems common in today’s business practice. In addition, a skill-building integration feature enables you to use Access and Excel together on cases—equipping you with skills you can immediately apply on the job.

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, Dr. Monk worked as a chemical engineer for Engelhard Industries and W. R. Grace and Co.’s Davison Chemical Division. She has a B.S. degree in chemical engineering, an MBA, and a Ph.D. in MIS. Joseph A. Brady taught MIS courses at the University of Delaware from 1990 to 2009. Prior to launching his teaching career, Dr. Brady worked as a financial analyst for E. I. Du Pont de Nemours. Dr. Brady has an M.S. degree in computer science, an MBA, and a Ph.D. in education. 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. Emilio Mendelsohn joined the Lerner College of Business and Economics at the University of Delaware in 2012 as an adjunct professor of Management Information Systems. He currently works as a risk manager for U.S. Bank in the Retail Payments Solutions Division. Formerly, Mr. Mendelsohn worked for JPMorgan Chase and Co. as an application manager in the Engineering and Technology Department and information risk analyst in the Information Technology Risk Management Department. Mr. Mendelsohn has B.S. and M.S. degrees in management information systems. Emilio Mendelsohn joined the Lerner College of Business and Economics at the University of Delaware in 2012 as an adjunct professor of Management Information Systems. He currently works as a risk manager for U.S. Bank in the Retail Payments Solutions Division. Formerly, Mr. Mendelsohn worked for JPMorgan Chase and Co. as an application manager in the Engineering and Technology Department and information risk analyst in the Information Technology Risk Management Department. Mr. Mendelsohn has B.S. and M.S. degrees in management information systems.

PART I: DATABASE CASES USING ACCESS.
Tutorial A: Database Design.
Tutorial B: Microsoft Access.
Case 1.
Case 2.
Case 3.
Case 4.
Case 5.
Part II: DECISION SUPPORT CASES USING EXCEL SCENARIO MANAGER.
Tutorial C: Building a Decision Support System in Excel.
Case 6.
Case 7.
PART III: DECISION SUPPORT CASES USING MICROSOFT EXCEL SOLVER.
Tutorial D.
Case 8.
Case 9.
PART IV: DECISION SUPPORT CASE USING BASIC EXCEL FUNCTIONALITY.
Case 10.
PART V: INTEGRATION CASES USING ACCESS AND EXCEL.
Case 11.
Case 12.
PART VI: ADVANCED SKILLS USING EXCEL.
Tutorial E: Guidance for Excel Cases.
PART VII: PRESENTATION SKILLS.
Tutorial F: Giving an Oral Presentation.
Index.

Erscheint lt. Verlag	7.3.2015
Verlagsort	Mason, OH
Sprache	englisch
Maße	217 x 275 mm
Gewicht	680 g
Themenwelt	Informatik ► Office Programme ► Excel
	Mathematik / Informatik ► Informatik ► Software Entwicklung
	Mathematik / Informatik ► Informatik ► Theorie / Studium
ISBN-10	1-305-40872-1 / 1305408721
ISBN-13	978-1-305-40872-2 / 9781305408722
Zustand	Neuware