Problem-Solving Cases in Microsoft® Access™ and Excel® ( MIS )

Publication series :MIS

Author: Ellen Monk;Joseph Brady  

Publisher: Cengage‎

Publication year: 2011

E-ISBN: 9781133464532

P-ISBN(Paperback): 9780538482202

Subject: C93 Management;F4 Industrial Economy;TP Automation Technology , Computer Technology;TP3 Computers

Keyword: 管理学,工业经济,计算技术、计算机技术,自动化技术、计算机技术

Language: ENG

Access to resources Favorite

Disclaimer: Any content in publications that violate the sovereignty, the constitution or regulations of the PRC is not accepted or approved by CNPIEC.

Description

PROBLEM-SOLVING CASES IN MICROSOFT ACCESS AND EXCEL helps you apply Access and Excel effectively and efficiently to solve real-world business problems. With 6 individual tutorials that build a practical knowledge of Microsoft Office 2007 Access and Excel capabilities, this book sets the groundwork for applying these database and spreadsheet skills to actual scenarios. These scenarios take the form of 12 new case studies, which introduce problems that today's business professionals are likely to face. The cases allow you to apply the information gleaned from the tutorials to solve the problems. With features like integration cases that require readers to use both Access and Excel together, this book affords the most up-to-date, practical education in the most commonly used software programs. Instructor support materials can be found in the Instructor Downloads section of www.cengage.com/coursetechnology, accessible to instructors with a Single Sign On (SSO) username and password. Designed to help facilitate classroom instruction, the instructor resources are unique to the textbook. Key features include 6 New Hall of Fame Cases, a new instructor's manual, new solution files, new syllabus, new Student Data Files. You'll find an Instructor's Manual, Hall of Fame Casese, Syllabi, Student Data Files, and Solution Files are offered. Contact your sales rep for more information.教学资源:PPT、教师手册、题库、Solutions Manual、Datasets。 教学资源目前仅能提供给老师,获取方式如下: 1. 邮箱获取:将教辅需求发邮件至asia.infochina@ce

Chapter

Part 1: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 Substitute Teacher Booking Database

Case 4 Leasing Luxury Database

Case 5 The Conference Center Reservation Database

Part 2: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 3:Decision Support Cases Using the 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 4:Decision Support Case Using Basic Excel Functionality

Case 10 The Hometown Newspaper Cash Flow Crisis

Part 5:Integration Cases Using Access and Excel

Case 11 The Credit Default Swap Decision

Case 12 The Music Prediction System

Part 6:Advanced Excel Skills

Tutorial E Guidance for Excel Cases

Part 7:Presentation Skills

Tutorial F Giving an Oral Presentation

Index

The users who browse this book also browse


No browse record.