Unit F

Question 1

record source

Answer 1

report property that determines what fields and records the report will display

Question 2

select query

Answer 2

retrieves fields from related tables and dispalus records ina datasheet

Question 2

wildcard character

Answer 2

asterisk (*) or question mark (?) used in a query criteria

Question 3

sorting

Answer 3

placing the records of a datasheet in a certain order

Question 3

AND criteria

Answer 3

entered on one row of the query design grid

Question 3

OR crietria

Answer 3

entered on more than one row of the query design grid

Question 4

the query datasheet can best be described as a

Answer 4

logical view of the selected data from underlying tables

Question 5

queries may not be used to

Answer 5

set the primary key field for a table

Question 6

when you update data in a table that is also selected in a query

Answer 6

the updates data is automatically displayed in the query

Question 6

which of the following is not an aggregate function available to a summary query

Answer 6

subtotal

Question 7

the order in which records in a query are sorted is detrmined by

Answer 7

the alphabetic order of the field names

Question 8

a crosstab query is generally constrcuted with how many fields

Answer 8

3

Question 9

in a crosstab query which field is the most likely candidate for the value position

Answer 9

cost