learnit.stfrancis.edu  
A Learning Resource for the University of St. Francis Community

Learnit Home

Word

Excel

Powerpoint

Microsoft Access 2010

Download the Access 2010 Quick Reference Guide

Getting Started
    Length
min:sec
The File Menu print video 2:16
  The Ribbon (Formerly the Toolbars) print  
  Quick Access Toolbar print  
  Navigation & Tabbed Document Viewing print video 1:03
Customize
     
  Customizable Options print video 1:51
Database Terms
  Table print video 2:30
  Query print  
  Form print  
  Report print  
Create a New Database
  New Database print video 1:23
  Database Templates print video 1:45
Create a Table
  Table Views print video 1:07
  Adding New Fields print video 2:07
  Data Types print  
  Editing Data Types in Fields print video 1:58
Manage Tables
  Delete a Table print video 1:54
  Rename a Table print    
Keys
  Primary Key print    
Table Relationships
  One-to-One Relationships print    
  One-to-Many Relationships print    
  Creating a Table Relationship print video 2:08
Managing Data
  Add Records to a Table print video 0:45
  Find and Replace print video 2:30
  Totals print video 1:25
  Sort Records print video 1:23
  Filter print video 1:55
Querying a Database
  Query Wizard print video 1:47
  Query Design Feature print video 1:18
  Query Criteria print    
Calculated Fields
  Expressions print video 4:22
  Zoom print    
Designing Forms
  Form Views print    
  Create a Form print video 2:52
  Form Wizard print video 2:29
Generating Reports
  Report Views print    
  Create a Report print video 2:09
  Report Wizard print video 3:02
  Custom Calculated Fields print video 2:40

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