Access 2003 Intermediate

CW-056B Access 2003 Intermediate

Synopsis: Created for the student whose goal is to become proficient in designing tables, setting relationships between tables, validating data entry in tables, and creating and using advanced queries, forms and reports in Microsoft Access.

Prerequisite: Successful completion of Access 2003 Basic class or equivalent experience.

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. Relational databases
    1. Database normalization.
    2. Relating tables.
    3. Implementing referential integrity.
  2. Working With Related Tables
    1. Look fields.
    2. Modifying Lookup fields.
    3. Subdatasheets.
  3. Complex queries
    1. Joining tables in queries.
    2. Calculating fields.
    3. Summarizing and grouping values.
  4. Advanced form design
    1. Adding unbound controls.
    2. Graphics.
    3. Adding calculated values.
    4. Adding combo boxes.
  5. Advanced reports
    1. Creating customized headers and footers.
    2. Adding calculated values.
    3. Subreports.
  6. Charts
    1. Charts in forms.
    2. Charts in reports.
  7. PivotTables and PivotCharts
    1. PivotTables.
    2. Modifying PivotTables.
    3. PivotCharts.
  8. Internet Integration
    1. Hyperlink fields.
    2. Working with data access pages.