Page 336 - Trackpad 402_Class-X_Final
P. 336
21 st #Leadership & Responsibility
LAB ACTIVITY Century #Creativity
Skills
1. Create a database Examination in OpenOffice 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.
• Write a query in SQL View to display the total number of records in the table.
• Create a report for the Students table.
336 Trackpad Information Technology-X

