Microsoft Office Tutorials and References
In Depth Information
Adding Records to a New Table
Figure 2-21
First record entered in the Invoice table
field value displayed
in the Currency
format with two
decimal places
field value displayed
according to the
custom date for mat
check mark
indicates a “Yes”
value for the field
Now you can add the remaining three records. As you do, you’ll learn a shortcut for
inserting the value from the same fi eld in the previous record.
To add the next three records to the Invoice table:
1. Refer to Figure 2-20 and enter the values in the second record’s Invoice Num,
Contract Num, and Invoice Date columns.
Notice the value in the second record’s Invoice Item column, “Schematic Plan.”
This value is the exact same value as in the first record. You can quickly insert the
value from the same column in the previous record using the Ctrl + ‘ (apostrophe)
keyboard shortcut.
2. In the Invoice Item column, press the Ctrl + ‘ keys. Access inserts the value
“Schematic Plan” in the Invoice Item column for the second record.
3. Press the Tab key to move to the Invoice Amt column. Again, the value you need
to enter in this column—$1,500.00—is the same as the value for this column in
the previous record. So, you can use the keyboard shortcut again.
4. In the Invoice Amt column, press the Ctrl + ‘ keys. Access inserts the value
$1,500.00 in the Invoice Amt column for the second record.
5. Press the Tab key to move to the Invoice Paid column, press the spacebar to
insert a check mark in the check box, and then press the Tab key. The second
record is entered in the Invoice table.
6. Refer to Figure 2-20 to enter the values for the third and fourth records, using the
Ctrl + ‘ keys to enter the value in the fourth record’s Invoice Amt column. Also, for
both records, the invoices have not been paid. Therefore, be sure to press the Tab
key to leave the Invoice Paid column values unchecked (signifying “No”).
7. Resize the columns, as necessary, so that all field values are completely visible.
Then click the Invoice Num column for the next new record. Your table should
look like the one in Figure 2-22.
Search JabSto ::




Custom Search