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

