Page 57 - Computer Class 08
P. 57
Understanding Fields and Their Data Types
Field - an element of a table that contains a specific item of information, such as a last
name.
Field’s Data Type - determines what kind of data the field can store.
Format Use to display
Short Text Alphanumeric data (names, titles etc.) - up to 255 characters
Large amounts of alphanumeric data: sentences and
Long Text
paragraphs – 64,000 characters
Number Numeric data
Date/Time Dates and times
Currency Monetary values
AutoNumber Unique value generated by Access for each new record
Yes/No Yes and No values and fields that contain only one of two values
Pictures, graphs or other ActiveX objects from another Windows-
OLE Object
based application
Hyperlink A link address to a document or file on the internet
Attachment You can attach files such as pictures, documents, spreadsheets, or
charts; each Attachment field can contain an unlimited number of
attachments per record, up to the storage limit of the size of a
database file.
You can create an expression that uses data from one or
Calculated more fields. You can designate different result data types from
the expression.
Displays either a list of values that is retrieved from a table or
Lookup Wizard query, or a set of values that you specified when you created the
field. The Lookup Wizard starts and you can create a Lookup field.
The data type of a Lookup field is either text or number, depending
on the choices that you make in the wizard.
Computer-8 57
