Advertisement Upgrade to remove ads

Crosstab

What type of query calculates a statistic for data that is grouped by two different types of information?

Queries

What are questions asked of a database in which the answers are given through the data in the database called?

Criterion

In a Query, what condition must the records that are included satisfy?

Zoom

Which dialog box accessed through Query Design View is used to manually enter an expression for a field?

As a Database Object

How is a Query stored after it is created and saved?

Wildcards

What are symbols that represent any character or combination of characters and are commonly used to specify the criterion in a Query called?

Show

Which check-box in the Query Design View is used to include a particular field in a criterion while not displaying the field in the Query Results?

Make-Table

What type of query enables the user to add the results of a query to a new table in a database?

Simple Query

What type of Query is used when no restrictions, calculations, or special order must be applied to the data?

Update

What type of query enables a user to make the same change to all records satisfying certain criterion?

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?

Comparison

Which type of operator enables a user to equate two values in a Query criterion?

Top-Values

Which Query allows a user to quantify the query results by displaying only a specific number of records or a percentage of records?

Unique Values

Which property on a Query properties Sheet must be modified to eliminate duplicates in a Query?

Append

What type of query enables a user to add results of a query to an existing table in a database?

Parameter

Which Query type is flexible and prompts the user for input whenever it is used?

Table

What object may be used in a Simple Query?

Sorting

What must be done to ensure that a Query result appears in a specific order?

Delete Query

What is used to remove at once all records that meet specific criteria?

Design

Which view allows a user to specify fields, criteria, sorting, and calculations when creating a Query?

Right-click the Join Line and selecting Join Properties from the Shortcut Menu

How is the Join Properties dialog box easily accessed in Query Design View?

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set