BTEC National ICT U2 - 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 "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

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

8. Sorting from A-Z is also called a descending sort. 

• True 
• False 

Which is the symbol for a wildcard that represents any collection of characters

• Asterisk

• Question Mark

• Query

• Equal Sign