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

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

Answer 1

C

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#

Answer 2

B

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.

Answer 3

B

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

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

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.

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.

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

Question 9

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

A)queries
B)data
C)knowledge
D)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

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)%

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

Question 13

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

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

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."

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

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

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

Question 18

Which of the following is NOT an IIf function argument?

A)expr
B)truepart
C)falsepart
D)logical test

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

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 %

Question 21

The ________ field property only affects the way the data is displayed,not the way it is stored.

A)Round
B)Precision
C)Decimal Places
D)Display

Question 22

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

A)round
B)decimal
C)precision
D)display

Question 23

If you want to compare the number of golfers you had this summer as compared to last summer and each tee time contains a Scheduled Date,you can use the ________ function to extract the year from the Scheduled Date in order to group your records in the query.

A)DateSort
B)DatePart
C)DateSerial
D)DateAdd

Question 24

Which of the following is NOT a DateAdd function argument?

A)interval
B)time
C)number
D)date

Question 25

The DateAdd function is used ________.

A)to determine the difference between two dates
B)to add a specific time from the system time
C)to add a specific day from a date
D)to add or subtract a specific time interval from a date

Question 26

The most important functionality of a database is to create useful information.

Question 27

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

A)To display specific dates,you can use the DateSerial function,written as DateSerial(year,month,day)to manipulate the day,month,and year of a date.
B)DateSerial is very flexible because you can manipulate each part individually or together in any combination that meets your needs.
C)The DateSerial function returns a number that represents a date from January 1,1901 through December 31,9999.
D)If the date specified by the three arguments falls outside the acceptable range of dates,an error will occur.

Question 28

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

A)The Round function returns a number rounded to a specific number of decimal places.
B)The Round function behaves differently than the Format property.
C)When using the Round function,you can also determine the precision of the rounding.
D)Because currency is rounded to 2 decimals,the Round function should be used when working with the Currency data type.

Question 29

Which of the following is NOT true when using Date Interval settings?

A)If you enter the wrong interval,you can create many problems within your data.
B)DateDiff for the "yyyy" in Access calculates the year without regard to the day.
C)If you can calculate the same result entering a function that is half the length,you increase the possibility of creating errors while typing in your function.
D)Date()+10 would result in the same output as using the DateAdd function to add 10 to the current date.

Question 30

The DatePart function contains ________ arguments.

A)3
B)4
C)5
D)6

Question 31

Two of the more commonly used date functions are the ________ and ________ functions.

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

Question 32

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

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]).

Question 33

The ________ function returns the current system date and time.

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

Question 34

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

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

Question 35

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

A)Time contains a time in 24-hour format that represents the interval of time you want to add or subtract.
B)Interval contains a string expression that represents the interval of time you want to add or subtract.
C)Number refers to the numeric expression that indicates the number of intervals you want to add.It can be positive (to calculate dates in the future)or negative (to calculate dates in the past).
D)Date is the date to which the interval is added.

Question 36

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

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

Question 37

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

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 38

Calculated fields can be used in other expressions within your query by enclosing the calculated field name in ________.

A)square brackets
B)parentheses
C)single quotation marks
D)double quotation marks

Question 39

The ________ function returns the current system date.

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

Question 40

The DateDiff function is used ________.

A)to display the current system date
B)to display the current system date and time
C)to determine the difference between two dates
D)to add or subtract a specific time interval from a date

Question 41

Many times wildcard characters are combined with the Like operator to ensure that your query is returning all the data you need.

Question 42

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

Question 43

You can use the Like function to find values in a field that match a specified pattern.

Question 44

When using wildcard characters in a query,a charlist in the criteria of a field will allow you to use a group of one or more characters enclosed in parentheses.

Question 45

A dependent expression is an expression that relies on the outcome of another expression.

Question 46

To test for multiple conditions,you would use a basic IIf function.

Question 47

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

Question 48

You must either enter the number or percentage of records that you want to see when creating a Top Values query.You are not able to select an option from the list.

Question 49

When using wildcard characters in a query,c?t in the criteria of a Notes field would return cat,cot,and cut.

Question 50

To test for one of two conditions,you would use a nested IIf function.

Question 51

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

Question 52

Parameters can be used for any data type within a table,and you can specify what type of data a parameter should accept.

Question 53

When using wildcard characters in a query,[!charlist] will allow you to retrieve any character in a charlist.

Question 54

Wildcard characters,such as a dollar sign ($),substitute for other characters when used in a query.

Question 55

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

Question 56

You must set the sort to ascending or descending on the fields containing the top or bottom values before finding the top or bottom values.

Question 57

Specifying parameter data types is particularly important when you have text,numeric,currency,or date/time data.

Question 58

You can use a Top Values query when you need to find records that contain the top or bottom values in a field.

Question 59

Access is not case sensitive in regard to entering criteria in a query.

Question 60

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

Question 61

A null value is synonymous with a zero value.

Question 62

When using wildcard characters in a query,________ in the criteria of an AreaCode field would return 500,501,502...509.

Question 63

Access uses the 1900 date system to store dates.Thus,when you enter a date into a Date/Time field,Access identifies it as a date and compares it to the calendar to make sure it is an actual date.

Question 64

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

Question 65

________ operators include And,Or,and Not.

Question 66

You need to know the date serial number to use a date field in a calculated field.

Question 67

________,such as an asterisk (*)or question mark (?),substitute for other characters when used in a query.

Question 68

Once you have quality information and make a decision based on that information,you now have ________ about your organization.

Question 69

A(n)________ query can be designed to prompt users for criteria without having to make changes in Design view.

Question 70

The Round function returns a number rounded to a specific number of decimal places.This does the same thing as formatting a field to a specific number of decimals.

Question 71

A(n)________ allows you to enter the prompt you want the user to see when the query is run,and enclose the prompt within square brackets.

Question 72

In Access,the term ________ is synonymous with "formula."

Question 73

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

Question 74

To answer the question,"Which is the most or least expensive product sold at company A," you would use a(n)________ query.

Question 75

When using wildcard characters in a query,a(n)________ in the criteria of a field will allow you to use a group of one or more characters enclosed in brackets.

Question 76

To display specific dates,you can use the DateSerial function,written as DateSerial(year,month,day)to manipulate the day,month,and year of a date.

Question 77

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

Question 78

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

Question 79

________ include the names of a field,a control on a form or report,or the properties of the fields or controls.

Question 80

________ are values that do not change,such as strings of text or numbers that are not calculated by an expression.