The use of ACCESS in monitoring students' database

Access is a useful tool to store students’ personal details, especially when there is a large number of student involved. Access enables us to do linking among students’ details, as well as to generate related report, create suitable forms and easy access for query.

We can create database in Access by following the steps below:
>Template categories>Featuring>New Blank Database>[enter file name]>Create

We are now being in a new database sheet. We first have to create a list of students’ personal details in a table in database. ID is automatically fixed for each student as their names are being keyed in to the database. We save the database right after all the information regarding students’ personal details are being keyed in. After keying in their personal details, we may need to key in their co-curriculum activities record. So, another new table needs to be created in the same database. To do so, we follow as below steps:
>Create>Table

Then we put in the co-curriculum activities record for each student. Still, their ID will not change, but to follow as per the 1st table build regarding personal details. The same steps are repeated for the building of another table for exam result.

So now, we have 3 tables containing students’ personal details, co-curriculum and exam result. How can we link the information together? Follow the steps below:
>Database tools>Relationships>Relationship Tools>design>Show table

Then we select those tables in database which consist those information of students’ which we wish to link them up. Then, we edit the relationships between each table to build up the relationship between the information needed. We wish to create a form containing all the information selected. The steps below followed:
>Create>Form Wizard

Then we select all the information we wish to be displayed in the form. Follow each step in the wizard and the form will be generated.
Almost all the steps are to be followed for the creation of query and reports.