In some business environments, the database designer also enters the data into the database. In Kate’s large banking firm, however, the actual database entries are not made by the database designers.

After perusing the database, Kate has discovered that one data entry operator might enter a telephone number as 555-555-7777, another as (555) 555-7777, and a third as 1-555-555-7777. When multiple data entry operators enter telephone numbers in different formats, it becomes difficult to produce nicely formatted reports or to locate a particular telephone number.

-Kate would also like to request that the database developer ensure that the data entry operators cannot enter a dollar amount of less than $0.00 in any currency fields.What should she ask be applied to those fields?
A) case rule
B) field validation rule
C) field format
D) lookup routine

Question

In some business environments, the database designer also enters the data into the database. In Kate’s large banking firm, however, the actual database entries are not made by the database designers.

After perusing the database, Kate has discovered that one data entry operator might enter a telephone number as 555-555-7777, another as (555) 555-7777, and a third as 1-555-555-7777. When multiple data entry operators enter telephone numbers in different formats, it becomes difficult to produce nicely formatted reports or to locate a particular telephone number.

-Kate would also like to request that the database developer ensure that the data entry operators cannot enter a dollar amount of less than $0.00 in any currency fields.What should she ask be applied to those fields?
A) case rule
B) field validation rule
C) field format
D) lookup routine

Quizplus · Accepted Answer

In order to ensure that data entry operators cannot enter a dollar amount of less than $0.00 in any currency fields, Kate should apply field validation rules to those fields. Field validation rules ensure that only data that meets specific requirements or criteria can be entered into a field. In this case, the validation rule would check that the value entered is a positive number or zero, and reject any values that are negative. This would help to ensure the accuracy and consistency of the data in the database.

In Some Business Environments, the Database Designer Also Enters the Data