Data Types

Data Types

♦ Text • A text field contains up to 255 characters. It is use to store alphanumeric characters for entering text numbers, symbols and letters.

♦Memo

• A memo field contains up to 64,000 characters. It is use to store long text fields.

♦Number

• It performs mathematical calculations, numeric data in the form of integer, and is used for entering numbers. + and – sign, or decimal point

♦Date/Time

• It is used to store dated and times; this field is from 100 to 2000 years

♦Currency

• The numbers are formatted for an amount of money, Never use a Number data types for monetary values because it prevents rounding off numbers during calculations.

♦AutoNumber• A special numeric data type that can be used for primary key fields. Access automatically inserts the next number either in the sequence or in a random number when a data record is created.

♦Yes/No

• It contains one of two values: True/False, Yes/No, On/Off format. This format is used depending on what is needed to represent a particular field

♦OLE Object

• Links to another Database or file used to create object like MS Excel or Word document that can be OLE objects. The data in the field can either linked to or embedded in the Access table.

♦Hyperlink

• Access links the user to store addresses to Web documents, network files, and local files.

♦Look Up Wizard

• Enables you to create a list , to select a value from another table or predefined list of values.