ICDL Access Exam Practice Test Instant Access

Question 1

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

Question 2

Which one of the following is not a database?

AA telephone directory

BA sales catalogue.

CA newsletter.

DA price list

Answer : C

Question 3

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

Question 4

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

Question 5

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

Question 6

Which two of the following statements are true?

A<100 will find values that are greater than 100.

B>= 10 will find values that are greater than or equal to 10

C>=Sep 30 1950 will find dates that are equal to or before Sep 30th 1950.

D<=Oct 31 1956 will find dates that are equal to or after Oct 31st 1956.

E<Jan 1 1965 And > Dec 31 1963 will find all dates in 1964

Answer : B, E

Question 7

Access the option that would enable you to create a new query without the help of the Simple Query Wizard.

ASelect Queries from the objects pane -> double click on create query in design view

Answer : A

ICDL the Access Exam Practice Test