Unit B Flashcards
query grid
the lower pane in query design view
field selector
the thin gray bar above each field in the query grid
filter
creates a temporary subset of records
filter by selectrion
a fast and easy way t ofilter the recoirds for an exact match
sorting
putting recorids in ascending otr descending oder based on the values of a field
field lists
small windows that display field names
join line
identifies which fields are uised to establish a relationshiop betwen 2 tabes
is null
crierion that fdinds all records where no entry has been made in the field
crieria
limiitng conditions used to restrict the number of records that are selected in a query
syntax
rules that determine how criteria are entered
wildcard
used to serach for a pattern of characters
and criteria
must all be true for the record to be selected
SQL stands for what
structured query language
a query is sometimes caleld a logical view of data because
queries do not store data-they only display a view of data
OR criteria
using two or more rows of the query grid to slect only those records that meet given crieria