Microsoft Office Tutorials and References
In Depth Information
Access Data Types
The minute, from 0 to 59 (leading 0 used for 00
The second, from 0 to 59 (no leading 0 used).
The second, from 0 to 59 (leading 0 used for 00
Tells Access to use a 12-hour clock, with an AM or
Indicates a 12-hour clock, with an am or pm
Tells Access to use a 12-hour clock, with an A or
Tells Access to use a 12-hour clock, with an a or
A Yes/No field is a small miracle of efficiency. It’s the leanest of Access data types,
because it allows only two possible values: Yes or No.
When using a Yes/No field, imagine that your field poses a yes or no question by
adding an imaginary question mark at the end of your field name. You could use a
field named InStock to keep track of whether a product is in stock. In this case, the
yes or no question is “in stock?” Other examples include Shipped (in a list of orders),
Male (to separate the boys from the girls), and Republican (assuming you’re willing
to distinguish between only two political affiliations).
Although every Yes/No field is essentially the same, you can choose to format it
slightly differently, replacing the words “Yes” and “No” with “On” and “Off ” or
“True” and “False.” You’ll find these three options in the Format menu. However, it
doesn’t make much difference because on the datasheet, Yes/No fields are displayed
with a checkbox, as shown in Figure 26-14.
The Hyperlink data type comes in handy if you want to create a clickable link to
a web page, file, or email address. You can mix and match any combination of the
three in the same table. Access handles hyperlinks a little differently in Datasheet
view. When you type text into a hyperlink field, it’s colored blue and underlined.
And when you click the link, Access pops it open in your browser (Figure 26-15).