Page 38 - Touchpad_Plus_V3.2_Class 8
P. 38
Lab Session Century #Technology Literacy
21 st
Skills
Create a table using the Table Design View.
Date of Marks
Reg No. Name Grade
Submission Obtained
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 at least 3 records.
• Sort the data on the basis of marks obtained.
Create a table using the Table 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 Chhattisgarh
A003 Rahul John 02/05/1990 656554432 Mumbai
• Sort the place in the decreasing order.
• Set Roll No. as the primary key.
• Delete the record having Roll No. A002.
• Add another record.
Teacher's Note
1. Discuss about different relational database management systems such as LibreOffice Base and Oracle.
2. Discuss the procedure to create a table.
36 Plus (Ver. 3.2)-VIII

