Structuring Existing Data
·
Analyze
Tables
·
Create a
Junction Table
·
Improve Table
Structure
Writing Advanced Queries
·
Create
Subqueries
·
Create
Unmatched and Duplicate Queries
·
Group and
Summarize Records Using Criteria
·
Summarize
Data Using a Crosstab Query
·
Create a
PivotTable and a PivotChart
Simplifying Tasks with Macros
·
Create a
Macro
·
Attach a
Macro
·
Restrict
Records Using a Condition
·
Validate Data
Using a Macro
·
Automate Data
Entry Using a Macro
Making Effective Use of Forms
·
Display a
Calendar on a Form
·
Organize
Information with Tab Pages
·
Display a
Summary of Data in a Form
Making Reports More Effective
·
Include a
Chart in a Report
·
Print Data in
Columns
·
Cancel
Printing of a Blank Report
·
Create a
Report Snapshot
Maintaining an Access Database
·
Link Tables
to External Data Sources
·
Manage a
Database
·
Determine
Object Dependency
·
Document in a
Database
·
Analyze the
Performance of a Database