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