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.
Shor t Tex t
Text up to 255 characters. In earlier versions of
Access, this data type was called Text.
Large amounts of text, up to 65,536 characters. In
earlier versions of Access, this data type was called Memo.
Field Size property provides for Byte, Integer, Long
Integer (default), Single, Double, Replication ID,
Date and Time field.
Sequential Automatic Number, Long Integer (default).
True/False (default is False).
Can hold images or other documents.
Hyperlink to the Internet and local documents.
Allows multiple documents to be saved.
Creates a foreign key lookup.