Microsoft Office Tutorials and References
In Depth Information
Entering Records
Trouble? If you make a mistake when typing a value, use the Backspace key to
delete characters to the left of the insertion point or the Delete key to delete
characters to the right of the insertion point. Then type the correct value. To correct a
value by replacing it entirely, press the Esc key, and then type the correct value.
Notice the pencil symbol that appears in the row selector for the new record. The
pencil symbol indicates that the record is being edited. Also notice the star
symbol that appears in the row selector for the second row. The star symbol
identifies the second row as the next row available for a new record.
2. Type 11001 (the CustomerID field value for the first record), and then press
the Tab key. Access enters the field value and moves the insertion point to the
ContractAmt column.
3. Type 4000 (the ContractAmt field value for the first record), and then press the
Tab key. Notice that Access formats the field value with a dollar sign, a comma,
and two decimal places—displaying it as $4,000.00—even though you did not
enter the value this way. This is because the ContractAmt field has the Currency
data type, which automatically formats field values in this way. You’ll learn more
about formatting field values later in this text.
4. Type 2/9/13 (the SigningDate field value for the first record), and then press
the Tab key. Access displays the year as “2013” even though you entered only
the final two digits of the year. This is because the SigningDate field has the
Date/Time data type, which automatically formats dates with four-digit years.
Trouble? Depending on your Windows date setting, your SigningDate field
values might be displayed in a different format. This difference will not cause any
problems.
5. Type Residential landscape plan (the ContractType field value for the first
record), and then press the Tab key. The first record is entered into the table, and
the insertion point is positioned in the ContractNum field for the second record.
The pencil symbol is removed from the first row because the record in that row is
no longer being edited. The table is now ready for you to enter the second record.
See Figure 1-12.
Figure 1-12
Datasheet with fi rst record entered
value displayed
with a dollar sign,
comma, and two
decimal places
next row available
for a new record
value displayed with
a four-digit year
field value is not
completely visible
Note that the ContractType field value is not completely displayed. You’ll resize
the table columns, as necessary, after you enter all the data.
Now you can enter the remaining seven records in the Contract table.
Search JabSto ::




Custom Search