ICDL Access Exam Questions Instant Access

Question 1

A business, Cofee Golore, has moved premises. Please delete the selected field value, Camberwell Lane, from its record.

APress delete from the keyboard

Answer : A

Question 2

Change this query so that it will just find books by Spanish authors, and then run the query.

AClick on the view tool from the Query datasheet toolbar -> use the back space to delete the word Russian and or Run from the
query design toolbar and then press the button

Answer : A

Question 3

Navigate directly to the first record in this table.

APress delete from the keyboard

Answer : A

Question 4

The Payment table contains biling details for each patient. Edit the relationship between the Payment and Patient tables to prevent a

patient who has made a payment from being deleted.

ARight click on the line between Patient table and Payment table -> select Edit Relationship ... -> check the Enforce Referential
Integrity -> ok

Answer : A

Question 5

Close the Northwest Division database withou closing Microsoft Access.

AFile -> close

Answer : A

Question 6

Which two of the following statements about indexes are true?

AAn index is used to list all the fields in a database.

BYou can index any field no matter what its data type is.

CYou should index a field that is frequently sorted.

DIf an index is used it slows down database searches.

EIndexing is especially useful when working with large tables.

Answer : B, E

Question 7

We no longer need the query, Books by Americans. Delete this query now.

ARight click on the Books by Americans -> select Delete -> yes

Answer : A

ICDL the Access Exam Questions