Case 3 There Is the Database Designer and the People

question 40

Multiple Choice

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. To make sure that a field contains all unique values, Kate can set up the database using a ____ so that the database will search every existing record to make sure the new value does not duplicate an existing value in that field.

• A) case rule
• B) field validation rule
• C) field format
• D) lookup routine

---

Definitions:

Employers Table

A table typically found in databases that stores information related to employees or individuals employed by an organization.

Subdatasheets

A feature in Microsoft Access that allows a nested table to be displayed within the main table, used to show related records.

Totals Button

A feature in database and spreadsheet software that automatically calculates and displays the total for selected numeric fields in a dataset.

Records Group

A set of records categorized or grouped together based on specific criteria within a database management system.