Question

Rakesh has joined a summer camp for his personality development. The director of the
camp maintains a register containing details of all the students participating in the
camp. Now, the director wants to transfer all data in MS Access files. Help him create a
table in Design View in which each record consists of the following fields. Decide the
datatype yourself.​

Answer 1

Answer:

Tables :-  (Student_info , Student_fees )

Explanation:

There should be 2 tables

1. Student_info : For Personal information of the student.

In this table there should be attributes/ column names such as

(Student Roll no, Student Name , Student Address, Contact No,

Name of the School )

2.Student_fees : For Track of fees filled or not.

In this table there should be attributes/ column names such as

(receipt no, fees, Student Roll no)