Microsoft Office Tutorials and References
In Depth Information
Entering Records
As noted earlier, Datasheet view shows a table’s contents in rows (records) and
columns (fi elds). Each column is headed by a fi eld name inside a fi eld selector, and each
row has a record selector to its left (see Figure 1-9). Clicking a fi eld selector or a record
selector selects that entire column or row (respectively), which you then can manipulate.
A fi eld selector is also called a column selector , and a record selector is also called a
row selector .
Entering Records
With the fi elds in place for the table, you can now enter the fi eld values for each record.
Oren requests that you enter eight records in the Contract table, as shown in Figure 1-10.
Figure 1-10
Contract table records
ContractNum
3011
3026
SigningDate
2/9/2013
3/11/2013
ContractType
Residential landscape plan
Landscape plans for large-scale housing
development
Consultation for backyard, residential
Schematic plan for backyard, residential
Landscape design for two entrances
Peer plan review for town
Renovation of large multifamily housing
open space
Landscape plans for multifamily housing site
CustomerID
11001
11038
ContractAmt
$4,000.00
$165,000.00
3012
3015
3022
3017
3023
11027
11005
11043
11012
11070
$300.00
$1,500.00
$22,000.00
$2,250.00
$39,000.00
2/18/2013
3/1/2013
4/14/2013
3/1/2013
3/22/2013
3021
11040
$28,000.00
5/3/2013
To enter records in a table datasheet, you type the fi eld values below the column
headings for the fi elds. The fi rst record you enter will go in the fi 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
Figure 1-11.
Be sure to type the
numbers “0” and “1” and not
the letters “O” and “l” in
the field value.
Figure 1-11
First fi eld value entered
pencil symbol
star symbol
insertion point positioned
in CustomerID field
first Contr act m
field value entered
Search JabSto ::




Custom Search