5 / 5 pts
(CO 1) MS Visio is used during database design for the following reasons.
It calculates formulas.
Correct!
It depicts entities
... [Show More] and relationships between entities.
It sets reports.
It can query information.
Question 2
5 / 5 pts
(CO 1) In a table, the _____ view is where you add, edit, and delete records.
SQL
layout
Correct!
datasheet
design
Question 3
5 / 5 pts
(CO 1) When creating a report in Access, what report tool best outlines the following description? This report tool asks a series of questions and helps the designer create a report most suitable based on the answers the designer has given.
Blank report tool
Tabular layout report
Label tool
Correct!
Report wizard
Question 4
0 / 5 pts
(CO 1) All of the following filters work except
filter by form with a comparison operator.
filter by selection with an equal condition.
You Answered
filter by selection with a comparison operator.
Question 5
0 / 5 pts
(CO 1) A detail line is used to
All of the above
You Answered
print more detailed information on one record only.
provide additional field information on a record.
repeat data for each record in the record source.
Question 6
5 / 5 pts
(CO 2) A field that uniquely identifies each record in a table is a
relationship.
Correct!
primary key.
link.
foreign key.
Question 7
5 / 5 pts
(CO 2) SQL is a fourth-generation language that is
procedural and record oriented.
flat-file oriented and nonprocedural.
Correct!
table oriented and nonprocedural.
oriented toward static data.
Question 8
5 / 5 pts
(CO 3) Which of the following should be considered when designing a database?
The relationship between attribute keys
Correct!
Store data in its smallest parts
How calculated fields are used
The relationships between records
Question 9
5 / 5 pts
(CO 3) All of the following applies to data redundancy except
output could be incorrect if the first and second locations of the same data are not updated.
it requires updating in two locations.
Correct!
data is always linked in two tables.
the same data exists in two tables.
Question 10
5 / 5 pts
(CO 3) Which of the following is NOT true of indexed property?
An example of a setting is yes (no duplicates).
Indexing a table speeds the retrieval time.
Correct!
Setting the index requires each record to be scanned sequentially and saves time searching data.
Primary keys must be indexed.
Question 11
5 / 5 pts
(CO 4) When building a calculated field, formulas can be created using the
report builder.
table wizard.
form wizard.
Correct!
expression builder.
Question 12
0 / 5 pts
(CO 5) To edit a form, use
datasheet view.
design view.
You Answered
layout view.
wizard view.
Question 13
5 / 5 pts
(CO 5) The following are form creation tools except
Correct!
form layout.
form wizard.
form design.
blank form.
Question 14
0 / 5 pts
(CO 6) Which of the following statements is NOT correct about a query?
You Answered
Instructions on which data to display are saved within a query.
Changing data values in a query will not change data values in a table.
Instructions on the format to display data are saved within a query.
Data is not saved within a query.
Question 15
5 / 5 pts
(CO 6) Using the rules for order of operations, what is the result of the following expression: (4 * 3) +1 + 4 - 2 * 3 + 5?
50
Correct!
16
18
11
Question 16
0 / 5 pts
(CO 9) All of the following are drawbacks to normalization, except
input/output resources.
CPU usage.
less tables and larger columns.
You Answered
memory usage.
Question 17
5 / 5 pts
(CO 2) A required field that is used in entering data is a field that
appears with a specific value.
can be left blank.
is selected from a list of values.
Correct!
cannot be left blank.
Question 18
0 / 5 pts
(CO 8) All of the following describe how a Navigation Form is used except
is another term for a specific report.
You Answered
click the create tab and then navigation in the forms group to create a navigation form.
helps users open forms and reports.
has the look and feel of a web form.
Question 19
5 / 5 pts
(CO 9) A good password should have
Correct!
a combination of six to eight letters in uppercase and lowercase, numbers, and symbols.
part of your account name.
a combination of five letters.
a word or name that is easy to remember by the user, such as the name of their children.
Question 20
5 / 5 pts
(CO 9) All of the following describe a digital signature certification authority except
a certification authority is a commercial company that is highly regulated in most countries.
Correct!
certification authority companies establish their own rules and regulations that users must follow.
a certification authority company provides a digital signature when a high level of security is needed to protect the contents of a database.
a fee is charged for the service of issuing and validating identities using a digital signature.
Question 21
0 / 5 pts
(CO 10) ACCDE files
give users permission to fully access a database.
You Answered
give users permission to create and change forms and reports within a database.
deny users permission to create forms and reports but will allow them to modify forms and reports.
deny users permission to change data but not modify a database.
Question 22
5 / 5 pts
(CO 4) Which database property type helps keep data consistent when doing data entry?
Correct!
Validation rule
Expression
Indexed
Validation text
Question 23
Not yet graded / 40 pts
(CO 1) Designing a database often involves obtaining different perspectives from various sources to gather information. Discuss the importance of end-user interviews in the data requirements gathering process.
Question 24
Not yet graded / 40 pts
(CO 2) Explain the terms entity, relationship, and attributes. Describe how they are used in a database.
Question 25
Not yet graded / 40 pts
(CO 4) What are the advantages and disadvantages of the denormalization process?
maintain within a table. Update, insert, and delete queries take a performance hit due to high data volume from redundancy. Redundancy increases storage size causing waste. Lack of referential integrity leads to dirty data.
Question 26
Not yet graded / 40 pts
(CO 4) Explain 1NF, 2NF, and 3NF as related to database design. [Show Less]