Free ACCESS Exam braindumps download (ACCESS exam dumps Free)

QUESTION: 26

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

Click 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(s): A

Show Answer Next Question

QUESTION: 27

Sort this query so that the most recent payments display at the top of the datasheet.

Put the insertion point in the payment date field -> click on the sort descending tool from the Table datasheet toolbar

Answer(s): A

Show Answer Next Question

QUESTION: 28

A Wizard is being used to create a new report. Base this report on the Extract table, and add all the fields from the table to the report's design.

Exhibit A:

Exhibit B:

The answer is Exhibit B.

Answer(s): A

Show Answer Next Question

QUESTION: 29

Group the books in this report by authors' surname with books' titles displayed in alphabetical order.

Select Surname -> click on > -> click next -> from the first drop down list Select Title -> click finish

Answer(s): A

Show Answer Next Question

We are compiling tourism statistics. We need this report to sort results in month order and tell us the minimum number of bed nights sold.

Please carry out the necessary steps so that the report will produce these details.

From the first drop down list select month -> click on summary options... button -> check the check box in the min column and bed nights row -> ok

Answer(s): A

Show Answer Next Question

Free ACCESS Exam Braindumps
ICDL the Access Questions 26–30 (page: 7)

QUESTION: 26

QUESTION: 27

QUESTION: 28

QUESTION: 29

QUESTION: 30

Free ACCESS Exam Braindumps ICDL the Access Questions 26–30 (page: 7)

QUESTION: 26

QUESTION: 27

QUESTION: 28

QUESTION: 29

QUESTION: 30

Free ACCESS Exam Braindumps
ICDL the Access Questions 26–30 (page: 7)