Question 1

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

Accepted Answer

The answer of ________ functions can be used to determine...

Question 2

The ________ argument allows you to determine how many decimal places you want to round your numbers.

Accepted Answer

The answer of The ________ argument allows you to determine...

Question 3

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 4

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 5

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 6

To display specific dates,you can use the ________ function to manipulate the day,month,and year of a date.

Accepted Answer

The answer of To display specific dates,you can use the...

Question 7

The result of the IsNull function returns a ________ value.

Accepted Answer

The answer of The result of the IsNull function returns...

Question 8

Match the following wildcards to their use:
I.? or _
II.* or %
III.#
IV.[charlist]
V.[!charlist]
A.Any single character
B.Any single character in a list
C.Any single digit
D.Zero or more characters
E.Any single character not in a list

Accepted Answer

The answer of Match the following wildcards to their use:
I.?...

Question 9

The ________ function returns a number rounded to a specific number of decimal places.

Accepted Answer

The answer of The ________ function returns a number rounded...

Question 10

The ________ function is used to determine the difference between two dates.

Accepted Answer

The answer of The ________ function is used to determine...

Question 11

Match the following expression elements to their example:
I.Identifier
II.Operator
III.Logical operator
IV.Function
V.Constant
A.Strings of text
B.[+] or [-] signs
C.Names of a field
D.Sum,Count,and Avg
E.And,Or,and Not

Accepted Answer

The answer of Match the following expression elements to their...

Question 12

Access uses the ________ date system to store dates-January 1,1900,was day 1; January 2,1900,was day 2; and so forth.

Accepted Answer

The answer of Access uses the ________ date system to...

Question 13

When using the Concatenate function you are creating a(n)________ field; meaning that the concatenated field imitates its "real" equivalent or equivalents such as combining FirstName and LastName fields.

Accepted Answer

The answer of When using the Concatenate function you are...

Question 14

________ functions are useful when working with the complex logic in a database that contains dates.

Accepted Answer

The answer of ________ functions are useful when working with...

Question 15

The ________ function can be used to add or subtract a specific time interval from a date.

Accepted Answer

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

Question 16

Logical operators are also known as ________ operators.

Accepted Answer

The answer of Logical operators are also known as ________...

Question 17

________ is used to indicate that a value is unknown,and it is treated differently than other values because it has no value.

Accepted Answer

The answer of ________ is used to indicate that a...

Question 18

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 19

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

Accepted Answer

The answer of The ________ function is very flexible because...

Question 20

Match between columns
                        Premises: Date function
Now function
DateDiff function
DateAdd function
DateSerial function

Accepted Answer

The Answer of Determine the difference between two dates and is...

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