The University of Tennessee  

 

WebMail /SiteMapContact Information / Search

Beginning Access

Getting Started
   Access Application Window
   Basic Access Terminology
   Examining Access Objects
   Resetting the Database Folder
   Displaying Help Information
   Exiting from Access

Setting Up a New Database
   Designing a New Database
   Creating a New Database
   Creating a New Table
   Entering Records in Datasheet View
   Printing the Datasheet Table
   Closing a Table and Database

Creating a Form/Modifying and Manipulating Data
   Reopening a Database and a Table
   Creating a Form
   Browsing through Records in Form View and Closing a Form
   Reopening a Form
   Switching Between Form View and Datasheet View
   Entering Records in Form View
   Editing Records and Using the Find Feature
   Deleting Records
   Modifying the Datasheet View of a Table
   Sorting Records in a Table

Displaying Selected Records
   Creating and Applying a Filter
   Creating and Running a Query
   Modifying a Query
   Including a Numeric Condition in a Query
   Including a Calculated Field in a Query

Creating a Report
   Creating a Simple Tabular Report
   Creating a Grouped Tabular Report
   Modifying a Report

Additional Access Features
   Copying, Renaming and Deleting Database Objects
   Importing Spreadsheet Data into an Access Table

Back to UT Training Classes