Question # 1 When creating a simple query through the Query Wizard, what are the options in the last screen?

a) Convert the query to crosstab.

b) Open the query to view information.

c) Save the query as a form.

d) Modify the query design.

Answer:

Question # 2 How do you run a query after it has been created?

a) On the Home tab, click Selection.

b) Select it in the Navigation Pane and click Space.

c) Double-click it in the Navigation Pane.

d) On the File tab, click Open.

Answer:

Question # 3 How do you rename a query?

a) Double-click it in the Navigation pane.

b) Right-click it in the Navigation pane and select Rename.

c) Select it in the Navigation pane and press Enter.

d) Open the Object Properties and change the name.

Answer:

Question # 4 Before creating a query from multiple tables, you must first ensure that the tables have a defined ___________.

Question # 5 In order to view records in one table that do not have a matching record in another table, what query do you use?

a) Crosstab

b) Find Duplicates

c) Find Unmatched

d) Find Matched

Answer:

Question # 6 On how many tables can the Find Duplicates query run?

a) just one

b) two that have a relationship

c) two that do not have a relationship

d) three

Answer: