Access 2003 Basic

CW-056A Access 2003 Basic

Synopsis: This class is for the student whose goal is to become familiar with database concepts and objects and become proficient using Microsoft Access to create simple database structures.

Prerequisite: A general understanding of the Window operating system and the ability to use the keyboard and mouse.

Length of Course: Self-paced, average 12-18 hours per course

Required Text: Clackamas Community College custom courseware will be provided at the first class.

  1. Getting Startup
    1. Database concepts.
    2. Exploring the Access environment.
    3. Getting help.
    4. Closing a database and Access.
       
  2. Databases and Tables
    1. Planning and designing databases.
    2. Exploring tables.
    3. Creating tables.
       
  3. Fields and Records
    1. Changing the design of a table.
    2. Finding and editing records.
    3. Organizing records.
       
  4. Data Entry Rules
    1. Setting field properties.
    2. Working with input masks.
    3. Setting validation rules.
    4. Using indexes.
       
  5. Simple Queries
    1. Creating and using queries
    2. Modifying query results and queries.
    3. Performing operations in queries.
       
  6. Using Forms
    1. Creating forms.
    2. Using the Form Wizard.
    3. Using Design view.
    4. Finding, sorting, and filtering records.
       
  7. Working with Reports
    1. Creating reports.
    2. Modifying and printing reports.