Question 1
5 / 5 pts
(CO 1) A primary key is
a field or set of fields that uniquely identifies a record.
a key that uniquely identifies columns in a table.
Correct!
the key used to uniquely identify a record in
...
Question 1
5 / 5 pts
(CO 1) A primary key is
a field or set of fields that uniquely identifies a record.
a key that uniquely identifies columns in a table.
Correct!
the key used to uniquely identify a record in a table.
a nonunique value.
Question 2
5 / 5 pts
(CO 1) What Microsoft Access feature would give a United Parcel Service (UPS) manager the ability to ask
questions like “How many UPS tubes were shipped Monday?” and “What was the total revenue
generated from UPS Express box large in November 2017?”
Parameter query
Primary keys
Correct!
Table connections or query
Foreign keys
Question 3
0 / 5 pts
(CO 1) Which one of the following tools is the quickest way to create a tabular report in MS Access based
on the selected table or query?
Report Design tool
Correct Answer
Report Wizard tool
You Answered
Blank Report tool
Report tool options
Question 4
5 / 5 pts
(CO 1) Most of the printed documents generated by managers using Access will come from
queries.
Correct!
reports.
tables.
forms.
Question 5
3 / 5 pts
(CO 1) A Report section that is used to summarize grouped field data is
Correct Answer
group footer.
report footer.
group header.
You Answered
detail.
Question 6
5 / 5 pts
(CO 2) A table is also recognized as a(n)
domain.
Correct!
entity.
key.
cardinality.
Question 7
1 / 5 pts
(CO 2) SQL is a fourth-generation language that is
Correct Answer
table oriented and nonprocedural.
oriented toward static data.
flat-file oriented and nonprocedural.
You Answered
procedural and record oriented.
Question 8
5 / 5 pts
(CO 3) Which of the following should be considered when designing a database?
How calculated fields are used
The relationships between records
The relationship between attribute keys
Correct!
Store data in its smallest parts
Question 9
5 / 5 pts
(CO 3) The following data type would appear as a checkbox in a table.
Attribute
Correct!
Yes/No
Text
Number
Question 10
5 / 5 pts
(CO 3) Which of the following does NOT describe a caption property?
The label allows spaces between words.
A label can substitute for a field name in datasheet view.
The caption appears in datasheet view, form, and report.
Correct!
The label can be used in place of a field name in an expression.
[Show More]