Free ACCESS Exam Braindumps (page: 8)

Page 7 of 20

Add the appropriate field from the Employee table to the 3rd column of the grid so that this query wil be able to sort employee records according to their age.

  1. In the third column -> in the field box -> use the drop down list to select the Birth Date

Answer(s): A



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

  1. 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



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

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

Answer(s): A



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:

  1. The answer is Exhibit B.

Answer(s): A






Post your Comments and Discuss ICDL ACCESS exam with other Community members:

ACCESS Discussions & Posts