NEW
Font size
S
M
L
XL
WorksheetsChapter 12 Test Review
Total questions: 30
Worksheet time: 15mins
Name
Class
Date
1.
Which of the following is not performed in a statistical field?
a)
MSG
b)
SUM
c)
AVG
d)
MIN
2.
What data type is the best choice for a Contract Amount data entry?
a)
Text
b)
Number
c)
Currency
d)
Dates
3.
Which of the following describes datasheet view?
a)
Displays a view that enables the editing of fields.
b)
Displays data in table form
c)
Displays one record at a time
d)
Displays the database code
4.
Data can be imported from all the following except __________________.
a)
E-mail attachments
b)
Spreadsheets
c)
Other Databases
d)
Text files
5.
Datasheet view is most similar to looking at information in which of the following programs?
a)
Microsoft Word
b)
Microsoft PowerPoint
c)
Microsoft Excel
d)
Microsoft Outlook
6.
What is the best method for a user to locate information found in separate tables of the same databases?
a)
Rebuild the database
b)
Open each table individually
c)
Run a report
d)
Establish table relationships
7.
Which is not a relationship type in Microsoft Access?
a)
One-to-one
b)
One-to-many
c)
Many-to-Many
d)
Few-to-all
8.
A ______________ is a structured collection of related information organized for easily locating and retrieving the data.
a)
Datasheet
b)
Spreadsheet
c)
Database
d)
Query
9.
A query is when the user __________.
a)
Asks a DBMS to retrieve related pieces of information from a database
b)
Requests that specific information be inputted by the DBMS
c)
Asks a DBMS to display only certain data one record at a time
d)
Inputs data from an outside source into the database
10.
What is a “field on the fly?”
a)
A foreign key field
b)
A primary key field
c)
A relationship field
d)
A statistical field
11.
What type of field can perform mathematical functions?
a)
A Foreign key field
b)
A primary key field
c)
A calculated field
d)
A statistical field
12.
Choose the best choice for a primary key field
a)
EmployeeFirstName
b)
EmployeeLastName
c)
EmployeeDepartment
d)
EmployeeID
13.
What is an advanced query?
a)
When the user creates a query without using the wizard.
b)
When information for more than one table must be used to create a query.
c)
When a query is created from the database view.
d)
When the query is exported to another database
14.
How can a user create a query to only list people with a specific last name?
a)
Queries will list all information in the database regardless of need
b)
Delete all other last names from the query after it has been generated
c)
Enter the last name into the criteria portion of the LastName field
d)
Create a statistical field to generate those specific records.
15.
Of the following, which is database software?
a)
Microsoft Excel
b)
Microsoft Access
c)
Microsoft Sheets
d)
Microsoft Data
16.
Qualifiers on a query
a)
Record
b)
Table
c)
Form
d)
Criteria
17.
Collection of tables that have been joined
a)
Relational database
b)
Foreign key
c)
Form
d)
Database management system (DBMS)
18.
Primary key from another table
a)
Statistical Field
b)
Form
c)
Foreign key
d)
Searching
19.
Row in a database table
a)
Table
b)
Report
c)
Record
d)
Statistical field
20.
Occurs when a single piece of data is related to several other pieces of data
a)
One-to-many relationships
b)
Many-to-many relationships
c)
Design View
d)
Calculated Field
21.
Used by the developers of the database to set up fields
a)
Design view
b)
Field
c)
Primary key
d)
Database management system (DBMS)
22.
Provides summary information related to other data within a table.
a)
Design view
b)
Criteria
c)
Form
d)
Statistical field
23.
Used to collect or display data one record at a time.
a)
Relational database
b)
Form
c)
Report
d)
Primary key
24.
Contains information about specific characteristics of the entry described in a record.
a)
Searching
b)
Relational database
c)
Field
d)
Form
25.
Field that will be used by the DBMS to keep track of records.
a)
Searching
b)
Primary Key
c)
Foreign Key
d)
One-to-many relationships
26.
Handles the collection, storage, sorting, reporting, and organization of data.
a)
Database management system (DBMS)
b)
Calculated field
c)
Criteria
d)
Record
27.
Output of the database of specific information requested by the user.
a)
Tables
b)
Field
c)
Report
d)
Criteria
28.
Contains information arranged in horizontal rows and vertical columns.
a)
Table
b)
Record
c)
Foreign Key
d)
Design view
29.
Performs a calculation based on data within the same table.
a)
Foreign key
b)
Database management system (DBMS)
c)
Form
d)
Calculated field
30.
Method to find a particular value among a set of values.
a)
Field
b)
Record
c)
Criteria
d)
Searching
Reset
