Page 308 - TP_IT_V1.0_C10_flipbpookl
P. 308
Currency Data Type
The currency data type indicates the monetary values and can be stored using currencies of various countries. For
example: $100, £ 500 or `25.50
Binary Types
It stores the data in a binary format. It is used to store data for images, audio, video or files of any other format like
voice messages, sound snippets, employee photo etc.
The list of the available binary types is:
Data Type Name Description
Image LONGVARBINARY Store any array of bytes (images, sounds, etc.). No
validation required.
Binary (fix) BINARY Store any array of fix bytes. No validation required.
Binary VARBINARY Store any array of variable bytes. No validation
required.
Date Time
It stores data in the form of date or time or both. The date and time can be stored in various formats. It can be used to
store date of joining, date of birth, time of login, time of logout, retirement date, date of admission, etc.
The list of the available Date time types is:
Data Type Name Description
Date DATE Store month, day, and year information
Time TIME Store hour, minute, and second information
Date/Time TIMESTAMP Store date and time information
Boolean Data type
The Boolean data type is used to represent logical values, typically either True or False. However, LibreOffice Base
doesn’t have a native Boolean data type in the same way as some other database systems. Instead, it typically represents
Boolean values using integer values, where 0 usually represents false and any non-zero value represents true.
CREATING A TABLE
To create a table, select the Table option in the Database pane. In the LibreOffice Base, there are two methods that
are used to create a table. These methods are as follows:
o Create Table in Design View
o Use Wizard to Create Table
Now let us study each in detail.
Creating a Table in Design View
Design View allows you to manually specify the structure of your table by defining its fields, data types, and properties.
You have complete control over the table’s layout and can directly define attributes such as field names, data types
(e.g., text, number, date/time), field sizes, and validation rules like creating tables using Design View gives us more
flexibility.
Let us create a table using this Design View. The steps are as follows:
Step 1: Open the School.odb database.
306 Trackpad Information Technology (Ver. 1.0)-X

