Computer Applications I

Computer Applications I

Date:	Week 16 - Day 4
Topic:	Access Review
Objective:	Students will demonstrate their knowledge of Access

Entry Task

This week's entry task will have you working in Microtype for the first 10 minutes of class. You must complete the following lessons:

Numeric Keyboarding Lesson 13 & 14.

Instruction: - Discussed in Class

Assignments

You are going to create a Database. The table you create should have at least 6 different records. You need to choose one of the three topics.

1. CD Collection:

Create a Database called CD Collection.
Create a Table called Favorites.
Use the following fields: CD Title, Artist, Cost, Number of Tracks, Date of Purchase, & Other CD's?. "Other CD" is asking if you have any other CD's from this artist.
Enter the records
Add your name as the last record.
Print the table Landscaped.
Create a Form called Favorites.
Use all the fields except Number of Tracks.
Print the Form that has your name. Only print one form!

2. Contact List:

Create a Database called Contact List.
Create a Table called Friends.
Use the following fields: Name, Address, Phone Number, Date of Birth, Email Address, & Cell Phone?. "Cell Phone" is asking if this person has a cell phone.
Enter the records
Add your name as the last record.
Print the table Landscaped.
Create a Form called Friends.
Use all the fields except Address.
Print the Form that has your name. Only print one form!

3. Assignment Sheet:

Create a Database called Assignment Sheet.
Create a Table called Assignments for (Class Name).
Use the following fields: Assignment, Assignment Category, Date Assigned, Date Due, Point Value, Points Earned & Completed?.
Enter the records
Add your name as the last record.
Print the table Landscaped.
Create a Form called Assignment Sheet.
Use all the fields except Assignment Category.
Print the Form that has your name. Only print one form!