Need Help On Microsoft Access Question
DMC College of Technology
Grade Report
Student Name: Jones Stuart
Major: Information Technology
Address: #02-01 City Hall
Student ID: DIT-1234
Subject ID Subject Title Lecturer Name Lecturer Location Grade
DIT101 Computer System Essentials Sachin Room #06-05 HD
DIT102 Database Systems John Room #02-08 C
-=-=-=-=-=-=-=-=-=-=-=-=--=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Based on the normalized data you derived from Task 1 above, you have to create an application for staff
in DMC College of Technology in performing their day to day activities/ task.
The application must be able to perform the task below:
1. Data entry using “MS-Access forms” for the following:
a. Registration of a new student for the examination
b. Addition of a new subject
c. Addition of a lecturer and the lecturer class location
2. Query on the student whose student ID is “DIT-1234”.
3. Query on the names of the students who have obtained “HD” grades in all the subjects they are
enrolled for.
4. Query on the names of the students who have obtained “F” grades in all the subjects they are
enrolled for.
5. Produce a grade report. (Sort the output based on Student ID)
6. A report that shows all the students who have enrolled for the examination for the year 2009.
Your display has to group them based on the Student ID and followed by the Major.
** Do a screen capture on how the required task should be done for each task shown above.
Prior to produce the above requirements,
1. You have to create the tables derived from the 3NF task 1 above. You are required to add in
additional attributes as per instruction below (in additional data section).
• Use “Look up” command for foreign key.
2. Insert records.
s) which you get from the grade report diagram given above. You need to have at least
10 records for each table.
** Do a screen capture on how the required task should be done for each task shown above
Additional data
• During the registration, the staff will capture students’ IC/Passport no, name, address, age, gender,
contact number.
• For every course DMC college of Technology has, the management will store the lecturer name, the
skills of the lecturer, and the subjects teaching/taught.
• For every subject, one of the different grades that can be assigned based on the marks can be given
as HD for High Distinction, D for Distinction, C for Credit, P for Pass, and F for Fail.
• You can also assume appropriate buttons for individual data entry form.
