Question 1

Match the following number field sizes with their description.
I.AND
II.OR
III.NOT
IV.LIKE
V.BETWEEN
A.Does not meet the criteria
B.Meets one or more criteria
C.Meets both criteria
D.Uses wildcards
E.Within a range

Accepted Answer

The answer of Match the following number field sizes with...

Question 2

Match the following aggregate functions with their description.
I.Sum
II.Average
III.Count
IV.Minimum
V.Maximum
A.Largest value
B.Total value
C.Smallest value
D.Arithmetic mean
E.Number of records

Accepted Answer

The answer of Match the following aggregate functions with their...

Question 3

Match between columns
                        Premises: Sum
Average
Count
Minimum
Maximum

Accepted Answer

The Answer of Largest value and Total value and Smallest is...

Question 4

Match between columns
                        Premises: AND
OR
NOT
LIKE
BETWEEN

Accepted Answer

The Answer of Does not meet the criteria and Meets is...

Question 5

Match between columns Premises: < = > = < > < >

Accepted Answer

The Answer of Greater than or equal to and Less is...

Question 6

Match between columns
                        Premises: *
#
?
!
-

Accepted Answer

The Answer of To match any number of characters and is...

Quiz 3: Workshop 3: Queries and Data Access

Match the following number field sizes with their description. I.AND II.OR III.NOT IV.LIKE V.BETWEEN A.Does not meet the criteria B.Meets one or more criteria C.Meets both criteria D.Uses wildcards E.Within a range

Match the following aggregate functions with their description. I.Sum II.Average III.Count IV.Minimum V.Maximum A.Largest value B.Total value C.Smallest value D.Arithmetic mean E.Number of records

Match the following aggregate functions with their description.

Match the following number field sizes with their description.

Match the following operators with their description.

Match the following wildcard characters with their example