Page 27 - ModularV1.1 _c8_flipbook
P. 27
DATA TYPES IN MS ACCESS 2010
The data types are used to declare the type of fields in the database. MS Access 2010 provides
the following data types:
Data Type Description
Text It is used to store text. It can have maximum of 255 characters. It cannot
be used for numeric calculations.
Memo It is used to store large amount of text or a combination of text and
number. It stores up to 65,536 characters.
Number It is used to enter numerical values and perform numerical calculations.
The maximum size of the Number field is 16 bytes.
AutoNumber It stores a sequential number automatically for every record added to a
table. The maximum size of the field is 4 bytes.
Date/Time It is used to store the information like date of birth, date of joining, etc.
The maximum size of the field is 8 bytes.
Yes/No It is used in places where the fields can have boolean value. It can be
either True (T) or False (F).
OLE (Object Linking It is used to embed an object created in another application such as MS
and Embedding) Word, MS Excel or MS PowerPoint. The maximum size of the file is 2 GB.
Hyperlink It is used to store the links to web pages, websites, files, etc.
Lookup Wizard A Lookup Wizard helps you to create a field whose values are chosen
from the values in another table, query or list of values. By default,
Access sets the Lookup fields to the Number data types.
Currency It is used to store currency values.
Attachment It is used to store attached images, spreadsheet files, documents, charts,
and other types of supported files.
RULES FOR WRITING A FIELD NAME IN MS ACCESS
Following rules you should remember while writing field names:
Field name can be up to 64 characters long.
Field name can include any combination of letters, numbers, spaces, and special characters
except a period (.), an exclamation mark (!), an accent grave (') and brackets ([ ]).
Field name cannot begin with the leading spaces.
Field name cannot include a double quotation mark (").
Introduction to MS Access 2010 25

