Page 29 - TechPluse_C8_Flipbook
P. 29

CREATING A TABLE

                 Table can be created in two ways:
                     Using Table Design View

                     Using Wizard
                 Let us create a table using Table Design view.
                 Creating a Table Using Table Design View


                 In this view, you can define fields which are to be included in the table. You can simultaneously
                 define properties of these fields also. To create table in Table Design view, follow these steps:
                 Step 1     Click on the Tables button in Database pane.

                 Step 2     Click on the Create Table in Design View option from Tasks pane.










                                                                       Creating a table
                              Database Pane
                 This will open a blank table in the Table Design View. The table is divided into three columns:

                     Field Name: Used to enter name of the field to be displayed as column heading in the table.
                     Field Type: Used to define the type of data
                     that can be entered in that field. The commonly
                     used  field  types  in  Base  are  Text, Number,
                     Integer, Decimal, Date, Time, Yes/No, etc.

                     Description: Used to give additional
                     comments  or information to the user while
                     entering data. The entry in this field is optional.
                 Enter the names of the fields and assign suitable
                                                                                       Table in design view
                 data types.





















                                                          Entering field names

                                                                               Introduction to LibreOffice Base       27
   24   25   26   27   28   29   30   31   32   33   34