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

