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

P.O. Box 225                 
East Petersburg, PA 17520-0225

Phone:717-560-3552
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
  • Task Pane Contents
  • Database Management Applications
  • Compacting a Database
  • Opening a File
  • Setting Macro Security Levels
  • Viewing Database Tables
    • Datasheet View
    • Design View
  • Moving Around a Database
  • Switching to Other Opened Components
  • What is a Database?
  • Form Feature
  • Report Feature
    • Page Setup Options
    • How to Print
  • Querying the Database
  • Modifying a Query
  • Saving a Modified Query
  • Help Feature
  • Changing Column Width
  • Piggyback Clipboard
  • Moving Text
  • Copying Text
  • Copying Data From a Previous Field
  • Paste Append Feature
  • Undo Feature
  • Deleting a Record in the Data Table
  • Sorting a Data Table
    • Single Crite
    • Multiple Criteria - Filter Feature
  • Saving a Filter as a Query
  • Differences Between a Filter and a Query
  • Find Feature
  • Replace Feature
  • Closing a File
  • Designing a Database
  • Starting a New File
  • Saving Changes
  • Creating a Database Table
  • Field Names
  • Data Types Defined
  • Description of Fields
  • Field Sizes
  • Primary Keys - Setting/Removing
  • Saving Table Designs
  • Entering Data into a Table
  • Adding a Field
  • Deleting a Field
  • Creating a Form
  • Queries - Creating/Running
  • Query Comparison Operators
    • AND
    • OR
    • BETWEEN
  • Saving a Query
  • Creating a Report
  • Making a Backup Copy of an Object
  • Altering the Appearance of a Report
    • Selecting and Sizing Controls
    • Previewing and Saving
    • Moving Controls
    • Copying Controls
    • Deleting Controls
  • Exiting Access

 

Course Outline - Access Intermediate Part I

Course Prerequisite
Must have Windows and mouse proficiency; Spreadsheet experience helpful

(4 CPE Credits)

Copyright PC Easy May, 2014