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