Exam 3: Workshop 3: Queries and Data Access

________ is a feature that can change the column width of the data to match the widest data entered in that field.

In Datasheet view,you can use the ________ to quickly locate specific records using all or part of a field value.

To match any single numeric character,you would use the ________ wildcard character.

To manage larger tables,Access provides ways for you to quickly locate information within the datasheet.Once that information is found,it can then be easily replaced with another value using the ________.

________ is a feature that can change the column width of the data to match the widest data entered in that field.

________ allow you to create a custom filter to match all or part of the text in a field that you specify.

Match the following aggregate functions with their description. I.Sum II.Average III.Count IV.Minimum V.Maximum A.Largest value B.Total value C.Smallest value D.Arithmetic mean E.Number of records

In a query,if you use multiple criteria,then you may also use logical operators to combine these criteria.

Relationship lines are the lines connecting the tables that represent relationships.

In Datasheet view,you can use the Replace command to quickly locate specific records using all or part of a field value.

The ________ operator determines if a value is found within a set of values.

To search for a word that starts with "ar" you would enter ________.

A(n)________ query is used when you want to describe one field in terms of two or more fields in the table.

________ functions perform arithmetic operations,such as calculating averages and totals,on records displayed in a table or query.

The Navigation bar allows you to move to the top and bottom of a table or scroll to a specific record and can be an efficient tool regardless of the size of the table.

Which of the following is NOT true regarding the Find Unmatched query?

A sort field can be a Short Text,Long Text,Number,Date/Time,Currency,AutoNumber,Yes/No,Hyperlink,or Lookup Wizard field.

The ________ contains a list of properties for fields in which you can make precise changes to each property associated with the field.

To match any single character not within brackets,you would use the ________ wildcard character.

A ________ is used as a placeholder for an unknown part of a value or to match a certain pattern in a value.