Unit 10 evaluation test. Action queries

There is only one correct answer to each question. Click on the answer you consider to be correct.

Answer all the questions and press the Revise button to see the results.

If you press Reset you will be able to repeat the evaluation.

1. In a Delete query I can group the records.
a) True.

b) False.


2. To run an action query we can use the or the .
a) True.

b) False.

3. We can have various source tables in an action query.

a) True.

b) False.


4. I can update a field with a value found in another table.
a) True.

b) False.

5. A Delete query without criteria will delete only the first record from the query source.
a) True.

b) False.


6. The button serves to ...
a) ...open the help menu.

b) ...add a Total: row to the query.

c) ...run the query.

7. In an Update query I can put a criteria...
a) ...to indicate the rows that need to be updated.

b) ...I can not put any criteria.

c) ...to indicate the columns that need to be updated.

8. In an Update query various columns can be updated.
a) Yes.

b) Always and when the column is not being used to update another.

c) You can not update various columns.


9. I want to introduce records into a table that does not exist.
a) Define an Append query.

b) Define a Make-table query.

c) Define an action query.

d) All three answers are false.


10. In an Append query...
a) ..put the table that contains the values to insert in the table zone.

b) ...I can put nothing in the table zone if the values to insert are fixed.

c) Both answers are valid..




   

Ev. Page
10.1

Aviso legal: Uso off-line autorizado a alumnos de aulaClic exclusivamente. No está permitido utilizar estos cursos en empresas, academias o centros de enseñanza privados.

© aulaClic. All rights reserved. Reproduction in any form whatsoever is prohibited. April-2006.