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

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.

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

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.

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.

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

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

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

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.

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

Which of the following is NOT an IIf function argument?

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

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

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 true regarding the IsNull function?

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

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

The ________ function returns the current system date.

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

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

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