ICDL Access Exam Practice Test Instant Access

Question 1

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 2

Create a new blank database.

AClick on the new tool from the database toolbar -> select database -> ok

Answer : A

Question 3

Delete both the label and text box Enrolment from this form.

Save the changes without closting the form.

ASelect the gray box that contains the word Enrolment -> press delete from the keyboard -> click on the save button

Answer : A

Question 4

Delete the one-to-many relationship between the Patient and Payment tables.

ARight click on the line -> select delete -> yes

Answer : A

Question 5

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 6

Use the search tools provided by Access to find the book with the unique (ISBN) code 3546-1236-7.

AEdit -> find -> type 3546-1236-7 in the find what box -> click find next button

Answer : A

Question 7

Enter a validation rule to ensure that entries into this field must be numbers greater than 10. Press Enter when you have finished.

AIn the validation Rule box type >10 -> press enter from the keyboard

Answer : A

ICDL the Access Exam Practice Test