NEW
Font size
S
M
L
XL
WorksheetsDatabase
Total questions: 35
Worksheet time: 20mins
Name
Class
Date
1.
A tool used to organize, store, retrieve, and communicate groups of related information.
a)
Spreadsheet
b)
Word
c)
Presentations
d)
Database
2.
The four main objects of a relational database consist of:
a)
form, table, query, report
b)
form, table, database, query, report
c)
form, sort, table, query
d)
form, column, row, report
3.
I control data entry. I am also used for data entry.
a)
table
b)
query
c)
form
d)
report
4.
I give one the ability to present information in an easy-to-read format. I summarize and print information from the query search.
a)
form
b)
table
c)
query
d)
report
5.
I can perform an advanced search. I am very similar to asking a detailed question.
a)
report
b)
query
c)
table
d)
form
6.
I store data in rows and columns. I am considered the basic building block of a relational database. I am used to organize information within a database.
a)
form
b)
table
c)
query
d)
report
7.
Arrange information in alphabetical/sequential order, A-Z, least to greatest, 1-10.
a)
ascend
b)
descend
c)
data
d)
table
8.
Arrange information in reverse order; z-a, greatest to least, 10-1.
a)
greater than
b)
less than
c)
ascend
d)
descend
9.
If I am placed between terms I will retrieve data that contain both of the terms. Which connector am I?
Example: candy ____ soda
Example: candy ____ soda
a)
And
b)
Or
c)
Not
d)
But
10.
If I am placed between terms, I will retrieve data that contain either of the terms.
Example: candy ___ soda
Example: candy ___ soda
a)
And
b)
Or
c)
But
d)
Not
11.
Which of the following is NOT an example of a database?
a)
telephone book
b)
Real Estate listing
c)
Online library card catalog
d)
DVD
12.
Which of the following objects is considered the basic building block of a relational database?
a)
form
b)
query
c)
table
d)
report
13.
Rows are called...
a)
fields
b)
records
c)
table
d)
entry
14.
Columns are called...
a)
rows
b)
fields
c)
table
d)
form
15.
A single piece of data in a database table.
a)
entry
b)
table
c)
data
d)
field
16.
A unique identifier for a category is known as what?
a)
entry
b)
field
c)
record
d)
table
17.
A complete description of the fields related to one item in a table.
a)
record
b)
field
c)
table
d)
entry
18.
Everything on one row is a record.
a)
True
b)
False
19.
Each item from this list is classified as...
Name
Birthdate
Social Security No.
Street
City
State
Zip
Name
Birthdate
Social Security No.
Street
City
State
Zip
a)
table
b)
record
c)
field
d)
entry
20.
Each item on the list is classified as...
Alayne Frith
10/20/2001
1512 Cameron Road
Hope Mills
NC
28348
Alayne Frith
10/20/2001
1512 Cameron Road
Hope Mills
NC
28348
a)
table
b)
record
c)
field
d)
entry
21.
Farmer Brown created a database to keep track of his dairy cows. Which of the following is an example of a database record?
a)
Cow = Elsie
b)
Cow, Age, Weight, Milk Production
c)
Elsie, 7, 800, 5
d)
800, 790, 250
22.
Farmer Brown created a database to keep track of his dairy cows. How many records are in the database below?
a)
2
b)
3
c)
4
d)
5
23.
Farmer Brown created a database to keep track of his dairy cows. In the database below, Age is classified as a/an:
a)
table
b)
record
c)
field
d)
entry
24.
Farmer Brown created a database to keep track of his dairy cows. How many fields are in the database below?
a)
2
b)
1
c)
4
d)
3
25.
Which object would Farmer Brown create to find out which cows produced more than 5 gallons per day?
a)
table
b)
query
c)
form
d)
report
26.
Which object would you create to view one record at a time when adding or editing data in a database?
a)
table
b)
query
c)
form
d)
report
27.
Which object did Farmer Brown have to create to store the data?
a)
table
b)
query
c)
form
d)
report
28.
Which data type is the BEST choice for the Cow field?
a)
Text
b)
Number
c)
Date/Time
d)
Yes/No
29.
Which data type is the BEST choice to store student ID in the database?
a)
Text
b)
Number
c)
Date/Time
d)
Yes/No
30.
Mrs. Bills wants to find all students in a database who have met one of the following conditions: (1) sold less than ten cases (2) raised at least 50 dollars. Which connector will provide the desired results?
a)
Greater Than
b)
Less Than
c)
And
d)
Or
31.
Mrs. Bills wants to view an alphabetical list of all students who participated in the Lollipops fundraiser. Which action should she take before printing?
a)
Create a query
b)
Create a report
c)
Create a table
d)
Create a form
32.
Mrs. Bills wants to view an alphabetical list of all students who participated in the Lollipops fundraiser. Which action should she take?
a)
Sort in ascending order on Student Name
b)
Sort in descending order on Student Name
c)
Sort in ascending order on Lollipops
d)
Sort in descending order on Lollipops
33.
Mrs. Bills want to determine who has sold the most Lollipops. Which action should she take to view this information at the top of the page?
a)
Filter on Lollipops greater than 100
b)
Filter on Lollipops less than 100
c)
Sort in ascending order on Lollipops
d)
Sort in descending order on Lollipops
34.
If the database shown below is sorted in descending order by weight, which cow will appear closest to the bottom of the page?
a)
Flossie
b)
Bessie
c)
Elsie
d)
Spot
35.
If the database shown below is sorted in ascending order by gallons of milk produced, which cow will appear close to the top of the page?
a)
Elsie
b)
Spot
c)
Bessie
d)
Flossie
Reset
