devry bis245 week 5 Quiz latest 2016 may

devry bis245 week 5
Quiz latest 2016 may

1. Question : (TCO 2) A default value is

a predefined list of values that can be
selected by the user.

a value that cannot be lower or higher than
the selected limit.

a specific value that automatically appears
in a field and has edit capabilities.
a specific value that automatically appears
in a field that cannot be changed by the user.

Question 2. Question
: (TCO 2) Validation text is

an error message that provides instruction on
what to fix when an incorrect value is entered into a field.
a list of predefined values that can be
entered in a field.

a comparison of values entered in two fields.

a field that requires a value of characters
or text only.

Question 3. Question
: (TCO 2) An input mask

allows one record to have more than two field
values.

allows the user to type a social security
number as 111223333 and it would display as 111-22-3333.
confirms that a value greater than 100 is a
valid value.

is a list of values that are previously
defined from which the user can select one item.

Question 4. Question
: (TCO 2) An input mask that
will only allow for digits from 0 to 9 and the + or – sign is

AA.

99.

##.

00.

Question 5. Question
: (TCO 2) An input mask placed
on a form will apply to

all forms based on that table.

all forms in the database.

all forms based on that table and the table
itself.

that specific form only.

Question 6. Question
: (TCO 5) To edit a form, use
the

design view.

datasheet view.

layout view.

layout view or design view.

Question 7. Question
: (TCO 5) Which statement below
best describes how designers and users work with forms?

The designer and the users will edit and
update forms.

The designer of a form will make it
functional and easy to use the first time.
The designer of a form will need to keep
revising a form as suggested by the users.

The designer and users will never need to edit a well-designed form.

Question 8. Question
: (TCO 5) If you click on the
form tool, you will open a(n)

existing form.

new form in design view.

new form in layout view.

wizard to design a form.

Question 9. Question
: (TCO 5) A Split Form is best
defined as

are most effective when run again on one
table.

a form that combines two views of the same
record source. Sections may be displayed differently depending on the view.
can perform complex What-if analyses.

require a macro in order to be effective.

Question 10. Question
: (TCO 5) All of the following
are aggregate functions EXCEPT

average.

count.

minimum.

subtract.