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

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

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

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

The DateDiff function is used ________.

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

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

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

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.

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

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

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.

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

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

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.

The result of the IsNull function returns a ________ value.

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

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

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.

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

The ________ function returns the current system date and time.