1. (TCO 2) A validation rule (Points : 4) can prohibit values from being entered

Question

1. (TCO 2) A validation rule (Points : 4)

can prohibit values from being entered that may not meet a criterion.

compares a field to a table.

is an error message that appears when a value is incorrectly entered into a field.

makes a value entered into a field appear in a particular format.

Question 2. 2. (TCO 2) An example of a multiple value field would be (Points : 4)

a criteria comparison of values in two or more fields.

a default value that appears automatically.

something that appears in a predefined dropdown list.

when more than one data item can be accepted in a single field.

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

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. 4. (TCO 2) Which of the following below will provide the current computer data as a default? (Points : 4)

--/--/--

CurrentDate()

Date

Date()

Question 5. 5. (TCO 2) To add a list of available choices to a form, use a(n) (Points : 4)

checkbox.

combo box.

option button.

tab control.

Question 6. 6. (TCO 5) A bound control (Points : 4)

always contains a label.

contains a calculation.

must be unique and contain a data field from another underlying source.

must contain a formula.

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

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. 8. (TCO 5) A datasheet form (Points : 4)

is a form that allows the user to change the appearance of the form.

and a table are the same thing.

entry by a user is always linked to the content of a table.

provides the user with the same look as a table.

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

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. 10. (TCO 5) Use the Arrange Form Layout Tool to (Points : 4)

change the form layout

move fields

insert space.

All of the above

Explanation / Answer

1.can prohibit values from being entered that may not meet a criterion.validation rules are applied to restrict the values that

2..when more than one data item can be accepted in a single field. it is A field with multiple values

3.allows the user to type a social security number as 111223333 and it would display as 111-22-3333.

eg:phone number entry format in some forms

4.Date()->it is the date function syntax.

5.checkbox.->you can select the multiple values at once.

6>must be unique and contain a data field from another underlying source.

refrers the value in the database

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.