Which of the following functions counts the number of records that have a value in the field?
Avg
Sum
Count
Max
When structuring a criteria expression with a parameter that includes one or more wildcards, where can the wildcards be positioned?
at the end
at the beginning
at the beginning and end
any of the above
Which of the following criterion expressions searches for a ShippingDate field that is greater than January 1, 2019?
>1/1/2019
>"1/1/2019"
>#1/1/2019#
>=#1/1/2019#
Which of the following displays when you build the formula Agent's Name: Left([FirstName],1) &". "&[LastName].
John Smith
John.Smith
J.Smith
J. Smith
After you create a query in Design view, what do you need to do in order to see the results?
Select the table to include in the query.
Select the fields to include in the query.
Enter criterion into the query.
Run the query.
Which of the following functions rounds a value?
Left
UCase
iif
Round
How many fields can you add to the query design grid?
5 or fewer
6 to 10
11 to 15
as many as you like
Which symbol must be used to specify criterion for the Date/Time data type?
$
?
*
#
Which of the following groups of commands includes buttons to insert and delete fields in the design grid?
Query Wizard
Query Design
Query Setup
Query Type
Which of the following is added to the design grid of a summary query?
AND operator
OR operator
Total row
Count function
