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