you can store in a single
Text
field is 255.
•
Memo
: Stores long text fields. No maximum is specified by the user, but Access imposes a limit of
64,000 characters. The
Notes
field is a
Memo
field.
•
Number
: Stores numeric data.
•
Date/Time
: Stores dates and times.
HireDate
and
BirthDate
are Date/Time fields.
•
Currency
: A special numeric data type used for monetary values because it prevents round-off
errors during calculations.
•
AutoNumber
: A special numeric data type that can be used for primary key fields. Fields of this
data type always are read-only, because Access automatically inserts the next number in the sequence
or a random number when a data record is created. The
EmployeeID
field is an
AutoNumber
field.
•
Yes/No
: Stores Boolean data, which can contain only one of two values, such as
On/Off
,
Yes/No
, or
True/False
.
•
OLE Object
: A special type of object or component provided by a Windows OLE server. The
Photo
field is an OLE Object type.
•
Hyperlink
: Stores the text for a hyperlink address. Access enables you to store addresses to Web
documents, network files, and local files. The hyperlink also can contain more detailed information,
such as a bookmark in a Word document, an object in an Access database, or a range of cells in an
Excel spreadsheet. After a Hyperlink field is clicked, Access attempts to load the referenced file or
document using the appropriate viewer.
As you can see, there’s a data type for just about every occasion. By examining the Employees table, you can
get a good feel for which data types are appropriate for your needs.
The Lookup Wizard is a wizard that guides you through the steps necessary to populate the Lookup tab.
You’ll find Lookup Wizard as the last entry in the Data Type drop-down list. To invoke the Lookup Wizard
for a field, select it in the Data Type drop-down list. You will never see a field with the data type set to
Lookup Wizard, even if the wizard was used to help populate a field’s Lookup tab properties.
Description
A short description about the field can be entered in the Description column. The description should provide
future viewers of a table’s design (such as yourself) with a complete explanation of the purpose the field
serves.
Note: If the field is added to an Access form, Access uses the text in the Description column as the default text
displayed in the form’s status bar area when the user is editing that field (unless you change the
Status Bar
Text
property of the form control).
Previous
Table of Contents
Next
Products
|
Contact Us
|
About Us
|
Privacy
|
Ad Info
|
Home
Use of this site is subject to certain
Terms & Conditions
,
Copyright © 1996-2000 EarthWeb Inc.
All rights
reserved. Reproduction whole or in part in any form or medium without express written
permission
of
EarthWeb is prohibited. Read EarthWeb's
privacy
statement.
|
|