Course Outline
Access - Basics
Versions 97/2000/2002(XP)/2003/2007

Phone:717-560-3552
Fax:717-569-1135
E-Mail: Registrar@pceasy.com

Program Objectives: This course is designed to give the student the basic skills to create a simple Access database using Tables, Queries, Forms and Reports.

• Introduction to Access
• Starting Access
• Database Management Applications
• Compacting a Database
• Opening a File
• Viewing Database Tables
• Moving Around Your Database File
• Switching to Other Opened Components
• What is a Database?
• Form Feature
• Report Feature
• Printing Your File
• Querying the Database
• Modifying a Query
• Saving a Query
• Help Feature
• Changing Column Width
• Moving Text
• Copying Text
• Copying Data From Previous Record
• Paste Append Feature
• Undo Feature
• Deleting a Record in the Data Table
• Sorting a Data Table
• Sorting with Single Criteria
• Sorting with Multiple Criteria
• Find Feature
• Replace Feature

• Closing a File
• Designing a Database
• Starting a New File
• Saving Files
• Saving Changes
• Creating a Database Table
• Field Names
• Data Types
• Description of Fields
• Primary Keys
• Setting the Primary Key
• Removing the Primary Key
• Saving Table Designs
• Entering Data into a Table
• Adding a Field
• Deleting a Field
• Creating a Form
• Creating a Query
• Query Comparison Operators
  • AND / OR / BETWEEN
• Creating a Report
• Making a Backup Copy of an Object
• Renaming an Object
• Altering the Appearance of a Report
  • Selecting and Sizing Controls
  • Moving Controls
  • Copying Controls
  • Deleting Controls
• Exiting Access