Question 11(TCO 4) In a _____dependency,
Question 11(TCO 4) In a _____dependency, a relationship exists when one attribute uniquely identifies
another attribute. For example, if we had a table consisting of the following attributes: instructor, course, time, and room number. Course would uniquely identify an instructor.Course would uniquely identify an instructor.
structural
functional
referential
transitive
Flag this Question
Question 12
(TCO 5) Which form type displays records in a tabular format similar to a Datasheet view but has more editing options, such as adding graphics?
Datasheet Form
Multiple Items Form
Split Form
Subform
Flag this Question
Question 13
(TCO 5) A calculated control
contains a formula that displays the result.
is a bound box.
is a text box containing a description.
is an unbound box that the user will fill in with a numeric value.
Flag this Question
Question 14
(TCO 6) Which of the following is a term used to describe the names of controls, fields, or properties?
Function
Identifier
Operator
Value
Flag this Question
Question 15
(TCO 6) After running a query, which view will be shown?
Datasheet
Design
Query
Result
Flag this Question
Question 16
(TCO 9) Normalization improves
organization..
flexibility.
easier to modify.
All of the above
Flag this Question
Question 17
(TCO 2) A required field that is used in entering data is a field that
appears with a specific value.
can be left blank.
cannot be left blank.
is selected from a list of values.
Flag this Question
Question 18
(TCO 8) The Switchboard Manager is an Access utility that is used
by all database users.
to c reate and manage the menu items for a switchboard. manage the menu items for a switchboard.
to make certain objects unavailable to some users and available to others.
to manage and optimize the database.
Flag this Question
Question 19
(TCO 9) To secure an Access database, all of the following should be done EXCEPT
digitally sign a database and open it in a trusted location.
require a password to open a database.
run the Table Analyzing Wizard and Performance Analyzer.
save a database with the .accde file extension.
Flag this Question
Question 20
(TCO 9) A digital signature
helps ensure that a file has not been tampered with and will be safe to open.
is used with database files exclusively.
is a tracking system of a file.
must be obtained from a certification authority, such as VeriSign.
Flag this Question
Question 21
(TCO 10) After creating an ACCDE file, you
can convert it back to its source format.
will see a “file already in use” message that continues to display to all other users.
will be able to modify forms and reports but not tables.
will need to go back to the original file if an underlying object requires a change.
Flag this Question
Question 22
(TCO 4) The term cascading refers to
data changes travel from one table to another.
data is put in sequential order.
queries can retrieve data at a faster rate.