ICDL Access Exam Practice Test Instant Access

Question 1

This query has been designed to find all patients who have made payments since January 1, 2003.

AOption
Run this query now.

Answer : A

Question 2

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 3

The book in record 5 is no longer available Delete this record from the database.

AClick on the Delete Record tool from the form view toolbar -> yes

Answer : A

Question 4

Navigate to the next record in this form.

AOption

Answer : A

Question 5

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 6

Which of these fields would be best suited to use as the Primary Key for this table?

ASelect the gray area before the employee ID

Answer : A

Question 7

Navigate directly to the first record in this table.

APress delete from the keyboard

Answer : A

ICDL Access ICDL the Access Exam Practice Test