Page 81 - Computer Class 07

4. Select the field or fields that you want to use as the primary key.

To select one field, click the row selector for the field you want.

To select more than one field, hold down Ctrl key and then click the row selector
for each field.

5
The Design tab will appear.

5. Click on the Primary
key in the Tools group.

A key indicator is added to the left of the field or fields that you specify as the
primary key.

Removing a Primary Key

When removing the primary key, the field that formerly served as primary key will no

longer provide the primary means of identifying a record. Note that removing the
primary key would not delete the fields from your table, but will remove the index that
was created for the primary key when building access database.

Working with Objects

In Access 2016, database objects are displayed in the Navigation Pane.
You can customise the categories and groups of objects in the Navigation Pane. You

can also hide objects, groups or even the entire Navigation Pane. Access 2016
provides several categories that you can use right away and also lets you create
custom categories and groups.

Using Database Objects

MS Access uses “objects” to help the user list and organise information, as well as
prepare specially designed reports. When you create a database, Access offers you

Tables, Queries, Forms, Reports, Macros and Modules. Databases in Access are
composed of many objects but the following are the major objects−

Computer-7 81