|
 Course
Outline
Access - Basics
Versions
97/2000/2002(XP)/2003/2007
|
P.O. Box 225
5375 Main Street
East Petersburg, PA 17520-0225 |
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
- 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
|
|
Please Click Here to Register for Class
97/2000
or
2002/2003
or
2007
|
|
Course Prerequisite
Must have Windows
and mouse proficiency; Spreadsheet experience helpful
(4 CPE Credits) |
|
Copyright PC Easy March, 2006 |
|