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.

-To make sure that a field contains all unique values,Kate wants to set up the database so that it will search every existing record for duplicates.What will accomplish this goal for Kate?
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.

-To make sure that a field contains all unique values,Kate wants to set up the database so that it will search every existing record for duplicates.What will accomplish this goal for Kate?
A) case rule
B) field validation rule
C) field format
D) lookup routine

Quizplus · Accepted Answer

The Answer of 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.

-To make sure that a field contains all unique values,Kate wants to set up the database so that it will search every existing record for duplicates.What will accomplish this goal for Kate?
A) case rule
B) field validation rule
C) field format
D) lookup routine

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