BTEC IT - 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

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

• Wildcard

• Crosstab

• Select

• 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

Wildcard that represents any collection of characters

• Asterisk *

• Question Mark ?

• Hash tag #

• Equal Sign =

A bookshop owner is using the shop's database to help a customer.  The customer is looking for a particular author but cannot remember their full name.  The customer remembers that the surname of the author starts with the letters "Co".  What kind of query could the bookshop owner use to find this information?

• Parameter
• GroupBy
• Wildcard
• Selection

Which of the following is used to extract information from a database?

• tables

• queries

• relationships

• keys

Which of the following is used to store data in a database?

• reports

• queries

• tables

• relationships