Page 427 - TP_IT_V1.0_C10_flipbpookl
P. 427
15. Create the following table using the ‘Design View’.
Reg No. Name Date of Submission Marks Obtained Grade
T/121/15 Anshu Verma 11/07/15 18 A
T/137/15 Anjali Kumari 12/07/15 20 A+
T/145/15 Deepak Kohli 14/07/15 17 B+
• Name the table as ‘Marks Distribution’.
• Enter atleast 3 records.
• Sort the data on the basis of grades.
16. 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 6565544329 Mumbai
• Sort the data in decreasing order on the basis of Place.
• Set Roll No as the primary key.
• Delete the record no. A002.
• Add another record.
17. Create the following table for the Library Management System.
Book ID Books Publication Price Quantity
1 Touchpad Orange Education 296 10
2 Pratibha Madhuban 256 20
3 Cyber Olympiad Orange Education 300 20
4 Living World Gurdas 275 20
Create the following table for the Student‘s Details.
Book ID Student Name Class Section
1 Amit Kumar 7 C
2 Ria Aggarwal 8 A
3 Yash Yadav 6 D
4 Ananya Gupta 8 B
• Show the relationship between the two tables based upon the common field.
• Create a form for the Student’s Details table. Enter the following records through the form.
Gyan Shanker 8 B
Richa Sinha 6 A
• Write a query to find the Book Name, Publication, Student’s Name, Class and Price from both the Student’s
Details table and Library Management System tables.
• Generate a report of the query created.
Practical Work 425

