Skip to main content

Access Supplemental Content

Chapter Demonstrable Skills

After completing the Access Supplemental Content portion of the Access unit, students will be able to:

Demonstrable Skill Learning Activities
& Informal Assessments
Formal Assessments
(excluding Exams)
Import data from XML files.
  • Access: Database Creation Participation Project
  • Homework #4
  • Homework #6
Choose efficient compatible field types and sizes for storing data.
  • Access: Database Design Participation Project
  • Access: Fields & Keys Participation Project
  • Homework #4
  • Homework #5
Display unique values in query results.
  • Access: Queries IV Participation Project
Write custom SQL SELECT queries to extract information.
  • Access: SQL Participation Project
Create SQL INSERT, UPDATE, and DELETE queries to modify data.
  • Access: SQL Participation Project
Use database data to solve analysis 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
  • Homework #4
  • Homework #5
  • Homework #6

Chapter Notes

Importing data from XML files

XML files use special markup symbols to define where each column starts and ends. These files can be imported using the External Data ribbon.

Tips & Tricks

Extracting ZIP files

To extract the entire contents of a ZIP file, in Windows, right-click on the folder and choose Extract All. The Desktop is a convenient place to extract your files as they can be easily found there.