Worksheetsdatabase searches
Total questions: 9
Worksheet time: 5mins
Name
Class
Date
1.
What Query view is shown in this image?
a)
Datasheet View
b)
Design View
2.
What Query view is shown in this image?
a)
Datasheet View
b)
Design View
3.
What is letter "A" showing?
a)
Where to configure the Join properties
b)
Where to Run the query
c)
Where to configure which fields and criteria are used for the Query
4.
Which of the following is used to extract information from a database?
a)
tables
b)
queries
c)
relationships
d)
keys
5.
The Query button is located on the _______ tab
a)
Home
b)
File
c)
Create
d)
Export
6.
Which software program do we use to create a database
a)
Microsoft Excel
b)
Microsoft Word
c)
Microsoft Access
d)
Microsoft Publisher
7.
What is letter "B" showing?
a)
Where to click to Run the Query
b)
Where to Configure the Fields returned and criteria to be used
c)
Where to click to configure the Join properties
d)
Where to click to Save this Query
8.
What is letter "C" showing?
a)
Where to click to Run the Query
b)
Where to Click to Save the Query
c)
Where to configure the Fields returned and the criteria to be used
d)
Where to configure the Join properties
9.
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?
a)
Position = "Striker" OR Goals = 20
b)
Position = "Striker" AND Goals = 20
c)
Position = "Striker" or Goals >=20
d)
Position = "Striker" AND Goals >= 20
100 %
