Free ACCESS Exam braindumps download (ACCESS exam dumps Free)

QUESTION: 21

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

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

Show Answer Next Question

QUESTION: 22

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

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

Answer(s): A

Show Answer Next Question

QUESTION: 23

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

Press Enter when you are finished.

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

Answer(s): A

Show Answer Next Question

QUESTION: 24

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

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

Answer(s): A

Show Answer Next Question

QUESTION: 25

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.

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

Answer(s): A

Show Answer Next Question

Free ACCESS Exam Braindumps ICDL the Access Questions 21–25 (page: 6)

QUESTION: 21

QUESTION: 22

QUESTION: 23

QUESTION: 24

QUESTION: 25

Free ACCESS Exam Braindumps
ICDL the Access Questions 21–25 (page: 6)