Computers in Business: K201 provides an introduction to the role of computers and other information technologies in business. It offers instruction in functional computer literacy, featuring an introduction to two of the most widely used database and spreadsheet packages: Microsoft Access and Microsoft Excel. Students learn, via hands-on examples, many of the powerful tools contained in these two packages with emphasis on how to analyze a variety of business problems. The goal is not to teach these packages in an abstract sense, but rather to show how they can be applied to 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
Kelley School of Business Faculty
Lisainfo e-raamatute kohta