Database Reference
In-Depth Information
TIP
Access stores the number the way you entered it but displays ($45.35), the
default format for negative currency numbers. Your currency symbol might be
different—for example, it might be the pound, peso, or euro symbol—because
Access uses your computer's region and language settings to determine the dis-
play format for date, time, currency, and other numbers. If you want the symbol to
remain the same no matter what the region and language settings, you can create
a custom format to ensure that currency values always display a specific symbol.
For information about custom formats, see the sidebar “Creating custom formats”
later in this chapter.
13
In the
fNumber
field, enter
Five hundred
, and then press
Tab
.
14
When Access displays a message that it cannot accept this type of entry in this field,
click
Enter new value
in the list of options, enter
500
, and press
Tab
.
15
In the
fDate
cell, enter
123456
, and press
Tab
.
16
When Access blocks the entry, click the
Calendar
button to the right of the field, and
click
Today
to insert today's date. Then press
Tab
.
TIP
All Date/Time fields come with an associated interactive calendar. Using the Cal-
endar button to insert a date works well if the date you want is close to the current
date. (You can click the arrows at either end of the title bar to display the previous
or next month.) However, for distant dates such as birthdates, it is easier to ignore
the Calendar button and enter the date. Access accepts almost any entry that can be
recognized as a date and displays it in the format you specified when you created the
field. If you enter a month and day but no year in a Date/Time field, Access assumes
the date is in the current year. If you enter a month, day, and two-digit year from 00
through 29, Access assumes the year is 2000 through 2029. If you enter a two-digit
year that is greater than 29, Access assumes you mean 1930 through 1999.
17
In the
fBoolean
field, try to enter
abc
and
123
. Then click several times anywhere in
the field to toggle the check box between the selected and cleared states, finishing
with the field in the selected state.
The table, after entering the correct type of data in each field.
