Page 248 - IT 402 v2.0 class 10
P. 248

It opens with the required database which allows the user to work with tables, queries, forms and reports
        in it.

           BASIC ELEMENTS OF 'BASE' TABLE

          table has multiple fields.  ach field has a name for the respective type of data.   data type indicates the type
        of data to be stored in that field.  he field properties describe the behaviour of that field.


        Field Name
          field name is the identifier of a field as it contains the data that is to be stored in that field.  enerally  it
        represents a particular property of the table entity. For example  in a table of student record   name  field
        describes the name and  age  field describes the age of the student. In simple words  it is the name of the
        column. For convenience  a field name should denote the contents of that field. Field name can consist of
        letters  numbers and some special characters like period  .   exclamation      single apostrophe      s uare
        brackets          etc. If a field name consists of more than two words  then  oin them by underscore sign      .

        Field Type

         atabases  store  different  types  of  data  like  characters   dates   numbers   symbols   O     Ob ect   inking  and
         mbedding  ob ects  etc.  herefore  a clear distinction has to be made for proper identification and manipulation
        of data in the field.  ata type of the field specifies what kind of data is to be stored in that particular field and
        what kind of operation can be performed on that data. For example   Marks  can be only numeric data and not
        alphabetical  so data type of the field  Marks  should be Numeric.  he data type of a field depends upon the
        values to be entered in that field. Ob ect  inking and  mbedding  O    facilitates the sharing of application data
        and ob ects written in different formats from multiple sources.  inking establishes a connection between two
        objects and embedding facilitates application data insertion. For example, If we have to insert an Excel sheet
        in our table  we can insert it as an O   ob ect in our table. OpenO ce  ase supports the following data types:


                                                                Max. no. of       Storage Size     Format Used
                Data Type                Related to          character that can   (Memory that is   (While writing
                                                                be entered     acquired in storage)  the code)
          Numeric Data Type
           oolean                es No                         -                  it               S NO
          Integer               Integer or whole number      -    to    -         ytes           IN
          Numeric               Numbers  Numbers with decimal   -----          No  imit          N M
          Decimal               Numbers with decimal        -----              No  imit             IM
                                                                      -52
           eal                  Numbers with more than    spaces  2 -1074  to   -       1023     ytes
                                                                      -52
          Float                 Floating point numbers      2 -1074  to   -       1023       ytes   F O
          Double                Numbers with more than    spaces 2 -1074  to   -       1023     ytes   O
                                                                      -52
          Alphanumeric Data Type
          Memo                   arge Information           indicated by user        for    bit OS    ON
           ext  fix             Textual Information         255                     for    bit OS
          Text                  Textual Information         255                     for    bit OS
          Text                  Textual Information         255                     for    bit OS         -
                                                                                                 I NO    S
          Date/Time Data Type
          Date                  Stores Month  day    ear info.  -----          -----             DATE
          Time                  Stores hour  minutes  second info.  -----      -----              IM
          Timestamp             Stores  ate and  ime info.  -----              -----              IM S  M



         246       Touchpad Information Technology-X
   243   244   245   246   247   248   249   250   251   252   253