Question 1

Which of the following is NOT true regarding the precision argument?

Accepted Answer

A)  The precision argument is an optional argument.
B)  The precision argument is a required argument.
C)  The precision argument allows you to determine how many decimal places you want to round your numbers.
D)  The syntax would be Round (expression,[precision]) . B

Question 2

The Date and Now functions retrieve a date and/or time according to your computer's system date and time.

Accepted Answer

A) True 
 B)False  True

Question 3

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

Accepted Answer

A)  queries
B)  functions
C)  formulas
D)  expressions D

Question 4

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

Accepted Answer

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.

Question 5

When using wildcard characters in a query,ch* in the criteria of a FoodName field would return churros,chimichanga,or anchovies.

Accepted Answer

A) True 
 B)False

Question 6

Which of the following arguments of the DateSerial function is NOT correct?

Accepted Answer

A)  Year is a number between 1900 and 9999,inclusive,or a numeric expression.
B)  Time contains a time that represents the interval of time you want to display.
C)  Month refers to either an integer or any numeric expression.
D)  Day refers to either an integer or any numeric expression.

Question 7

________ operators include And,Or,and Not.

Accepted Answer

The answer of ________ operators include And,Or,and Not....

Question 8

There should always be an equal amount of opening and closing parentheses in your expression.

Accepted Answer

A) True 
 B)False

Question 9

You can use the ________ function to find values in a field that match a specific pattern.

Accepted Answer

The answer of You can use the ________ function to...

Question 10

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.

Accepted Answer

A)  Like
B)  Is Null
C)  Concatenate
D)  Not

Question 11

The IIf function in Access,which stands for ________,is similar to the IF function in Excel.

Accepted Answer

The answer of The IIf function in Access,which stands for...

Question 12

The ________ function can be used to examine a date and return a specific interval of time.

Accepted Answer

The answer of The ________ function can be used to...

Question 13

Match between columns
                        Premises: Identifier
Operator
Logical operator
Function
Constant

Accepted Answer

The Answer of Strings of text and [+] or [-] is...

Question 14

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.

Accepted Answer

A)  Not
B)  Between...And
C)  In
D)  Not Between...And

Question 15

The ________ function is very flexible because you can manipulate each part individually or together in any combination that meets your needs.

Accepted Answer

A)  Now
B)  DatePart
C)  Date
D)  DateSerial

Question 16

IIf functions can be used to determine if a specific condition is true or false and introduces decision making into a database.

Accepted Answer

A) True 
 B)False

Question 17

You can use the DatePart function to examine a(n)________ and return a specific ________.

Accepted Answer

A)  date,interval of time
B)  interval of time,date
C)  entry,date
D)  date,date input

Question 18

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.

Accepted Answer

The answer of There may be a time to use...

Question 19

Match the following Date functions to their definition:
I.Date function
II.Now function
III.DateDiff function
IV.DateAdd function
V.DateSerial function
A.Determine the difference between two dates
B.Returns the current system date
C.Used to manipulate the day,month,and year
D.Add or subtract a specific time interval
E.Retrieves the current system date and time

Accepted Answer

The answer of Match the following Date functions to their...

Question 20

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.

Accepted Answer

A)  Not
B)  Between...And
C)  In
D)  Not Between...And

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

Which of the following is NOT true regarding the precision argument?

The Date and Now functions retrieve a date and/or time according to your computer's system date and time.

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

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

When using wildcard characters in a query,ch* in the criteria of a FoodName field would return churros,chimichanga,or anchovies.

Which of the following arguments of the DateSerial function is NOT correct?

________ operators include And,Or,and Not.

There should always be an equal amount of opening and closing parentheses in your expression.

You can use the ________ function to find values in a field that match a specific pattern.

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.

The IIf function in Access,which stands for ________,is similar to the IF function in Excel.

The ________ function can be used to examine a date and return a specific interval of time.

Match the following expression elements to their example:

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.

The ________ function is very flexible because you can manipulate each part individually or together in any combination that meets your needs.

IIf functions can be used to determine if a specific condition is true or false and introduces decision making into a database.

You can use the DatePart function to examine a(n) and return a specific .

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.

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.

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

Which of the following is NOT true regarding the precision argument?

The Date and Now functions retrieve a date and/or time according to your computer's system date and time.

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

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

When using wildcard characters in a query,ch* in the criteria of a FoodName field would return churros,chimichanga,or anchovies.

Which of the following arguments of the DateSerial function is NOT correct?

________ operators include And,Or,and Not.

There should always be an equal amount of opening and closing parentheses in your expression.

You can use the ________ function to find values in a field that match a specific pattern.

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.

The IIf function in Access,which stands for ________,is similar to the IF function in Excel.

The ________ function can be used to examine a date and return a specific interval of time.

Match the following expression elements to their example:

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.

The ________ function is very flexible because you can manipulate each part individually or together in any combination that meets your needs.

IIf functions can be used to determine if a specific condition is true or false and introduces decision making into a database.

You can use the DatePart function to examine a(n) ________ and return a specific ________.

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.

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.

You can use the DatePart function to examine a(n) and return a specific .