Evaluation of Database

This essay hasn't yet been marked by one of our teachers

You can view 11 essays on Information Systems and Communication that have been Marked by Teachers

The first 200 words of this essay...

Task F: Evaluation of Database

Introduction:

For this assignment I was asked to produce a database for tracking a student's achievements on a course of study. This database will contain Tables, Forms, Queries and Reports. In the database the course the students are studying consists of 6 units, each of which is marked out of 100. I showed results for each their units by producing reports and showed which student has passed the overall course and on which specific date the student passed it on. In my database I had 35 students divided into 2 Tutor Groups, I produced a relational database with a form to input details of the unit along with a sub-form to enter the student names and their marks along with the date of the results. I also created a form to input student details with a sub-form to enter the units they are doing and the mark obtained along with the date the result was entered.

Creating the database:

Creating the forms in the database was the longest yet the easiest procedure out of everything, I had to create four tables, which were: tblUnit, tblResult, tblStudent, tblTutorGroupID. All of these