Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 104 - CoreGPT(Podar)_Flipbook_C8
P. 104

    Table Data view
                            RULES FOR WRITING A FIELD NAME IN LIBREOFFICE BASE

                      Following rules must be remembered while writing field names:

                           Field name must be unique.
                           Choose field names that clearly indicate the data they contain.
                           Field names cannot start with a number.

                           Avoid using special characters like @, #, $ or % in field names.

                            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.

                               This will open a blank
                               table in the Table Design
                               View.

                               The  table  is  divided  into
                               three columns:
                                                                                     Creating a table
                                   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.

                    102     Premium Edition-VIII

| 99 100 101 102 103 104 105 106 107 108 109 |