Question 1

In the accompanying figure, which checked option will include null values in the filtered results?
A) (Select All)
B) (Blanks)
C) Bloomfield
D) (Select All) and (Blanks)

Accepted Answer

The answer of 
In the accompanying figure, which checked option...

Question 2

The value of a field containing no information is a ____ value.
A) blank
B) zero
C) concatenated
D) null

Accepted Answer

Null is the proper term used in databases to represent a field containing no information. A blank value may still have a space or character, and zero implies a numerical value of nothing. Concatenated means to combine several values together.

Question 3

Which of the following is an example of a parameter query prompt criterion?
A) [Type the state:]
B) Prompt: "Type the state:"
C) *Type the state:*
D) {Type the state:}

Accepted Answer

The parameter query prompt criterion should be enclosed in brackets [ ] to indicate that it is a parameter. The prompt should also be included within the brackets, but should not be enclosed in quotes or other characters. Therefore, option A is the correct format for a parameter query prompt criterion.

Question 4

In the accompanying figure, the ____ for the current field is/are indicated in the box designated by the arrow.
A) data options
B) filter choices
C) auto text
D) sort option

Accepted Answer

The arrow in the figure is pointing towards the box where the filter choices for the current field are indicated. A filter is used to limit the data displayed in the table, based on specific criteria.

Question 5

A ____ query uses functions, such as Sum and Count, to perform arithmetic operations on selected records.
A) parameter
B) select
C) crosstab
D) simple

Accepted Answer

The answer of A ____ query uses functions, such as...

Question 6

In the accompanying figure, which of the following is the falsepart of the calculated expression?
A) IIF
B) IsNull(Parent)
C) LastName & ", " & FirstName
D) Parent & "(Parent)"

Accepted Answer

The answer of 
In the accompanying figure, which of the...

Question 7

In the accompanying figure, what is the condition for the calculated expression?
A) Inspection
B) IsNull(Parent)
C) IsNull
D) & " (Parent)"

Accepted Answer

The IsNull(Parent) expression checks whether the Parent field is null or not. This condition is used to determine whether to display the text "(Parent)" after the value in the calculated field. The other options are not relevant to this specific scenario.

Question 8

To add more flexibility and functionality to a parameter query, comparison operators, such as ___, may be added to the original criterion.
A) Like
B) Unlike
C) IsIn
D) IsNull

Accepted Answer

The Like operator is used to add wildcard characters to a parameter query, making it more flexible by allowing partial matches to be returned.

Question 9

Which of the following pattern match selection criteria would return zip codes with the characters 704 in the first three spaces.
A) IIf (704*)
B) Like "704*"
C) Like *704*
D) Find "704*"

Accepted Answer

The Like "704*" selection criteria uses wildcards to match any characters that follow "704" in the first three spaces of the zip code.

Question 10

The ____ function tests a condition and returns one of two values; the function returns the first value if the condition is true and the second value if the condition is false.
A) IIf
B) Pmt
C) IsNull
D) NPV

Accepted Answer

The IIf function in Microsoft Excel tests a condition and returns one of two possible values depending on whether the condition is true or false. The first value is returned if the condition is true, and the second value is returned if the condition is false.

Question 11

Which of the following illustrates a calculated field with the name of the calculated field in the proper format?
A) [Donation]>=2500
B) DonationsGreaterThan2500: [Donation]>=2500
C) >=2500[Donation]
D) [Donation]:DonationsGreaterThan2500:>=2500

Accepted Answer

Choice B properly formats the calculated field with a name followed by a colon and the calculation. The other choices either have the calculation before the field name or do not include a proper name for the calculated field.

Question 12

A criterion may be negated by using the ____ logical operator.
A) And
B) Or
C) Like
D) Not

Accepted Answer

The negation of a criterion can be achieved by using the "Not" logical operator.

Question 13

The accompanying figure is an example of criteria for a ____ query using the Query Wizard.
A) simple
B) find unmatched
C) find matched
D) crosstab

Accepted Answer

The answer of 
The accompanying figure is an example of...

