The Credit_Rating item in the Customers block of an Order Entry form must be restricted to three
possible values: Good, Poor, or Null (the latter value indicates that the credit rating has not been
determined). Order entry clerks must be able to update this item to any of the preceding three
values.
You want to change the item to a check box labeled “Credit Risk” that should be selected if the
customer has poor credit, the check box should not be selected if the customer’s credit rating is
good or undetermined.
You change the item type to Checkbox, set other properties as shown in the Exhibit, and then run
your form and insert three records: two with good credit and the check box deselected, and one
with poor credit and the check box selected. You commit the data and query the records, with the
following result set:
The first two records show an undetermined credit rating, although your intention was to set the
value to Good for these customers. What change must you make in the properties of the
Credit_Ratinq item to enable values of Good, Poor, and Null to be entered?
A.
Change theinitial Value property to Good.
B.
Change the Check Box Mapping of Other Values property to Not Allowed.
C.
Change theinitial Value property to Good and the Value When Unchecked property to Null.
D.
Change theinitial Value property to Good and the Chock Box Mapping of Other Valued property
to Null.
E.
Change theinitial Value property to Good and the Check Box Mapping of Other Values property
to checked.
F.
Change the item type. It is not appropriate to use a check box to enable entry and update of
more than two valuesinan item.
Explanation:
The only to enable 3 values mentioned to be entered is the current setting. When new record is created it has null value in credit_ranking. Each click on the check box switches from Good to Bad and vice versa (I assume Bad=Poor in this question). Answers E or A disables null and as such doesn’t fulfil question condition in my humble opinion.
Can u please read my comment
What iI understand for the question that – the value should be good when a new record is inserted
– credit_rating should be enabled 3 values good, poor and null
A&E restricts the values to two good and poor
C assign the good when the record is inserted and switch the values between poor and null when the record is updated
F might be right for this particular situation ,but in general check boxes can handle more than two values
In my opinion C most likely the right choice
It’s a matter of interpretation. If we assume your reasoning C is correct but I haven’t found any mention that ‘good’ should be available only initially for a new record : “Order entry clerks must be able to update this item to any of the preceding three values.”
F is the correct answer
hi
please tell … did you pass exam 1z0-151
and what version did you use
please answer me on my e-mail
[email protected]
i pass the exam
F is the correct answer