Microsoft Office Tutorials and References
In Depth Information
Saving a Table
Saving a Table
• Click the Save button on the Quick Access Toolbar. The Save As dialog box opens.
• In the Table Name box, type the name for the table.
• Click the OK button.
According to Oren’s plan, you need to save the table with the name “Contract.”
To save and name the Contract table:
1. Click the Save button
on the Quick Access Toolbar. The Save As dialog
You can also use the Save
command in Backstage
view to save and name a
2. With the default name Table1 selected in the Table Name box, type Contract ,
and then click the OK button. The tab for the table now displays the name
“Contract,” and the Contract table design is saved in the Belmont database.
Notice that after you saved and named the Contract table, Access sorted and
displayed the records in order by the values in the ContractNum ﬁ eld because it is the
primary key. If you compare your screen to Figure 1-10, which shows the records in the
order you entered them, you’ll see that the current screen shows the records in order by
the ContractNum ﬁ eld values.
Oren asks you to add two more records to the Contract table. When you add a record
to an existing table, you must enter the new record in the next row available for a new
record; you cannot insert a row between existing records for the new record. In a table
with just a few records, such as the Contract table, the next available row is visible on
the screen. However, in a table with hundreds of records, you would need to scroll the
datasheet to see the next row available. The easiest way to add a new record to a table is
to use the New button, which scrolls the datasheet to the next row available so you can
enter the new record.
To enter additional records in the Contract table:
1. If necessary, click the first record’s ContractNum field value ( 3011 ) to make it the
2. Click the Home tab on the Ribbon.
3. In the Records group, click the New button. The insertion point is positioned
in the next row available for a new record, which in this case is row 9. See