Microsoft Office Tutorials and References
In Depth Information
Creating a blank desktop database
The following table lists the available data types when you are
adding fields to a table in a desktop database.
Data type
Description
Shor t Tex t
Text up to 255 characters. In earlier versions of
Access, this data type was called Text.
Long Text
Large amounts of text, up to 65,536 characters. In
earlier versions of Access, this data type was called Memo.
Number
Field Size property provides for Byte, Integer, Long
Integer (default), Single, Double, Replication ID,
Decimal.
Date/Time
Date and Time field.
Currency
Currency field.
AutoNumber
Sequential Automatic Number, Long Integer (default).
Yes/No
True/False (default is False).
OLE Object
Can hold images or other documents.
Hyperlink
Hyperlink to the Internet and local documents.
Attachment
Allows multiple documents to be saved.
in reports
Calculated
Calculated field.
Lookup
Creates a foreign key lookup.
Search JabSto ::




Custom Search