Problem Solving Cases In Microsoft® Access and Excel

Joseph Brady, Ellen Monk, Emillio Mendelsohn, Emilio Mendelsohn (Autoren)

Buch | Softcover

304 Seiten

2016 | 14th edition
Course Technology Inc (Verlag)
978-1-305-86862-5 (ISBN)

Titel erscheint in neuer Auflage

Artikel merken

Discover how to maximize and successfully apply the advantages of the latest Access database management system and Excel spreadsheet to analyze and solve real business problems with PROBLEM-SOLVING CASES IN MICROSOFT® ACCESS AND EXCEL, 14TH ANNUAL EDITION. Packed with hands-on learning, this edition highlights six individual tutorials designed to build your practical knowledge as they walk you step-by-step through the capabilities of each software application. For the best in real-world practice, this edition offers 12 all-new case studies that present scenarios and problems you will likely encounter on the job. In addition, a unique emphasis on skill-building integration shows you how to use Access and Excel together on cases. Count on PROBLEM-SOLVING CASES IN MICROSOFT® ACCESS AND EXCEL to deliver today’s most up-to-date, practical guide for the widely used Access and Excel programs.

Joseph A. Brady taught management information systems (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 holds an M.S. in computer science, an M.B.A., and a Ph.D. in education. Ellen F. Monk is an Assistant Professor of Management Information Systems in the Lerner College of Business and Economics at the University of Delaware. Her areas of interest encompass enterprise resource planning systems and undergraduate MIS education, including databases, advanced spreadsheets and data analytics. Dr. Monk holds a B.S. in chemical engineering, an M.B.A., and a Ph.D. in MIS. 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. Emilio Mendelsohn has taught in the Lerner College of Business and Economics at the University of Delaware as well as at Penn State University as an adjunct instructor of Management Information Systems (MIS) since 2012. 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 as an information risk analyst in the Information Technology Risk Management Department. Mr. Mendelsohn holds a B.S. as well as an M.S. 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. Building a Decision Support System Using Microsoft® Excel Solver.
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.

Erscheinungsdatum	31.03.2016
Verlagsort	Boston, MA
Sprache	englisch
Maße	219 x 277 mm
Gewicht	590 g
Themenwelt	Mathematik / Informatik ► Informatik ► Datenbanken
	Informatik ► Office Programme ► Access
	Informatik ► Office Programme ► Excel
	Informatik ► Office Programme ► Outlook
	Technik
	Wirtschaft ► Betriebswirtschaft / Management ► Projektmanagement
ISBN-10	1-305-86862-5 / 1305868625
ISBN-13	978-1-305-86862-5 / 9781305868625
Zustand	Neuware