Chapter 1 - Introduction
What is Access?
Databases
Business Decisions and Databases
Creating a New Access Database
Navigation Pane and Access Objects
File Formats and Other Access Settings
Access Help
Using versus Creating Databases
Chapter 2 - The Database Table
Creating Tables
Creating a New Table
Field Names, Data Types, and Field Properties
Indexing and Primary Keys
Entering and Formatting Data
Adjusting and Hiding Columns and Rows
Copying and Pasting Data
Sorting and Filtering Data
Editing Tables
Changing Data Types and Field Properties
Changing the Sequence of Field
Editing Data and Field Names
Inserting Fields
Deleting Fields and Records
Importing and Linking Data
Importing Data
Linking Data
Printing Tables
Chapter 3 - Selecting and Summarizing Data from Tables
Know Your Data
Getting Started
Single Field Primary Key Tables
Multiple Field Primary Key Tables
Fundamental Query Techniques (The Select Query)
Creating a New Query
Adding Fields and Adjusting Columns
Query Name and Properties
Defining Basic Criteria (OR AND)
Formatting and Sorting Data
Editing Queries
Exporting Queries to Excel
Advanced Queries
Grouping Data
Mathematical Summaries (Aggregate Functions)
Nested Queries
Crosstab Queries
Chapter 4 - Applying Calculations to Data
Formulas
Custom Fields
Calculated Fields
The Expression Builder
IIF Function
Basic IIF Function
Nested IIF Functions
Financial Functions
Future Value
Payment Function
Help with Functions
Chapter 5 - Reports
Fundamental Report Techniques
Creating a New Report
Setting the Dimensions of a Report
Report Header
Page Header
Detail
Page Footer
Report Footer
Advanced Report Techniques
Grouping Data
Sorting Data
Calculated Fields
Conditional Formatting
Group and Report Totals
Lines
Dates
Chapter 6 - Applying Core Competency Skills
Using Multiple Tables in Queries
Joining Tables
Inner Joins
Outer Joins
Defining Table Relationships
Comprehensive Access Project
Selecting Tables
Adding and Joining Tables in a Select Query
Creating a Parameter Query
Adding Calculations
Constructing the Final Report
Chapter 7 - Date, Text and Error Functions
Date Functions
Year
Month
Day
Text functions
Concatenate
Len
Left, Right, and Mid
String Conversion
Error Functions
Is Error
Is Null
Chapter 8 - Advanced Techniques for Managing and Using Tables
Managing Tables Through Queries
Delete Query
Append Query
Make Table Query
Duplicate records query
Pivot Tables
Chapter 9 - Forms
Basic Forms
Advance Forms
Chapter 10 - Macro
The Macro Window
Basic Macro routines
Appendix A - Access Utilities
ODBC Connections
Compacting Databases
Security
