results of a query may be viewed at any time by clicking the __ button in the results group on the ribbon |
run |
the query type that gives access an example of the information being requested and retrieves information based precisely on matching the example is which type of query? |
query by example (QBE) |
the process of adding, modifying and deleting records in a database to keep the records current and accurate is referred to as __ a database |
maintaining |
which record modification mode is used to insert or delete characters in a field value based on the location of the insertion point? |
editing mode |
which keyboard shortcut selects the first field value in the first record when in navigation mode? |
Ctrl+Home |
the __ command removes the display of one or more fields in data sheet view |
hide fields |
in the accompanying figure, how is the match type specified to find the characters "1638" |
entire field value |
which view must be used to delete an entire record? |
datasheet |
a query based on more than one table is a(n) _ query |
multitable |
queries based on more than one table, must have a _ field |
common |
data may be sorted in a table data sheet, a form, and a |
query datasheet |
when the sort field data for each record in a database is different, the sort field is _ |
unique |
the primary key of a table must be unique for each record; however, the _ sort field does not have to be unique |
primary |
in a query, access sorts fields based on the sort field that is _ in the design grid of the query window |
leftmost |
the criteria entered in the figure above are an example which logical operator? |
and |
based on the criterion for the birthdate field in the above image, the query will return all patients with a birth date _ |
on or before 12/31/1956 |
the + symbol is an example of a _ operator |
arithmetic |
the expression builder dialog box is available from which group on the query design tab on the ribbon? |
query setup |
a calculated field is formatted using the _ for the field |
property sheet |
a calculated field created in a query generates results when _ |
when the query is run |
which aggregate function would be used to calculate the lowest field value for the selected records? |
minimum |
which aggregate function supports the yes/no field type data? |
count |
to add a row labeled "total" to a query design click the _ button in the show/hide group on the design tab on the ribbon |
totals |
_ is the default entry for each field in the total row of the query design grid |
group by |
the default group in the navigation pane is |
all access objects |
which comparison operator matches a pattern that includes wildcards? |
like |
statistical information such as totals and averages is calculated using _ |
aggregate functions |
access t3
Share This
Unfinished tasks keep piling up?
Let us complete them for you. Quickly and professionally.
Check Price