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
   381   382   383   384   385   386   387   388   389   390   391