atch each term with the statement that best describes it.

8. Null

9. Parameter

10. Top Values query

11. Inner join

12. Action query

13. Properties

a. Characteristics that define the appearance and behavior of items within the database

b. Displays only a number or percentage of records from a sorted query

c. Displays a dialog box prompting you for criteria

d. Means that the query displays only records where joined fields from both tables are equal

e. Makes changes to data

f. A field value that does not exist

Select the best answer from the list of choices.

14. Which join type selects all records from the one (parent) table?

a. Inner

c. Central

b. Left

d. Right

15. Which of the following is a valid parameter criterion entry in the query design grid?

a. >=[Type minimum value here: ]

c. >=(Type minimum value here: )

b. >=Type minimum value here:

d. >={Type minimum value here: }

16. You cannot use the Top Values feature to:

a. Select the bottom 10 percent of records.

c. Display a subset of records.

b. Show the top 30 records.

d. Update a fields value by 5 percent.

17. Which of the following is not an action query?

a. Union query

c. Make Table query

b. Delete query

d. Append query

18. Which of the following precautions should you take before running a Delete query?

a. Check the resulting datasheet to make sure the query selects the right records.

b. Understand the relationships between the records you are about to delete in the database.

c. Have a current backup of the database.

d. All of the above

19. When querying tables in a one-to-many relationship with referential integrity enforced, which records appear (by default) on the resulting datasheet?

a. Only those with matching values in both tables.

b. All records from both tables will appear at all times.

c. All records from the one table, and only those with matching values from the many side.

d. All records from the many table, and only those with nonmatching values from the one side.

20. Which of the following is not a type of Select query?

a. Crosstab

c. Summary

b. Update

d. Parameter