I have been presented with a request from an imaginary examination board to design a system that monitors the post examination marks of the board.

 

Centre table

Subject table

Entity relationship Diagram

This diagram represents the relationship between the three tables I will be using to fulfil this task.

One Centre will hold many Candidates.

Many Candidates will do one subject.

                                One to Many.                           Many to One.

This is how the relationship diagram looks when created on Microsoft Access.

Implementation

 These are what the tables look like in Design and Datasheet view.  

Candidate table

 

Centre table

Subject table.

User Interface

Main Page  - This is where a user can gain access to all the other forms containing the different details

Candidate form

Centre Form

Subject form

Queries

Here is an example of how a query will look in design view.

This is an example of an update query, which updates the table according to the values inputted. All together there were 50 update queries: 25 for the original grade and 25 for the Re-mark grade.  

This is an example of a search query. The particular query was to search how many candidates belong to a certain centre. When the search is complete, it will display the Candidate name, Candidate Surname, Candidate Number and Centre name.

Validation and Testing