Page 386 - TP_IT_V1.0_C10_flipbpookl
P. 386
21 st
LAB ACTIVITY Century #Critical Thinking
Skills
1. Create a database Examination in LibreOffice Base and perform the following operations:
• Create a table Marks having the following structure:
Field Name Data Type Length
Stud_No Integer 4
Stud_Name Text 40
RollNo Integer 5
Sub_1_Marks Decimal 3,2
Sub_2_Marks Decimal 3,2
Sub_3_Marks Decimal 3,2
• Add the following records:
Stud_No Stud_Name RollNo Sub_1_Marks Sub_2_Marks Sub_3_Marks
D101 Amit Kumar A2342 78 88 98
D102 Soniya Sharma A2343 98 78 78
D103 Ankit Kaushal A2344 99 89 94
D104 Anil Thapar A2345 88 98 91
D105 Kusum Agarwal A2346 89 92 88
• Create a form to update the above records.
2. Create a database School and create a table Students in it. The structure of the Students table is as follows:
Field Name Data Type Length
RollNo Integer 4
Name Text 30
Class Text 3
Section Text 1
After creating the table, perform the following operations:
• Apply the primary key on the RollNo field.
• Create a query in Design view to display all the records from the table.
• Create a report for the Students table.
384 Trackpad Information Technology (Ver. 1.0)-X

