Page 34 - Code & Click - 8
P. 34
4
5
6. Repeat steps 2 to 5 to add more fields if desired.
6
7. Click the Save button on Quick Access toolbar.
The Save Table dialog box opens.
8. Type an appropriate name for the table and click the OK button.
The table gets added to the Navigation pane.
8
9 9. On the Home tab, click the View down arrow
in the Views group, and select Datasheet view
option.
Setting the Primary Key
A Primary Key is a field or set of fields with values that are unique throughout a table. It is used to
identify records in a table. A table can only have one Primary key.
To set a Primary key for a table:
1. Click the Row selector for the
field you want to use as the 2
Primary key.
2. On the Design tab, click the 1
Primary Key button in the
Tools group.
Access sets the field as the Primary key and a key indicator appears in the Row selector.
32
