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
   331   332   333   334   335   336   337   338   339   340   341