Page 48 - Computer - 8

Knowledge Discovery Subject Enrichment

To select a Primary key with multiple fields, hold down the Ctrl key and click the Row selector for each field.

To remove the Primary key from a table:

1. Select the Primary key field.
2. On the Table Tools Design tab, in the Tools group, click the Primary key button.
Access removes the Primary key from the field and the key indicator disappears.

3
Modifying the Table Design
You can modify a table’s design by adding, deleting,
renaming, or moving a field in the Design view.

1
Adding a New Field

To add a new field to a table:
2
1. Open the table in the Design view.

2. Click the Row selector of the field above which you want to add a new field.

3. On the Table Tools Design tab, click the Insert Rows button in the Tools group.
Access adds a new field to the table. 2

Deleting a Field

To delete a field from a table:
1. Click the Row selector of the field you

want to remove.

2. On the Table Tools Design tab, click the 1
Delete Rows button in the Tools group.

Access removes the field from the table.

Knowledge Discovery Subject Enrichment

Access lets you delete a field from a table, only if the table does not contain any data for the field. In
case, the field to be deleted contains data, a warning message is displayed.

46