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.
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
Height:
Width:
Spine:
Weight:953.00