A Learning Resource for the University of St. Francis Community

Learnit Home




Microsoft Access 2007

Download the Access 2007 Quick Reference Guide

Getting Started
The Microsoft Office Toolbar print    
  The Ribbon (Formerly the Toolbars) print    
  Quick Access Toolbar print    
  Navigation & Tabbed Document Viewing print    
  Customizable Options print    
Database Terms
  Table print    
  Query print    
  Form print    
  Report print    
Create a New Database
  New Database print    
  Database Templates print    
Create a Table
  Table Views print    
  Adding New Fields print    
  Data Types print    
  Editing Data Types in Fields print    
Manage Tables
  Delete a Table print    
  Rename a Table print    
  Primary Key print    
Table Relationships
  One-to-One Relationships print    
  One-to-Many Relationships print    
  Creating a Table Relationship print    
Managing Data
  Add Records to a Table print    
  Find and Replace print    
  Totals print    
  Sort Records print    
  Filter print    
Querying a Database
  Query Wizard print    
  Query Design Feature print    
  Query Criteria print    
Calculated Fields
  Expressions print    
  Zoom print    
Designing Forms
  Form Views print    
  Create a Form print    
  Form Wizard print    
Generating Reports
  Report Views print    
  Create a Report print    
  Report Wizard print    
  Custom Calculated Fields print    

Center for Instructional Delivery • University of St. Francis • Joliet, IL 60435 • [815] 740-5080 • cid@stfrancis.edu
Learnit logo