Structuring Existing Data

Import data
Analyze tables
Create a junction table
Improve table structure

Writing Advanced Queries

Create unmatched and duplicates queries
Group and summarize records
Summarize data with a cross-tab query
Create a PivotTable
Create a PivotChart
Display a graphical summary on a form

Macros

Create a macro
Attach a macro to a Command button
Restrict records using a WHERE condition
Require data entry with a macro
Display a Message Box with a macro
Automate data entry

Making Forms more effective

Change the display of data conditionally
Display a calendar on a form
Organize information with Tab pages

Making Reports more effective

Cancel printing of a blank report
Include a chart in a report
Arrange data in columns
Create a report snapshot

Maintaining an Access database

Link tables to external data sources
Back up a database
Compact and repair a database
Protect a database with a password
Determine Object dependency
Document a database
Analyze the performance of a database