Skip to main content

Access

Chapters

The Access unit contains 10 chapters. Students should work through the chapters as shown on the Section Schedule page.

Access Chapter 1
Access Chapter 2
Access Chapter 3
Access Chapter 4
Access Chapter 5
Access Chapter 6
Access Chapter 8
Access Chapter 9
Access Chapter 10
Access Supplemental Content

Unit Learning Objectives

After completing the Access unit, students will be able to:

# Unit Learning Objective Learning Activities
& Informal Assessments
Formal Assessments
C02.AC01 Design databases to store real world information.
  • Access: Database Design Participation Project
  • Access: Fields & Keys Participation Project
  • Exam #2
  • Final Exam
  • Homework #4
  • Homework #5
  • Homework #6
C02.AC02 Create and manage databases and their data.
  • Access: Access Basics Participation Project
  • Access: Database Creation Participation Project
  • Access: Fields & Keys Participation Project
  • Access: Forms Participation Project
  • Access: Queries I Participation Project
  • Access: Queries II Participation Project
  • Access: Queries III Participation Project
  • Access: Queries IV Participation Project
  • Access: Reports Participation Project
  • Access: SQL Participation Project
  • MyITLab Lesson C
  • MyITLab Lesson D
  • MyITLab Lesson E
  • Exam #2
  • Final Exam
  • Homework #4
  • Homework #5
  • Homework #6
  • MyITLab Lesson C
  • MyITLab Lesson D
  • MyITLab Lesson E
C02.AC03 Create and modify tables and associated relationships.
  • Access: Access Basics Participation Project
  • Access: Database Creation Participation Project
  • Access: Fields & Keys Participation Project
  • MyITLab Lesson C
  • MyITLab Lesson D
  • Exam #2
  • Final Exam
  • Homework #4
  • Homework #5
  • Homework #6
  • MyITLab Lesson C
  • MyITLab Lesson D
C02.AC04 Design and construct queries to extract needed information from a database.
  • Access: Access Basics Participation Project
  • Access: Queries I Participation Project
  • Access: Queries II Participation Project
  • Access: Queries III Participation Project
  • Access: Queries IV Participation Project
  • Access: SQL Participation Project
  • MyITLab Lesson C
  • MyITLab Lesson D
  • MyITLab Lesson E
  • Exam #2
  • Final Exam
  • Homework #4
  • Homework #5
  • Homework #6
  • MyITLab Lesson C
  • MyITLab Lesson D
  • MyITLab Lesson E
C02.AC05 Build forms and reports to facilitate access to data.
  • Access: Access Basics Participation Project
  • Access: Forms Participation Project
  • Access: Reports Participation Project
  • MyITLab Lesson E
  • Exam #2
  • Homework #5
  • MyITLab Lesson E
C05.AC06 Interpret and analyze database query results to perform calculations and answer questions.
  • Access: Database Creation Participation Project
  • Access: Forms Participation Project
  • Access: Queries I Participation Project
  • Access: Queries II Participation Project
  • Access: Queries III Participation Project
  • Access: Queries IV Participation Project
  • Access: Reports Participation Project
  • Access: SQL Participation Project
  • Exam #2
  • Final Exam
  • Homework #4
  • Homework #5
  • Homework #6