Overview

Faculty at Indiana University's world-renowned Kelley School of Business present this essential introductory guide to the role of computers and other information technologies in business. Highlights include instruction and applied practice in two of the most widely used commercial software packages: Microsoft Access and Microsoft Excel. Students learn, via hands-on examples, many of the powerful tools contained in these two platforms, with emphasis on how to analyze real business problems to help make important decisions.

Full Product Details

Author:   Kelley School of Business Faculty
Publisher:   Indiana University Press
Imprint:   Indiana University Press
Edition:   2nd edition
Dimensions:   Width: 21.60cm , Height: 2.00cm , Length: 27.90cm
Weight:   0.953kg
ISBN:  

9780253026538

ISBN 10:   0253026539
Pages:   426
Publication Date:   22 August 2016
Audience:   Professional and scholarly ,  Professional & Vocational
Replaced By:   9780253026637
Format:   Paperback
Publisher's Status:   Active
Availability:   In Print  
This item will be ordered in for you from one of our suppliers. Upon receipt, we will promptly dispatch it out to you. For in store availability, please contact us.

Table of Contents

Chapter 1 | K201 Introduction Microsoft Access Chapter 2 | Access Introduction Chapter 3 | Importing Data, Keys, and Relationships Chapter 4 | Data Types and Basic Field Settings Chapter 5 | Data Entry, Lookup Fields, and Field Properties Chapter 6 | Basic Select Query Design, Criteria, and Total Row Chapter 7 | Concatenation, Calculated Fields, and Aggregate Functions Chapter 8 | Parameter Query and Query on Queries Chapter 9 |Query Wizard, and Action Queries Chapter 10 | The IIF Function and Intro to Forms Chapter 11 | Mulitple Page and Navigation Forms Microsoft Excel Chapter 12 | The Power of Excel Chapter 13 | Cell Referencing and Named Ranges Chapter 14 | Conditional Aggregate and Date Functions Chapter 15 | Financial Analysis Chapter 16 | Logical Functions Chapter 17 | Compound Nested IFs Chapter 18 | Data Retrieval: VLOOKUP, HLOOKUP, MATCH Chapter 19 | Data Retrieval: INDEX and MATCH Chapter 20 | Spreadsheet Models and Data Tables Chapter 21 | Data Validation Chapter 22 | Working with Text Data Chapter 23 | Tables and Charts Chapter 24 | PivotTable and Power View Reports Appendix Box at IU Query Guide Reports in Access Automating Tasks with Macros

Reviews

Author Information

Kelley School of Business Faculty

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions