Für diesen Artikel ist leider kein Bild verfügbar.

Problem Solving Cases In Microsoft Access & Excel

Ellen Monk, Joseph Brady, Emilio Mendelsohn (Autoren)

Buch | Softcover

256 Seiten

2019 | 16th edition
Course Technology Inc (Verlag)
978-0-357-13863-2 (ISBN)

Artikel merken

Learn how to analyze and successfully solve today's real business problems using the latest Microsoft® Office Access database management system and the most recent version of Excel spreadsheet tools. Packed with hands-on learning opportunities, Monk/Brady/Mendelsohn's PROBLEM-SOLVING CASES IN MICROSOFT® ACCESS AND EXCEL, 16E features five individual tutorials designed to build your practical knowledge as you walk step-by-step through the capabilities of each software application. Twelve all-new case studies challenge you to use the software applications to resolve scenarios and problems you are likely to encounter on the job. In addition, a unique emphasis on skill-building integration demonstrates how to use Access and Excel together to resolve challenges within each case. Trust today's most up-to-date, practical guide for mastering critical Access and Excel skills in a business context.

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. 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. 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. Preliminary Case: Dog Hikes.
Case 2. The Parks and Recreation Database.
Case 3. The Senior Concierge Database.
Case 4. The Fresh Fish Database.
Case 5. The Volunteer Fire Company Database
Part II: DECISION SUPPORT CASES USING MICROSOFT EXCEL SCENARIO MANAGER.
Tutorial C. Building a Decision Support Systems in Excel.
Case 6. The Ski Resort Investment Decision.
Case 7. The College Town Budget.
Part III: DECISION SUPPORT CASES USING MICROSOFT EXCEL SOLVER.
Tutorial D. Building a Decision Support System Using Microsoft Excel Solver.
Case 8. Rose Tree Regional Airline.
Case 9. The Auto Maker Product Mix Problem.
Part IV: DECISION SUPPORT CASE USING BASIC ACCESS AND EXCEL FUNCTIONALITY.
Case 10. The Donation Letter Analysis.
Part V: INTEGRATION CASES USING MICROSOFT ACCESS AND EXCEL.
Case 11. San Francisco Fire Incidents.
Case 12. San Francisco Fire Incidents: Advanced Analysis.
Part VI: ADVANCED SKILLS USING EXCEL.
Tutorial E. Guidance for Excel Cases.

Erscheinungsdatum	01.08.2019
Verlagsort	Boston, MA
Sprache	englisch
Maße	219 x 276 mm
Gewicht	544 g
Themenwelt	Mathematik / Informatik ► Informatik ► Datenbanken
	Informatik ► Office Programme ► Access
	Informatik ► Office Programme ► Excel
	Informatik ► Office Programme ► Project
ISBN-10	0-357-13863-5 / 0357138635
ISBN-13	978-0-357-13863-2 / 9780357138632
Zustand	Neuware