Portland Community College | Portland, Oregon

Course Number:
CAS 140
Course Title:
Beginning Access
Credit Hours:
Lecture Hours:
Lecture/Lab Hours:
Lab Hours:
Special Fee:

Course Description

Introduces the basic features of Microsoft Access. Covers beginning database management concepts including tables, forms, reports, queries, and basic macros. Stresses a working knowledge of database management vocabulary. Emphasizes efficient use of Access toolbars and menus. Discusses database design issues. Recommended: Placement into RD 115 and WR 115. Audit available.

Addendum to Course Description

This course is presented in a hands-on lecture/lab format. Self-paced format and online instruction may also be utilized. Out-of-class preparation will be required.

Intended Outcomes for the course

Upon successful completion of this course, student will be able to:
1. Use Microsoft Access to create personal and/or business databases following current professional and/or industry standards.
2. Use critical thinking skills to design and create database objects.
3. Communicate in a business setting using database management vocabulary.

Outcome Assessment Strategies

A letter grade will be issued for this course based upon

  1. Performance tests
  2. May include objective tests, scored assignments, or projects
  3. May include the use of skill assessment software

Course Content (Themes, Concepts, Issues and Skills)

Themes, Concepts, Issues

  1. Communicate effectively using appropriate database management vocabulary.
  2. Use critical thinking and problem solving skills in designing databases for various business and personal projects.
  3. Proofread for accuracy in the entry of data and creation of database objects such as, tables, reports, forms and queries.
  4. Assess the databases for accuracy, readability, and appearance.
  5. Develop efficiency with specific sets of skills through repetitive reinforcement.

Competencies, Skills

  1. Students will develop proficiency through reinforcement and assessment on the following skills:
  2. Creating tables by defining fields composed of various data types and entering text and numeric records.
  3. Creating and modifying forms including sub-forms.
  4. Creating, modifying and customizing basic, grouped and summary reports.
  5. Use queries to update and delete records, sort information and create reports.
  6. Designing and creating queries using wildcard characters, multiple criteria, joined tables, and calculated fields.
  7. Create and modify basic switchboard interfaces using simple macros
  8. Establish relationships between two tables to ensure integrity and accuracy
  9. Design and create a database management system from scratch using original information.

Students will be familiar with the following skills:

  1. Using help features.
  2. Establishing relationships between more than two tables
  3. Printing mailing labels
  4. Documenting and compacting databases
  5. Using additional functions such as combo boxes.
  6. Using additional field data types such as memo, OLE, and hyperlink fields
  7. Students may be exposed to additional database management skills/concepts as time allows.