Access Supplemental Content | Computer Science 101

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 #3 Homework #5
Choose efficient compatible field types and sizes for storing data.	Access: Database Design Participation Project Access: Fields & Keys Participation Project	Homework #3 Homework #4
Display unique values in query results.	Access: Queries IV 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 #3 Homework #4 Homework #5

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.