Upgrade to remove ads
Only $35.99/year

Lesson 6

Terms in this set (12)

what are questions asked of a database in which the answers are given through the data in the data base called?
Queries
what symbols that represent any character or combination of characters and are commonly used to specify the citerion in a query called?
wildcards.
Which character is used in a citerion to represent a collection of characters?
asterisk.
Which character is used in a citerion to represent an individual character?
Question Mark.
Which Check box in the query design view is used to include a particular field in a criterion while not displaying the field in a query results?
Show/hide.
Which query type is flexible and prompts the user for input whenever it is used?
Parameter.
Which type of operator enables a user to equate two values in a query criterion?
Comparison
Which property on a query properties sheet must be modified to eliminate duplicates in a query?
Unique values.
Which query allowos a user to quantify the query results by displaying only a specific number of records or percentages of records?
Top-values.
Which dialog box accessed through Query Design View is used to manually enter an expression for a field?
Zoom.
What type of query enables a user to make the same change to all records satisfying certain criterion?
Update.
What type of query enables a user to add the results of a query to an existing table in a database?
Append.
Students also viewed