Page 316 - IT_V1.0_Class10
P. 316
15. Create the following table using the ‘Design View’.
Roll No. Name Date of Birth Phone No. Place
A001 Manan Gupta 12/09/1987 2354667667 Delhi
A002 Ryansh Sharma 09/05/1986 3435555555 Chattisgarh
A003 Rahul John 02/05/1990 6565544324 Mumbai
• Sort the place in decreasing order.
• Set Roll No. as the primary key.
• Delete the record no. A002.
• Add another record.
16. You are managing a school database that includes two main tables: Students and Classes.
Students Table
StudentID StudentName DateOfBirth ClassID
1 Priya Sharma 2005-03-15 101
2 Rahul Kapoor 2004-07-22 102
3 Meena Patel 2005-11-10 101
4 Aisha Khan 2004-02-25 103
5 Dev Rai 2005-05-30 102
Classes Table
ClassID ClassName TeacherName
101 Mathematics Mr. Prakash
102 Science Ms. Yashika
103 History Mrs. Seema
• Set up a relationship between the Students table and the Classes table.
• Create a query in Design View to list all students along with the class they are in and the teacher of that
class.
17. Create the following table for the Students’ Details:
StudentID StudentName Class Section
1 Amit Kumar 7 C
2 Ria Aggarwal 8 A
3 Yash Yadav 6 D
4 Ananya Gupta 8 B
5 Praveen Seni 7 C
• Create a form for the Students’ Details table.
• Enter the following records through the form.
6 Gyan Shanker 8 B
7 Richa Sinha 6 A
314 Information Technology Play (Ver 1.0)-X

