Which of the following is true when breaking compound fields into smaller parts?
A)Break names into first name and last name fields.
B)Leave city,state,and zip code together in one field.
C)For faster sorting,include the street address in the same field as the city,state,and zip code field.
D)Always separate the area code from the phone number field.

Question

Quizplus · Accepted Answer

Breaking names into separate first name and last name fields allows for easier searching and sorting by first or last name.

Answer: B
 City, state, and zip code are related and should be kept together in one field for ease of use and accuracy.

Answer: D
 Separating the area code from the phone number field allows for easier searching and sorting by area code, and can also help with formatting and validation.

Therefore, the best choices are A, B, and D.

Which of the Following Is True When Breaking Compound Fields