808 Chapter 26 Create Databases and Simple Tables
- 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. - Close the Customers table, clicking Yes to save the changes you have made to
the column widths and order. If you see a warning that this action will clear the
Clipboard, click Yes.
CLEAN UP Retain the MyTables database 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 open an existing table in Design view, the tabbed page shows the underlying
structure of the table.The table design page.