Question 14

The ____ comparison operator is used to select records by matching field values specific to a pattern that includes one or more wildcard characters.
A) Between
B) More
C) In
D) Like

Accepted Answer

The Like comparison operator is used to select records by matching field values specific to a pattern that includes one or more wildcard characters. The other options (Between, More, In) do not have the same functionality as the Like operator.

Question 15

The aggregate function which returns the number of nonnull field values is the ____ function.
A) Max
B) Sum
C) Avg
D) Count

Accepted Answer

The Count function returns the number of nonnull field values. Therefore, it is the best choice for this scenario. The other aggregate functions (Max, Sum, and Avg) all compute some sort of mathematical calculation, rather than simply counting nonnull values.

Question 16

In the accompanying figure, which of the following is the truepart of the calculated expression?
A) Patient:
B) IsNull(Parent)
C) LastName & ", " & FirstName
D) Parent & "(Parent)"

Accepted Answer

The calculated expression consists of concatenating the LastName and FirstName fields, separated by a comma and a space. This will result in the full name of the patient, which is a string and therefore considered the "truepart" of the expression. The other options do not result in a string and do not accurately represent the truepart of the expression.

Question 17

Crosstab queries may use which of the following aggregate functions?
A) Like
B) Not
C) Var
D) Between

Accepted Answer

Crosstab queries may use aggregate functions such as Sum, Count, Avg, Min, Max, StDev, and Var. Therefore, the correct choice is C, which represents the Var aggregate function. Choices A, B, and D are not aggregate functions and cannot be used in crosstab queries.

Question 18

Which comparison operator defines a condition with a list of two or more values for a field and includes records when the field matches one value from the list in the query results?
A) Like
B) Between
C) In
D) Or

Accepted Answer

The "In" operator defines a condition with a list of two or more values for a field and includes records when the field matches one value from the list in the query results. This is the best choice for this scenario.

Question 19

The calculated expression =City & "," & State & " " & ZipCode is an example of ____.
A) concatenation
B) ampersand
C) AutoFilter
D) a parameter query

Accepted Answer

The calculated expression joins or combines different strings of text or variables together, which is known as concatenation. The "&" symbol specifically indicates concatenation in this case.

Question 20

The standard naming convention prefix tag for a query used to identify the object type is ____.
A) Query
B) QURY
C) qry
D) QRY#

Accepted Answer

The standard naming convention prefix tag for a query used to identify the object type is "qry".

Quiz 1: Access: Creating Advanced Queries and Enhancing Table Design

In the accompanying figure, which checked option will include null values in the filtered results?

The value of a field containing no information is a ____ value.

Which of the following is an example of a parameter query prompt criterion?

In the accompanying figure, the ____ for the current field is/are indicated in the box designated by the arrow.

A ____ query uses functions, such as Sum and Count, to perform arithmetic operations on selected records.

In the accompanying figure, which of the following is the falsepart of the calculated expression?

In the accompanying figure, what is the condition for the calculated expression?

To add more flexibility and functionality to a parameter query, comparison operators, such as ___, may be added to the original criterion.

Which of the following pattern match selection criteria would return zip codes with the characters 704 in the first three spaces.

The ____ function tests a condition and returns one of two values; the function returns the first value if the condition is true and the second value if the condition is false.

Which of the following illustrates a calculated field with the name of the calculated field in the proper format?

A criterion may be negated by using the ____ logical operator.

The accompanying figure is an example of criteria for a ____ query using the Query Wizard.

The ____ comparison operator is used to select records by matching field values specific to a pattern that includes one or more wildcard characters.

The aggregate function which returns the number of nonnull field values is the ____ function.

In the accompanying figure, which of the following is the truepart of the calculated expression?

Crosstab queries may use which of the following aggregate functions?

Which comparison operator defines a condition with a list of two or more values for a field and includes records when the field matches one value from the list in the query results?

The calculated expression =City & "," & State & " " & ZipCode is an example of ____.

The standard naming convention prefix tag for a query used to identify the object type is ____.