Question 1

A(n)________ consists of several possible elements that you can use either alone or in combination to yield a result.
A)formula
B)function
C)expression
D)equation

Accepted Answer

An expression consists of several possible elements, such as numbers, variables, and operators, that can be used alone or in combination to yield a result.

Question 2

If you wanted to return the values of carpenter,cart manager,cart maintenance engineer,cosmetics specialist,courtesy representative,concierge,or any other title that starts with the letter c you would type ________ in the criteria of a JobTitle field.
A)c?
B)c*
C)[!C]
D)c#

Accepted Answer

Option B, c*, will return any title that starts with the letter "c" followed by any number of characters.

Question 3

By typing Like "manager*" in the Query Design grid's criteria section of a JobTitle field,your results would include ________.
A)all records with the word "manager" located anywhere in the field.
B)all records with the word "manager" located at the beginning of the field.
C)all records with the word "manager" located at the end of the field.
D)no records because the criteria is not entered correctly.

Accepted Answer

The asterisk (*) serves as a wildcard and allows any characters to follow the text "manager," so this query would include all records with the word "manager" located at the beginning of the JobTitle field.

Question 4

Which of the following parameter data types is NOT one that is particularly important to specify when using parameters?
A)Number
B)Currency
C)Data/Time
D)Text

Accepted Answer

While specifying the data type for parameters is important, text is a general data type that can encompass a wide range of input types. As long as the input is in text format, it can be handled appropriately by the system.

Question 5

If you want to search for customers who meet certain criteria,such as those who live in all states except Arizona,Nevada,or New Mexico,you would type ________("Arizona","Nevada","New Mexico")as the criterion in the State field.
A)Like
B)Between...And
C)Not In
D)Not Between...And

Accepted Answer

The "Not In" operator is used to search for customers who do not meet a certain criteria. In this case, we want to find customers who do not live in Arizona, Nevada, or New Mexico, so using "Not In" and specifying those three states as the criteria in the State field will give us the desired results.

Question 6

Which of the following is NOT true regarding the IsNull function?
A)The result of an IsNull function is a Boolean value.
B)Null is equal to zero.
C)The results indicate whether an expression contains no valid data.
D)Null is used to indicate that a value is unknown,and it is treated differently than other values because it has no value.

Accepted Answer

Null is not equal to zero. Null represents the absence of a value or unknown value, while zero is a specific numerical value.

Question 7

Which of the following is NOT true regarding nested IIf functions?
A)You can create a nested IIf function,allowing you to evaluate a series of dependent expressions.
B)A nested IIf function is used when you need to test for multiple conditions.
C)When having one IIf function nested inside another,the second IIf function becomes the truepart of the first IIf function.
D)When having one IIf function nested inside another,the second IIf function becomes the falsepart of the first IIf function.

Accepted Answer

The answer of Which of the following is NOT true...

Question 8

If you wanted to search for all customers who live outside of the USA,you would type ________ "USA" as the criterion in the Country field.
A)Not
B)Between...And
C)In
D)Not Between...And

Accepted Answer

The "Not" criterion is used to exclude records that match a certain value, in this case, "USA".

Question 9

The most important functionality of a database is to create ________.
A)queries
B)data
C)knowledge
D)quality information

Accepted Answer

The primary purpose of a database is to store and organize data in a way that allows for the retrieval and generation of quality information.

Question 10

If you run a query that shows all customers who have spent more than $500 over the past six months and limit the results to those who were born in the current month,this would be an example of ________.
A)data
B)information
C)knowledge
D)a complex query

Accepted Answer

Knowledge is the result of processing data and information to create new insights. In this case, the query is processing data (customer spending) and information (customer birth dates) to create new knowledge (which customers have spent more than $500 over the past six months and were born in the current month).

Question 11

A(n)________ symbol is used in conjunction with the Concatenate function when you want to create a single field by combining data in multiple fields.
A)#
B)$
C)&
D)%

Accepted Answer

The "&" symbol is used in conjunction with the Concatenate function to combine data in multiple fields into a single field.

Question 12

A ________ query first sorts and then filters your data to return the top or bottom values within a field.
A)Parameter
B)Top Values
C)Bottom Values
D)Select Values

Accepted Answer

Top Values query first sorts and then filters your data to return the top or bottom values within a field.

Question 13

You can use the IIf function anywhere you can use ________.
A)queries
B)functions
C)formulas
D)expressions

Accepted Answer

The IIf function is an expression in Access, so it can be used anywhere expressions are used, such as in queries, forms, reports, and macros. It can also be used in VBA code. Therefore, option D is the best choice.

Question 14

Which of the following is not true regarding expressions?
A)Elements that can be used in an expression include identifiers,operators,logical operators,functions,and constants.
B)An expression consists of several possible elements that you can use.
C)You can use expressions in a number of ways such as performing calculations or retrieving values of a control.
D)the term "expression" is synonymous with "equation."

