Description
Book SynopsisTable of ContentsChapter 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
