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. Like the text for its sister course, K201, Computers in Business: K204 highlights include instruction and applied practice in two of the most widely used commercial software packages: Microsoft Access and Microsoft Excel. This volume, however, presents even more challenging applications and projects for honors students. 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.50cm , Length: 27.90cm
Weight:   1.207kg
ISBN:  

9780253026644

ISBN 10:   0253026644
Pages:   540
Publication Date:   08 August 2016
Audience:   Professional and scholarly ,  Professional & Vocational
Replaced By:   9780253026651
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 K204 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 K204—Honors Chapter 26 Database Planning and Assessing Data Needs Chapter 27 Design Theory and Normalization Chapter 28 Structuring Data in the Database Chapter 29 Advanced Reports Chapter 30 Advanced Forms and 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