Lab #10: Database Basics and Access 2000 (II)

PRE-LAB PREPARATION

Review:

• Ch. 12, Hutchinson & Sawyer
• Resources on Access and database design

LAB TASK

Building a database containing relational database (Team and Individual)

Your department has a large number of staff, faculty and students. It also has a large number of keys for rooms, cabinets and special equipment. Your task is to develop a relational database model to help manage the keys.Your table will be able to show:

• all the keys held by staff
• distribution of keys
• All keys and what they are for
• Keys held by single staff person
• All persons having particular key
• What a particular key is for

*Note: You may use your own problem if you like. However you must create a relational database containing two or three tables, showing one-to-one, one-to-many, or/and many-to-many relationships.

Team Task (0.25). Discuss the following in the in-class group by writing down answers on a piece of paper:

1. what tables you need to create and what are the fields contained in each table
2. Through the Entity-Relational Diagram under Tool, showing the relationship between the different tables including two or three tables, showing one-to-one, one-to-many, or many-to-many relationships.
3. list a number of records for each table.
4. Submission: Turn in the answers in a hard copy at the end of the lab. Make suer that the number of the group and the names of all the group members appearing on the paper.

Individual Task (0.75). Create the database

1. create the tables according to the result of your group discussion.
2. run and save at least two queries of your questions (refer to this site for more instructions on queries)
3. generate a form from a table
4. generate a report from one of the queries
5. Submission:

• send the database you created to ge@ist.psu.edu, including the
  • relational tables
  • E-R relational diagram under Tool
  • a mimimum of two queries
  • a form
  • a report
• turn in a hard copy of the report including your name, email address, and Lab # on the header or footer.

 

OBJECTIVES

• After completing this lab, you will be able to:
• understand how query works
• create a query
• apply the query concept to solve a real-life problem
• understand basic concepts of a form and a report
• generate and edit a form and a report

SKILLS

• Create a database
• create relational tables
• Create a query
• create and edit a form and a table form wizard
• create and edit a form and a table form wizard

RESOURCES

• Ch.12
• Designing a Database
• MS Access
• Introduction to Access 97
• More Microsoft Access 97
• Penn State CAC Web-Based Tutorial (WBT) on Access (Select a level that meets your needs).

 

EVALUATION

This lab is worth 1 points, 0.25 points for the team work, and 0.75 for the individual work.