Contents

CMSY 118 Advanced Databases

After successful completion of this course, students will be able to use Microsoft® Access to create advanced tables, queries, forms, and reports. Skills covered also include managing database objects, creating macros, and maintaining relational databases. This course may be completed in fewer than 14 weeks. All of the work (except tests) may be done outside of class if the student has compatible software.

Credits

1

Prerequisite

CMSY 103

Course Objectives

  1. 1. Create and modify advanced tables.
  2. 2. Create and use custom forms.
  3. 3. Refine queries.
  4. 4. Use advanced report features.
  5. 5. Define relationships.
  6. 6. Use Access tools.
  7. 7. Integrate Access Data.

Course Objectives

  1. 1. Create and modify advanced tables.
  2. 2. Create and use custom forms.
  3. 3. Refine queries.
  4. 4. Use advanced report features.
  5. 5. Define relationships.
  6. 6. Use Access tools.
  7. 7. Integrate Access Data.