NEW
Font size
S
M
L
XL
WorksheetsDatabase Basics
Total questions: 15
Worksheet time: 8mins
Name
Class
Date
1.
A database of racing includes the names of each driver, total wins and losses, and average speeds. What criterion will produce Jeff Gordon’s total winnings?
a)
>Jeff Gordon
b)
<Jeff Gordon
c)
=Jeff Gordon
d)
<>Jeff Gordon
2.
Jennifer is creating a database for several customers. How will she list the Customer ID?
a)
Yes/No
b)
Data
c)
Number
d)
Currency
3.
A manager has requested a list of all products over $100 and in size “Large”. How would this information be retrieved?
a)
Sort Ascending
b)
Sort Descending
c)
Filter
d)
Find
4.
Robert needs to create a database of all his friends. In a table, is what last name considered?
a)
Field
b)
Record
c)
Table
d)
Cell Address
5.
Juan needs to create a database of all his friends. In a table, what is all the information about one friend considered?
a)
Field
b)
Record
c)
Table
d)
Entry
6.
In a database, what is one piece of information called?
a)
Field
b)
Record
c)
Table
d)
Entry
7.
Ted is creating a database for several customers. What is the data type for the field customer name?
a)
Yes/No
b)
Data
c)
Number
d)
Currency
8.
Chloe is creating a database for several customers. What is the data type for the field total sales?
a)
Yes/No
b)
Data
c)
Number
d)
Currency
9.
Your boss has required all products from lowest price to highest. How would this information be retrieved?
a)
Sort Ascending
b)
Sort Descending
c)
Filter
d)
Find
10.
Ms. Thomas has requested a list of all products under $10 and in size “Small”. How would this information be retrieved?
a)
Sort Ascending
b)
Sort Descending
c)
Filter
d)
Find
11.
Max wants to create a list of graduate degrees in a database that will allow the selection of only three choices: BSBA, MBA, and MBE. Which field property should he use?
a)
Auto Number
b)
Lookup
c)
Number
d)
Yes/No
12.
A manager has requested a list of products from highest price to lowest. How would this information be retrieved?
a)
Sort Ascending
b)
Sort Descending
c)
Filter
d)
Find
13.
Which criteria will produce an alphabetical list of drivers who have 150 points?
a)
>150 and Sort Ascending
b)
>150 and Sort Descending
c)
>=150 and Sort Ascending
d)
>=150 and Sort Descending
14.
Gina needs to create a database of all her friends. Where will all the information be kept?
a)
Field
b)
Record
c)
Table
d)
Entry
15.
Billy is creating a database for several customers. How will he record whether or not they have a credit card?
a)
Yes/No
b)
Text
c)
Number
d)
Currency
Reset
