Page 225 - IT_V1.0_Class10
P. 225

Notes

                          To store monetary values and support various currency formats, you need to select the field as a numeric
                          data type and then click on the Format Field button in the Filed Properties section. This will open the Filed
                          Format dialog box, where you can specify the desired currency format. For example, $1000, or ₹500.00.



                 To set the primary key for the table:

                 Step 5:  Position the mouse pointer on the field which you want
                          to be set as primary key.
                 Step 6:  Right-click the field. A context menu appears.          6

                 Step 7:   Select the Primary Key option from the context menu.
                                                                                                 7
                          A  key-like  symbol  appears  in  front  of  selected  field
                          indicating that the column will now considered as a primary key.
                 Step 8:  Click on the Save button in the Standard toolbar. The Save As dialog box appears on the screen.

                 Step 9:  Type the name of the table in the Table Name text box.
                 Step 10: Click on the OK button. A table with the given name is created.



                  8






                                                                                            9
                                                     10



                 Step 11: Click on the Close button in the Table Design window. The created database is displayed in the
                          Tables pane in the LibreOffice Base window.


                                                                                                     21 st
                                                   Lab Assignment ‘n Activity                     Century   #Technology Literacy
                                                                                                        #Information Literacy
                                                                                                    Skills

                     Complete the following activities and tick the circle.

                       Create a Table namely ‘STUDENT’ using Design View with the following fields:
                         Field Name          Field Type           Field Name                   Field Type
                         Stu_ID              Numeric              Marks_Eng                    Numeric
                         Stu_Name            Text                 Marks_Hindi                  Numeric

                         DOB                 Date                 Marks_Maths                  Numeric
                       Set Stu_ID as Primary Key.

                       Set the field properties as:
                         (a)  Width of Stu_Name as 40 characters.
                         (b)  Set required property as ‘Yes’ for Stu_Name.




                                                                                     Starting with LibreOffice Base  223
   220   221   222   223   224   225   226   227   228   229   230