Microsoft Office Tutorials and References
In Depth Information
two digits following the decimal point. Like numeric ﬁ elds, you can use currency
ﬁ elds in arithmetic operations. Access assigns a size to currency ﬁ elds automatically.
Table 1–1 shows the other data types that are available.
Table 1–1 Additional Data Types
Field can store a variable amount of text or combinations of text and numbers where
the total number of characters may exceed 255.
Field can store dates and times.
Field can store a unique sequential number that Access assigns to a record. Access
will increment the number by 1 as each new record is added.
Field can store only one of two values. The choices are Yes/No, True/False, or On/Off.
Field can store an OLE object, which is an object linked to or embedded in the table.
Field can store text that can be used as a hyperlink address.
Field can contain an attached ﬁ le. Images, spreadsheets, documents, charts, and so
on can be attached to this ﬁ eld in a record in the database. You can view and edit
the attached ﬁ le.
In the Client table, because the Client Number, Client Name, Street, City, and
State can all contain letters, their data types should be Text. The data type for Postal Code
is Text instead of Number, because postal codes are not used in arithmetic operations. You
do not add postal codes or ﬁ nd an average postal code, for example. The Amount Paid and
Current Due ﬁ elds both contain monetary data, so their data types should be Currency.
Similarly, in the Recruiter table, the data type for the Recruiter Number, Last Name,
First Name, Street, City, State, and Postal Code ﬁ elds all should be Text. The Commission
ﬁ eld contains monetary amounts, so its data type should be Currency. The Rate ﬁ eld
contains a number that is not a currency amount, so its data type should be Number.
Identifying and Removing Redundancy
Redundancy means storing the same fact in more than one place. It usually results
from placing too many ﬁ elds in a table — ﬁ elds that really belong in separate tables —
and often causes serious problems. If you had not realized there were two objects, clients
and recruiters, for example, you might have placed all the data in a single Client table.
Figure 1–3 shows a portion of this table with some sample data. Notice that the data for a
given Recruiter (number, name, address, and so on) occurs on more than one record. The
data for Camden Reeves is repeated in the ﬁ gure.
name of recruiter 24
appears more than once