Access One Assignment
(as of 4 November
This assignment uses
Microsoft Access. The instructor’s demonstration during the
lab and reviewing Technology Plug In 6 will help you understand the
mechanics of using the database tool. You may do this homework
using either Microsoft 2003 or 2007. This problem set creates an
enrollment database for a university in the greater Washington DC
area For this assignment, you will create a simple
database with 3 tables, and then fill it with some sample data.
Assignment Instructions:
- Create a database with three table using the following definitions:
Student Table
| Student ID |
number |
5 |
primary key |
| Last Name |
text |
20 |
alternate key |
| First Name |
text |
15 |
|
| Address |
text |
20 |
|
| City |
text |
20 |
|
| State |
text |
2 |
|
| Zipcode |
text |
5 |
|
| Major |
text |
4 |
allowable entries: ISOM, MKTG, FIN, ACCT, MGMT |
Course Table
| Course ID |
number |
5 |
primary key |
| Course Name |
text |
20 |
|
| Instructor Last Name |
text |
20 |
|
| Instructor First Name |
text |
15 |
|
| Semester |
text |
6 |
allowable entries: FA2007, SP2008,SU2008,FA008 |
Enrollment Table
| Enrollment ID |
number |
5 |
autonumber |
| Course ID |
number |
5 |
foreign key |
| Student ID |
number |
5 |
foreign key |
| Grade |
text |
1 |
allowable entries: A, B, C, D, F |
- Using the relationship desktop, create the appropriate relationships.
- Print out the relationships
- Enter 3 sample student
records, 5 sample course records, and 10 enrollment records. Make sure
one of the student records contains your data, one of the course
records contains information for this class, and one of the enrollment
records shows you taking this class (go ahead and give yourself an A)
for the grade
- Using the report wizard,
create and print three reports - one for each table. Print out
all the records for each table. Make sure the headings and data are
fully viewable.
Grading Rubric: each point is
worth 20%
1. Turn it in, with your name on the paper.
2.
Each table is created properly.
3. Both relationships are created properly.
4. You have entered the correct amount of sample records, making sure your information is included.
5. The report is easy to read, with proper titles and layout.
-
