Unit 2 - Creating Queries

Which Query view is shown in this image?

• Datasheet View

• Design View

Which Query view is shown in this image?

• Datasheet View

• Design View

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 

Wildcard that represents any collection of characters

• Asterisk
• Question Mark
• Query
• Equal Sign

Which type of query would you use to only display specific fields from your table

• Select Query

• Parameter Query

Which type of query would you use to perform additional filters and sorts on a table in your database

• Select Query

• Parameter Query

You would use a ______ to reduce the amount of data being displayed in a query

You would use a _____ to display specific records within a table

Which of the following query criteria will display all students in the school except Year 12

• "Year 12"

• NOT "Year 12"

• LIKE "Year 12"