Microsoft Office Tutorials and References
In Depth Information
Adding New Fields
4. Type ContractAmt to replace the highlighted name “Field1.” The fourth field in
the Contract table is the SigningDate field. Because this field will contain date
values, you’ll add a field with the Date/Time data type next—this time using the
Click to Add column.
5. Click the Click to Add column heading. Access displays a list of available data
types from which you can choose the data type for the new field you’re adding.
6. Click Date & Time in the list. Access adds a fourth field to the table.
7. Type SigningDate to replace the highlighted name “Field1,” and then press the
Enter key. The Click to Add column becomes active and displays the list of field
data types. The fifth and final field in the Contract table is the ContractType field,
which will contain brief descriptions of the contracts. The Text data type is
suitable for this field.
8. Click Text in the list, and then type ContractType to replace the highlighted
name “Field1.” All five fields are now entered for the Contract table.
Some of the field names are not completely visible, so you need to resize the
Trouble? If you pressed the Tab or Enter key after typing the ContractType field
name, press the Esc key to close the Click to Add list.
You can also type the
first letter of a data type
to select it and close the
Click to Add list.
9. Place the pointer on the vertical line between the ContractNum and CustomerID
field names until the pointer changes to a
10. Double-click the pointer. The ContractNum column is resized and now displays
the full field name.
Trouble? If you click the arrow on the ContractNum column heading by mistake,
a menu will open. Simply click the arrow again to close the menu, and then repeat
Steps 9 and 10.
11. Double-click the pointer on the vertical line to the right of the CustomerID,
ContractAmt, SigningDate, and ContractType column headings to resize the
columns in the datasheet. When finished, click the first column for row 1. Your
datasheet should now look like the one shown in Figure 1-9.
Table with all ﬁ elds entered
five fields e ntered
and columns resized
record (row) selector
field (column) selector
values f or first record
will go in this row
The table contains three Text fields (ContractNum, CustomerID, and
ContractType), one Currency field (ContractAmt), and one Date/Time field
(SigningDate). You’ll learn more about field data types in Tutorial 2.