Database Reference
In-Depth Information
13
When the Phone field is adjacent to the LastName field, in the Records group,
click More, and then click Unfreeze All Fields to restore the fields to their normal
condition.
TIP The commands to hide, unhide, freeze, and unfreeze columns are also available
from the shortcut menu that appears when you right-click a field name.
Suppose we want to always display the customer's phone number next to his or her
name. Let's move the Phone column.
2
14
Click the Phone field name to select that field. Then drag the field to the left,
releasing the mouse button when the thick black line appears to the right of the
LastName field.
15
Close the Customers table, clicking Yes to save the changes you have made to the
column widths and field order. If a message box appears, warning you that this action
will clear the Clipboard, click Yes .
CLEAN UP Keep the MyTables database open for use in later exercises.
Refining table structure
Although you can create the structure of a database in Datasheet view, some structural
refinements can be carried out only in Design view. When you are familiar with tables,
you might even want to create your tables from scratch in Design view, where you have
more control over the fields. You can open a new table in Design view by clicking the Table
Design button in the Tables group on the Create tab.
When you display an existing table in Design view, the page shows the underlying structure
of the table.
Search WWH ::




Custom Search