Free ACCESS Exam Braindumps (page: 7)

Page 6 of 20

Use Filter By Selection to filter the records of all employees whose First Name begins with S.

  1. In the first name select the S letter from the word Saul -> click on the filter by selection tool from the Table datasheet toolbar

Answer(s): A



Save the above query and give it the name Employee Salaries.

  1. Click on save tool -> type the name Employee Salaries -> ok

Answer(s): A



Find all payments made on or after 06/06/2002.



Press Enter when you are finished.

  1. In the payment date column -> in the criteria box -> type >= 06/06/2002 -> press enter

Answer(s): A



We no longer need the query, Books by Americans. Delete this query now.

  1. Right click on the Books by Americans -> select Delete -> yes

Answer(s): A






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

ACCESS Discussions & Posts