FIELDS NAME by asimhashmi11

VIEWS: 6 PAGES: 4

									                       In the field name column in the top pane we type the name of the
field, we are adding to our table. The field name can as many as 64 characters and can
contain any characters numbers and spaces except for period (.), an accent grave (,),
square brackets ([]) and exclamation mark (). Leading spaces are not allowed so we
would need to begin each field name with a valid character or number.
Although we can have 64 characters in the field name, keeping our field name as small as
possible is advisable.
                   The data types of a field determine the kind of data the field can
store. We can choose from nine (9) data type:
    1. Text
    2. Memo
    3. Number
    4. Currency
    5. Data/Time
    6. Auto Number
    7. Yes/No
    8. OLE objects
    9. Hyperlink
TEXT

The text data type can store as many as 255 alphabetic or numeric characters. We can use
this data type to store data such as names, addresses, description and numbers that will
not be used in calculation such as phone number.

MEMO

The memo data type can contain the same type of data as the text data type but it can held
as many as 65535 characters.

NUMBER
The number data type store number that will be used in mathematical calculations.

CURRENY

The currency data type store number representing currency that will be used in
calculations.

DATA/TIME.

The data/time data type is a special number data type; that allow us to store data &time in
a field. The format property of this data types allows us specifies how the data will
appear in a field.

AUTO NUMBER.

If we select this data type for a field, Access handles the entry that field in every record.

YES/NO.

The YES/NO data type is logical fields that can store either true or False, the field accept
True/False, Yes/No of its values although we can use its format property to customize
what it shows for true/false.

OLE OBJECT (Object Linking and Embedding)
The OLE objects data type store large binary OLE objects, such as Word document,
Excel workbook, Bitmaps files, sound files, and video files.

								
To top