Microsoft Office Tutorials and References
In Depth Information
Saving the Table Structure
Specifying a Primary Key in Design View
• Display the table in Design view.
• Click in the row for the field you’ve chosen to be the primary key to make it the active
field. If the primary key will consist of two or more fields, click the row selector for the
first field, press and hold down the Ctrl key, and then click the row selector for each
additional primary key field.
• In the Tools group on the Design tab, click the Primary Key button.
According to Oren’s design, you need to specify InvoiceNum as the primary key for
the Invoice table. You can do so while the table is in Design view.
To specify InvoiceNum as the primary key:
The Primary Key button
works as a toggle; you
can click it to remove the
key symbol if you want to
specify a different field as
the primary key.
1. Click in the row for the InvoiceNum field to make it the current field.
2. In the Tools group on the Design tab, click the Primary Key button. A key symbol
appears in the row selector for the first row, indicating that the InvoiceNum field
is the table’s primary key. See Figure 2-16.
Figure 2-16
InvoiceNum fi eld selected as the primary key
Primary Key button
key symbol i ndicates
the table’s primary key
Saving the Table Structure
The last step in creating a table is to name the table and save the table’s structure.
When you save a table structure, the table is stored in the database fi le (in this case, the
Belmont database fi le). Once the table is saved, you can use it to enter data in the table.
According to Oren’s plan, you need to save the table you’ve defi ned as “Invoice.”
To name and save the Invoice table:
1. Click the Save button
on the Quick Access Toolbar. The Save As dialog
box opens.
2. Type Invoice in the Table Name box, and then press the Enter key. Access saves
the Invoice table in the Belmont database. Notice that the tab for the table now
displays the name “Invoice” instead of “Table1.”
Search JabSto ::




Custom Search