NEW
Font size
S
M
L
XL
WorksheetsQueries
Total questions: 11
Worksheet time: 4mins
Name
Class
Date
1.
A _______ query displays a dialog box that prompts the user to enter criteria when the query is run.
a)
Parameter
b)
Top Values
c)
Pattern Match
d)
List of Values
2.
A query can get its data from
a)
existing queries
b)
one or more tables.
3.
The Query button is located on the _______ tab
a)
Home
b)
File
c)
Create
d)
Export
4.
Sorting from A-Z is also called a descending sort.
a)
true
b)
False
5.
What function enables you to ask questions about the data stored in a database and returns the answers based on your criteria?
a)
Query
b)
Form
c)
Report
d)
Table
6.
____ Is a database object that lets you ask the database about the information that you want to see displayed.
a)
Form
b)
Query
c)
Report
d)
Table
7.
An easy way to create a query is to use the ____________.
a)
Design View
b)
Datasheet View
c)
Simple Query Wizard
8.
_________ means to put information in order.
a)
Query
b)
Filter
c)
Count
d)
Sort
9.
A to Z is sorting in ________ order.
a)
Ascending
b)
Descending
10.
Z to A is sorting in ________ order.
a)
Ascending
b)
Descending
11.
Click ___________ to show the results of a query
a)
Execute
b)
Show
c)
Run
d)
Results
Reset
