Microsoft Office Tutorials and References
In Depth Information
As noted earlier, Datasheet view shows a table’s contents in rows (records) and
columns (ﬁ elds). Each column is headed by a ﬁ eld name inside a ﬁ eld selector, and each
row has a record selector to its left (see Figure 1-9). Clicking a ﬁ eld selector or a record
selector selects that entire column or row (respectively), which you then can manipulate.
A ﬁ eld selector is also called a column selector , and a record selector is also called a
row selector .
With the ﬁ elds in place for the table, you can now enter the ﬁ eld values for each record.
Oren requests that you enter eight records in the Contract table, as shown in Figure 1-10.
Contract table records
Residential landscape plan
Landscape plans for large-scale housing
Consultation for backyard, residential
Schematic plan for backyard, residential
Landscape design for two entrances
Peer plan review for town
Renovation of large multifamily housing
Landscape plans for multifamily housing site
To enter records in a table datasheet, you type the ﬁ eld values below the column
headings for the ﬁ elds. The ﬁ rst record you enter will go in the ﬁ rst row (see Figure 1-9).
To enter the first record for the Contract table:
1. In the first row for the ContractNum field, type 3011 (the ContractNum field
value for the first record), and then press the Tab key. Access adds the field
value and moves the insertion point to the right, in the CustomerID column. See
Be sure to type the
numbers “0” and “1” and not
the letters “O” and “l” in
the field value.
First ﬁ eld value entered
insertion point positioned
in CustomerID field
first Contr act m
field value entered