Create an index in the CopyID field of the Rents table that will allow creating duplicates. Save and close the table.

On the Rents table set the CopyID field as primary key. Save and close the table.

Set the ID and Description fields of the open table as primary keys. Save and close the table.

Set an index that will not allow duplicates in the Description field of the open table and change the Required property to Yes. Save and close the table.

Which of the following processes can be accelerated by the use of an Index?

Which of the following suggestions about index is true?

A primary key allows the user to …