Select the data type that will automatically assign a unique Customer ID number to each new customer.

Move to the next cell when you have finished.

AIn the data type column -> use the drop down list and select Auto number -> press tab from the keyboard

Answer : A

The Product code field contains a unique reference for each product. This field will be used in a lot of searches, so we should index it.

Create a suitable index for this field.

APut the cursor in the indexed box -> from the drop down list select yes (No Duplicates)

Answer : A

Create a new query using the Simple Query Wizard.

ASelect Queries from the object pane -> double click on create query by using wizard

Answer : A

Which one of the following is not a database?

AA telephone directory

BA sales catalogue.

CA newsletter.

DA price list

Answer : C

Which two of the following statements about the layout of data field and headers are true:

AYou can change the layout of a report in design view

BThe order in which you add fields in the wizard sets how they display in the report

CIf you move a Page Header control, the associated Detail control will move with it.

DYou can change the layout of a report in Print Preview.

EYou can rearrange the order of fields in a report using the Sorting and Grouping dialog box.

Answer : A, B

Free ICDL the Access Questions for ICDL the Access Exam as PDF & Practice Test Software