Deadline: December 1, 2007
Access
Requirement:
Implement a grade book using MS Access.
Your grade book should have a table with the following fields
Student id
Student name
Assignment 1 -- weight 5%
Assignment 2 -- weight 5%
Assignment 3 -- weight 5%
Project 1 -- weight 5%
Project 2 -- weight 5%
Project 3 -- weight 5%
Midterm test 1 -- weight 20%
Midterm test 2 -- weight 20%
Final test -- weight 30%
Determine the data types for all fields.
Student id is the primary key.
Add at least 20 students with their performance for all course work.
Generate a query that contains only id, name and tests, including two midterm tests and one final test.
Generate a report of all students whose at lease one of three tests is graded 100%. You only need to report these students' id and name. You may need to create some queries to support the generation of this report.
Submission:
You have to send your access document required above to the instructor at jhan@csudh.edu as attachments of an email.
Hard copy of documents will not be accepted.