NEW
Font size
S
M
L
XL
WorksheetsAccess - Lesson 7
Total questions: 11
Worksheet time: 6mins
Name
Class
Date
1.
What ensures that a query result appears in a specific order?
a)
Filtering
b)
Sorting
c)
Ordering
d)
Placing
2.
Marci is searching a Planet Database. She wants to find out how manymoons Saturn has and the names. Which comparison operator would she use?
a)
and
b)
equal
c)
not
d)
or
3.
Joe wants to modify the query he created to incorporate various colors,fonts, and styles to create a custom look. Which query would he use?
a)
Design View
b)
Simple Query Wizard
c)
Query Design View
d)
Query Wizard
4.
Beth needs to determine the seniors with a GPA of 4.0 or higher. Whichobject would allow her to create a saved search to find this informationin the database?
a)
Form
b)
Table
c)
Query
d)
Report
5.
After a query is created, which action must take place to display theresults of the query?
a)
Go
b)
Run
c)
Get
d)
Retrieve
6.
Taylor wants to query the airline database to find out how many seats are open on Flight 33. What type of query would she use?
a)
Crosstab Query
b)
Multiple Query
c)
Simple query
d)
Find
7.
Marci has a database of all the planets. She needs to know what planetshave moons or rings. Which comparison operator would she use to perform the query?
a)
moons and rings
b)
moons equal to rings
c)
moons not ring
d)
moons or rings
8.
Donna's Bakery lost a customer named Dingin' Donuts. What actionshould be taken to remove all records from her database for Dingin'Donuts?
a)
Delete Query
b)
Update Query
c)
Append Query
d)
Make Table Query
9.
Keisha created a database of her music. She wants to locate only thesongs by Beyoncé. What tool should she use in order to view thisinformation and save it for later use?
a)
Filter
b)
Form
c)
Query
d)
Report
10.
Before creating a query from multiple tables, you must first ensure that the tables have which of the following?
a)
Unmatched records
b)
A defined relationship
c)
A filter applied
d)
No related records
11.
To add a table to a query, you must be in which of the following views?
a)
SQL
b)
Datasheet
c)
Normal
d)
Design
Reset
