How can we help?

You can also find more resources in our Help Center.

12 terms

Hannah Roffey Lesson 6 Review

STUDY
PLAY
Queries
What are questions asked of a database in which the answers are given through the data in the database called?
Wildcards
What are symbols that represent any character or combination of characters and are commonly used to specify the criterion in a Query Called?
Asterisk (*)
Which character is used in a criterion to represent a collection of characters?
Question Mark (?)
Which character is used in a criterion to represent an individual character?
Show
Which checkbox on the Query Design View is used to include a particular field in a criterion while not displaying the field in the Query Results?
Parameter
Which query type is flexible and prompts the user for input whenever it is used?
Comparison
Which type of operator enables a user to equate two values in a Query criterion?
Unique Values
Which property on a query properties sheet must be modified to eliminate duplicates in a Query?
Top-Values
Which query allows a user to quantify the query results by displaying only a specfic number of records or a percentage of records?
Zoom
Which dialog box is accessed through Query Design View is used to manually enter an expression for a field?
Update
What type of query enables a user to make the same change to all records satisfying certain criterion?
Append
What type of query enables a user to add the results of a query to an existing table in a database?