Page 47 - Computer - 8
P. 47
4. Type a short description about the field in the
Description column. (Optional) 4
5. Set the various properties for the field in
the Field Properties pane. 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.
8
The table gets added to the Navigation pane.
9. On the Home tab, click the View down arrow in the Views group, and select Datasheet view
option.
9
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 Table Tools Design tab, 1
click the Primary Key button in
the Tools group.
Access sets the field as the Primary key and a key indicator appears in the Row selector.
45
