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
   303   304   305   306   307   308   309   310   311   312   313