Page 31 - Touchpad_Plus_V3.2_Class 8
P. 31

The table is divided into three columns:

                              Field Name: This column is used to enter the name of the field to be displayed as a
                              column heading in the table.

                              Field Type: This column is used to define the type of data that can be entered

                              in that field. The commonly used data types in Base are Text, Number, Integer,
                              Decimal, Date, Time, Yes/No, etc.
                              Description: This column is used to give additional comments or information to the
                              user while entering data. The entry in this field is optional.

                 Step 3   Enter the name of the field and assign suitable data type.





















                                                          Table in design view

                          Similarly, you can enter the names of the fields and assign suitable data types.























                                                          Entering field names
                 In LibreOffice Base, a table is saved after assigning a unique primary key to one of its fields. To
                 assign a primary key to a field, follow these steps:

                 Step 1  Right-click on the box next to the desired field name in the table design view.

                 Step 2  Select the Primary Key option from the context menu.





                                                                               Introduction to LibreOffice Base      29
   26   27   28   29   30   31   32   33   34   35   36