Access 2007 Tutorial

Getting Started:

• New Database

• Database Templates

• Table Views

• Adding New Fields

Relationships:

• One-to-One Relationship

• One-to-Many Relationship

• Creating Table Relationships

• Print a Table Relationship

Features:

• Tables

• Query

• Recordset

• Form

• Report

Records:

• Add Records to a Table

• Find and Replace

• Totals

• Sort Records

• Filter

Customize Options:

• Popular

• Current Database

• Datasheet

• Object Designers

• Proofing

• Advanced

• Customize

Working with Tables:

• Delete a Table

• Rename a Table

• Add a Description to a Table

Data Types:

• Data Types

• Editing Data Types in Fields

Forms:

• Form Views

• Create a Form

• Form Wizard

Working with Keys:

• Primary Key

• Composite Key

• Foreign Key

Queries:

• Query Wizard

• Query Design Feature

• Query Criteria

• Expressions

• Zoom

Reports:

• Report Views

• Create a Report

• Report Wizard

• Custom Calculated Fields

• Print a Report