Case 3 There is the database designer and the people who enter the data. Sometimes this is the same person, but in Kate's large banking firm, the actual database entries are not made by the people who designed the database. A data entry operator might enter a telephone number as 555-555-7777, (555) 555-7777, or 1-555-555-7777. If multiple data entry operators enter telephone numbers in different reports, it becomes difficult to produce nicely formatted reports or locate a particular telephone number. Kate can set up a ____ to make sure that data entry operators cannot enter a dollar amount of less than $0 in the database.
A) case rule
B) field validation rule
C) field format
D) lookup routine

Question

Quizplus · Accepted Answer

A field validation rule can ensure that data entered into a specific field meets certain criteria or format, such as a dollar amount greater than $0. The other options (case rule, field format, and lookup routine) do not specifically address the issue of data validation.

Case 3 There Is the Database Designer and the People