Accepted Answer

The term "expression" and "equation" are not synonymous. An expression is a combination of values, variables, operators, and functions that are evaluated to produce a result, while an equation is a statement that two expressions are equal.

Question 15

The ________ operator verifies whether the value of a field or expression falls within a stated range of numeric values.
A)Not
B)Between...And
C)In
D)Not Between...And

Accepted Answer

The BETWEEN...AND operator is used to check if the value of a field or expression falls within a specified range of values. It is the most appropriate choice for verifying numeric values within a stated range. The other options are not suitable for checking a range of numeric values.

Question 16

Many times wildcard characters are combined with the ________ function to ensure that your query is returning all the data you need within the data set.
A)Like
B)Is Null
C)Concatenate
D)Not

Accepted Answer

The wildcard character is commonly used in conjunction with the Like function in SQL queries. The Like function allows pattern matching, which is useful when searching for data that contains certain characters or strings within larger fields. By using wildcard characters with the Like function, you can search for data that matches a certain pattern, even if you don't know the exact value you're looking for. The IsNotNull function checks if a value is not null, Concatenate function combines two or more strings into a single string, and the Not function returns the opposite of a boolean expression.

Question 17

If you want to search for customers who meet certain criteria,such as those who live in specific states,you would type ________("Arizona","Nevada","New Mexico")as the criterion in the State field.
A)Not
B)Between...And
C)In
D)Not Between...And

Accepted Answer

The "In" operator is used when searching for specific values within a field. In this case, we want to find customers who live in specific states, so the "In" operator would be the best choice. The criterion would be typed in as ("Arizona", "Nevada", "New Mexico") in the State field.

Question 18

Which of the following is NOT an IIf function argument?
A)expr
B)truepart
C)falsepart
D)logical test

Accepted Answer

The IIf function in programming typically takes three arguments: expr (the condition to evaluate), truepart (the result if the condition is true), and falsepart (the result if the condition is false). "logical test" is not a standard argument name for IIf.

Question 19

There may be a time to use the ________ operator when you want to join data from multiple fields to create a single text string of data.
A)Between...And
B)Concatenate
C)Not
D)In

Accepted Answer

The concatenate operator, denoted by "&" in Access, allows you to join multiple fields together and create a single text string of data. This is commonly used in reports or forms where you want to display combined data from different fields, such as a person's full name or address. The other operators listed (Between, Not, In) do not have the same function and therefore would not be appropriate in this scenario.

Question 20

Which of the following is NOT a wildcard character that can be combined with the Like function?
A)[charlist] or [!charlist]
B)#
C)&
D)* or %

Accepted Answer

"&" is not a wildcard character that can be combined with the Like function. The other options - [charlist] or [!charlist], #, and * or % - are all valid wildcard characters that can be used with the Like function.

Quiz 6: Workshop 6: Pattern Matching and Functions in Queries

A(n) ________ consists of several possible elements that you can use either alone or in combination to yield a result.

If you wanted to return the values of carpenter,cart manager,cart maintenance engineer,cosmetics specialist,courtesy representative,concierge,or any other title that starts with the letter c you would type ________ in the criteria of a JobTitle field.

By typing Like "manager*" in the Query Design grid's criteria section of a JobTitle field,your results would include ________.

Which of the following parameter data types is NOT one that is particularly important to specify when using parameters?

If you want to search for customers who meet certain criteria,such as those who live in all states except Arizona,Nevada,or New Mexico,you would type ________("Arizona","Nevada","New Mexico") as the criterion in the State field.

Which of the following is NOT true regarding the IsNull function?

Which of the following is NOT true regarding nested IIf functions?

If you wanted to search for all customers who live outside of the USA,you would type ________ "USA" as the criterion in the Country field.

The most important functionality of a database is to create ________.

If you run a query that shows all customers who have spent more than $500 over the past six months and limit the results to those who were born in the current month,this would be an example of ________.

A(n) ________ symbol is used in conjunction with the Concatenate function when you want to create a single field by combining data in multiple fields.

A ________ query first sorts and then filters your data to return the top or bottom values within a field.

You can use the IIf function anywhere you can use ________.

Which of the following is not true regarding expressions?

The ________ operator verifies whether the value of a field or expression falls within a stated range of numeric values.

Many times wildcard characters are combined with the ________ function to ensure that your query is returning all the data you need within the data set.

If you want to search for customers who meet certain criteria,such as those who live in specific states,you would type ________("Arizona","Nevada","New Mexico") as the criterion in the State field.

Which of the following is NOT an IIf function argument?

There may be a time to use the ________ operator when you want to join data from multiple fields to create a single text string of data.

Which of the following is NOT a wildcard character that can be combined with the Like function?