Begin the Access Tutorial »

Getting Started

• Microsoft Office Toolbar
• The Ribbon
• Quick Access Toolbar
• Navigation
• Tabbed Document Window Viewing

Customize

• Popular
• Current Database
• Datasheet
• Object Designers
• Proofing
• Advanced
• Customize

Database Terms

• Table
• Query
• Recordset
• Form
• Report

Creating a New Database

• New Database
• Database Templates

Create a Table

• Table Views
• Adding New Fields
• Data Types
• Editing Data Types in Fields

• Delete a Table
• Rename a Table
• Add a Description to a Table

Keys

• Primary Key
• Composite Key
• Foreign Key

Table Relationships

• One-to-One Relationship
• One-to-Many Relationship
• Creating a Table Relationship
• Print a Table Relationship Report

Managing Data

• Add Records to a Table
• Find and Replace
• Totals
• Sort Records
• Filter

Querying a Database

• Query Wizard
• Query Design Feature
• Query Criteria

Calculated Fields

• Expressions
• Zoom

Designing Forms

• Form Views
• Create a Form
• Form Wizard

Generating Reports

• Report Views
• Create a Report
• Report Wizard
• Custom Calculated Fields

Print a Report

• Print a Report

Office 2007 Tutorials · Word · Excel · PowerPoint · Access

FGCU does not provide personal support for Office 2007 programs to outside parties.

© FGCU 2007. This is an official FGCU web page.
Florida Gulf Coast University is an equal opportunity/affirmative action institution.

Contact the Webmaster | FGCU Directory