Page 34 - TechPluse_C8_Flipbook
P. 34
B. Find six terms related to LibreOffice Base in the following grid.
Critical Thinking
P A B E A U T B D E Z L
R S N L S O M E M N D O
I M O O Z N L A D F A R
M T Q U E R Y L M L T Q
A L M S F E T O M Q A B
R Z Y U L P M T A Q B F
Y X L N M O S A L A A M
K S U V P R T B M R S Z
E L L O P T S L N F E A
Y M N F O R M E L Z Y B
Lab Session Subject Enrichment
Create a table using the ‘Table Data 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 grades.
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 by using the wizard.
32 Premium Edition-VIII

