Microsoft Access 2003 Introduction Training Course

GETTING STARTED

• What is Access?
• Starting Access
• The Access Application Window
• Working with Access Menus
• 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 of a Table
• Navigating Through Records in Datasheet View
• Closing a Table / Closing a Database File

CREATING A FORM / MODIFYING AND MANIPULATING DATA

• Reopening a Database File / Reopening a Table
• Creating a Form
• Navigating Through Records in Form View / Closing a Form
• Reopening a Form
• Switching Between Form View and Datasheet View
• Entering Records in Form View
• Editing Records in Datasheet View and in Form View / Using the Find Feature
• Deleting Records in Datasheet View and in Form View
• Modifying the Datasheet View of a Table
• Sorting the Records in a Table

DISPLAYING SELECTED DATA

• Filtering the Records in a Table
• Creating a Simple Query
• Creating a Query in Design View
• 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
• Compacting and Repairing a Database
• Backing Up a Database
• Importing Spreadsheet Data into an Access Table
• Importing Text into an Access Table