NEW
Font size
S
M
L
XL
WorksheetsDatabase - Beginner Level Review
Total questions: 38
Worksheet time: 38mins
Name
Class
Date
1.
Mrs. Leonard maintains a large database of student information. She has identified two student records that have the same name, same enrolled courses, but slightly different student numbers. Only one of them has related quarterly grading records. What should Mrs. Leonard do?
a)
Delete the record that has the quarterly grades.
b)
Delete the record that does not have any quarterly grades.
c)
Move the record with the quarterly grades to a backup database.
d)
Move the record with no quarterly grades to a backup database.
2.
Your team is complaining about entering data into your table using the Datasheet view. They are asking your help to make data entry easier. Which database component can you use to help your team with data entry?
a)
Field
b)
Table
c)
Record
d)
Form
3.
Which of the following allows a user to create a table or report based on specific fields within a database?
a)
Table
b)
Query
c)
Field
d)
Record
4.
Johann is creating a database field which will store descriptive text about products. Which data type should he set for this field?
a)
Numeric
b)
Yes/No
c)
Text
d)
Memo
5.
Which database component is commonly referred to as a table row within a database?
a)
Record
b)
Field
c)
Title
d)
Column
6.
Nadia is creating a table of financial transactions. In each record, she will capture the date and type of transaction, the person who recorded it and the amount. Which data type should she set for the field containing the transaction amount?
a)
Number
b)
Currency
c)
Date/Time
d)
Text
7.
Keisha is a Science Supervisor for all the science teachers in the district. She wants to track all the classes taught by each teacher during school year. What information would be the most helpful for Keisha to have in her database to help her with her tracking?
a)
Name of Principal, School Address and Name of Teacher.
b)
Class dates, Class Title and Name of Teacher.
c)
School Address, Class title and Teacher's Email.
d)
Class Title, Room number and Name of Principal.
8.
Which of the following is used to retrieve specific information from a database?
a)
Instance
b)
Table
c)
Query
d)
Keyword
9.
Which of the following consists of multiple tables of information that are related through common fields?
a)
Relational Database
b)
Spreadsheet
c)
Presentation
d)
Text Document
10.
Mr. Daniels is the basketball coach at school. Which of the following would be his best use of a database?
a)
The team's game schedule.
b)
Track student academic eligibility by teacher.
c)
Organizing sports equipment in the storage room.
d)
School calendar of holidays.
11.
Three people are tracking the results of a single survey. They share their results in different file types via email but the compiled results are inconsistent and questionable. What feature of a database would improve this tracking process?
a)
Good for "crunching" small amounts of data.
b)
Complex design process.
c)
Data can be protected against accidental changes.
d)
Easy to learn and use.
12.
Which of the following is an advantage of using databases instead of spreadsheets?
a)
Multiple people can use the same database data at a time.
b)
Databases are easier to learn than spreadsheets.
c)
Databases consist simply of worksheets.
d)
Only one person can use the same database data at a time.
13.
Students need to be organized into lines to get on their bus for the ride home. Your table include the following fields: Grade, Bus #, Student ID, Student Last Name. What field would you use to sort the table, to help organize students for their trip?
a)
Grade
b)
Bus #
c)
Student ID
d)
Student Last Name
14.
Which tool allows a user to store organized information that can easily be accessed, edited and queried?
a)
Pen & Paper
b)
Calculator
c)
Text Document
d)
Database
15.
Spencer has a database of 2000 customers. He needs to print mailing labels. He can get a discount on the postage, if he delivers the labeled mail in an organized way. Which field should he sort his list by, to take advantage of the discount?
a)
Email Address
b)
Phone Number
c)
Last Name
d)
Zip or Postal Code
16.
As you build your database, you need to define the types of information tracked in each table. This information would appear across the top of the Datasheet view. Which database component is used to define your information by data type?
a)
Field
b)
Row
c)
Record
d)
Title
17.
Yes/No, Date/Time and Number are examples of:
a)
Records in a data table
b)
Tabs you can select
c)
Data Types
18.
You have developed a database about the favorite music of the students in your school. It has been populated with several thousand records. Now you need to provide information on the most popular types of music. Which database component can you use to provide this information?
a)
Table
b)
Query
c)
Form
d)
Report
19.
As an advertising agent, your job is to help your clients identify who their best clients are, where these customers are located, and what kind of commercials or advertisement would appeal to these customers. What resource offers you all of this information?
a)
A list of phone numbers to call
b)
Big data
c)
A spreadsheet of customer names
d)
Mass mailing
20.
Which of the following is used by advertisers to determine the best method to reach their target markets?
a)
A spreadsheet of customer names
b)
Big data
c)
A list of phone numbers to call
d)
Mass mailing
21.
You are working with a team to compile student and teacher information. This information will be used to connect teachers to students based on classes taken and home addresses. Which software would be the best choice to help with this compilation task?
a)
Spreadsheet
b)
Relational database
c)
Presentation
d)
Text document
22.
You have a large collection of related data. You want to use a relational database but your partner wants to use a spreadsheet. Which of the following would you share with your partner as an advantage of using databases instead of spreadsheets?
a)
Databases consist simply of worksheets.
b)
Databases are easier to learn than spreadsheets.
c)
Databases remove the need for redundant data.
d)
Only one person can use the same database data at a time.
23.
Data is first collected, then reviewed and revised as needed. Lastly, questions or "queries" are asked about the data to inform decisions or provide insights like "which language classes have more than 30 students" or "how many countries involved in World War I had a population of less than 1 million people at the time of the war". Which tool allows a user to perform all of these tasks - collecting, editing and questioning data?
a)
Pen and paper
b)
Database
c)
Text document
d)
Calculator
24.
Which type of software is considered the most difficult to learn?
a)
Presentation software
b)
Database software
c)
Text document software
d)
Basic image-editing software
25.
What kind of data would an art gallery retail store need to store in a database?
a)
Schedules of demonstrations, classes, and special events
b)
Inventory, prices, sales, customer information
c)
Artist biographies, resumes, and art techniques
d)
Marketing flyers, post cards and advertisements
26.
Daniel works at a hospital. He is creating a database for his patient care department. Which type of information would be included in his database?
a)
Patient allergy notes
b)
Teacher contact numbers
c)
Web page descriptions
d)
Sports game schedules
27.
Entering student information into the Datasheet view of a table creates a new row for each new student added. Each row in a table is also known as a________.
a)
Record
b)
Column
c)
Field
d)
Title
28.
You are including email addresses in your student information table. When someone clicks on the email address, it should open a new email message and populate the To field with the selected email address. What data type should be selected to enable this functionality?
a)
Memo.
b)
Hyperlink
c)
OLE Object
d)
Number.
29.
Study this example of a database. Which database component is shown outlined in black?
a)
Record
b)
Row
c)
Heading
d)
Field
30.
Study this example of a database. Which database component is shown outlined in black?
a)
Field
b)
Record
c)
Column
d)
Heading
31.
Blake is creating a database field which will indicate whether a student has passed the previous class or not. Which data type should he set for this field?
a)
Date/Time
b)
Yes/No
c)
Numeric
d)
Currency
32.
James has just inserted his grade for a quiz into a new database table. Which operation has James just performed?
a)
Deleting a record
b)
Adding a record
c)
Sorting a record
d)
Updating a record
33.
Study this example of a database. Which field uses the Number format?
a)
Age
b)
Name
c)
Birthdate
d)
Favorite Color
34.
Which operation allows you to arrange database records in alphabetical order?
a)
Filtering
b)
Sorting
c)
Updating
d)
Adding
35.
Mary maintains a large database of customer information. A user has identified two company records that have the same name, same address, but different customer IDs. Only one of them has related sales transaction records. What should Mary do?
a)
Move the record with the sales transactions to a backup database.
b)
Move the record with no sales transactions to a backup database.
c)
Delete the record that has the sale transactions.
d)
Delete the record that does not have any sales transactions.
36.
Study this example of a database table. Students need to be organized into lines to get on their bus for the ride home. What field would you use to sort the table, to help organize students for their trip?
a)
Bus #
b)
Grade
c)
Student ID#
d)
Student Last Name
37.
Principal Spencer has a database that includes the quarterly grades of the students enrolled in her school. She needs to print report cards to give to teachers to distribute to students so that they can be taken home. Which field should she sort her list by to quickly print and distribute the report cards during home room?
a)
Student First Name
b)
Student ID#
c)
Teacher name
d)
Student Last Name
38.
Study this example of a database. Which field is sorted in numerical order?
a)
ID
b)
Name
c)
Birthdate
d)
Zip Code
Reset
