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