Microsoft Access Intermediate

Importing Information from Other Sources

Understanding Data Sources Access Can Import

Importing Excel Workbooks

Importing Text Files

Importing Access Tables

Appending Records from One Table to Another

Applying Field Properties to Validate Data Entry

Creating Lookups or Drop-Down Lists

Creating Table Lookups

Creating Value List Lookups

Modifying Value List Lookups

Creating Input Masks

Specifying Default Values

Enhancing Data-Entry Forms

Updating Fields with Property Changes

Shortcuts for Selecting Objects

Automatically Aligning Objects

Automatically Sizing Objects

Automatically Spacing Objects

Adding Command Buttons to Forms

Creating More Advanced Queries

Using Parameters to Prompt for Criteria

Prompting for One Value

Prompting for Two Values

Writing Expressions or Calculations Queries

Sample Expressions

Using Expressions in Criteria

Creating More Advanced Queries (Cont.)

Using Expressions to Create Calculated Fields

Creating Summary Queries

Creating Summary Queries

Working with Update Queries

Globally Change Data

Transfer Matching Data

Running Queries to Archive Information

Creating Make Table Queries

Creating Delete Queries

Enhancing Reports

Creating Reports Using the Report Tool

Sorting and Grouping Data

Inserting Graphic Lines

Previewing Pages in Print Preview

Keeping Records Together

Repeating Group Headers on the Top of Every Page

Writing Expressions and Calculations on Reports

Writing Expressions

Writing Summary Calculations Using the Property Sheet

Exporting Information Out of Access

Exporting Tables and Queries to Excel

Exporting Reports to Word

Using Access Tables or Queries in a Mail Merge