Free Printable BTEC IT - Database queries

Worksheets

BTEC IT - Database queries

Total questions: 12

Worksheet time: 6mins

Name

Class

Date

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

NOT

BUT

Which Boolean operator will expand your results?

AND

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

10.

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

reports

queries

tables

relationships

11.

Which of the following criteria is an example of using wild cards?

="Wok"

="Wok*"

LIKE "Wok*"

LIKE Wok

12.

What are queries that are used to update and delete records known as?

Calculated query

Action query

Make query

Select query

100 %

BTEC IT - Database queries

Total questions: 12

Worksheet time: 6mins

Similar Resources on Wayground