Database Queries

What Query view is shown in this image?

• Datasheet View
• Design View

What Query view is shown in this image?

• Datasheet View
• Design View

What is letter "A" showing?

• Where to configure the Join properties
• Where to Run the query
• Where to configure which fields and criteria are used for the Query

What is letter "B" showing?

• Where to click to Run the Query
• Where to Configure the Fields returned and criteria to be used
• Where to click to configure the Join properties
• Where to click to Save this Query

What is letter "C" showing?

• Where to click to Run the Query
• Where to Click to Save the Query
• Where to configure the Fields returned and the criteria to be used
• Where to configure the Join properties

A _______ query displays a dialog box that prompts the user to enter criteria when the query is run.

• Top Values
• Pattern Match
• List of Values
• Parameter

A query can get its data from

• a. one or more tables.
• b. existing queries.
• c. a combination of a and b.
• d. all of the above.

Which Boolean operator will narrow your results

• AND
• OR
• NOT
• BUT

Which Boolean operator will expand your results

• AND
• OR
• NOT
• BUT

A football team keeps a database about its players. Which query would allow them to produce a query showing players who are strikers and who have scored 20 goals or more?

• Position = "Striker" OR Goals = 20
• Position = "Striker" AND Goals = 20
• Position = "Striker" or Goals >=20
• Position = "Striker" AND Goals >= 20