Unit B

Question 1

query grid

Answer 1

the lower pane in query design view

Question 2

field selector

Answer 2

the thin gray bar above each field in the query grid

Question 3

filter

Answer 3

creates a temporary subset of records

Question 4

filter by selectrion

Answer 4

a fast and easy way t ofilter the recoirds for an exact match

Question 5

sorting

Answer 5

putting recorids in ascending otr descending oder based on the values of a field

Question 5

field lists

Answer 5

small windows that display field names

Question 6

join line

Answer 6

identifies which fields are uised to establish a relationshiop betwen 2 tabes

Question 7

is null

Answer 7

crierion that fdinds all records where no entry has been made in the field

Question 8

crieria

Answer 8

limiitng conditions used to restrict the number of records that are selected in a query

Question 9

syntax

Answer 9

rules that determine how criteria are entered

Question 10

wildcard

Answer 10

used to serach for a pattern of characters

Question 11

and criteria

Answer 11

must all be true for the record to be selected

Question 12

SQL stands for what

Answer 12

structured query language

Question 13

a query is sometimes caleld a logical view of data because

Answer 13

queries do not store data-they only display a view of data

Question 14

OR criteria

Answer 14

using two or more rows of the query grid to slect only those records that meet given crieria

Question 15

what is not true about a query

Answer 15

a query is the same thing as a filter