Which of the following is a best practice when you are creating a table containing employee names?
A) Separate the first and last names into two fields.
B) Keep the first and last names together in one field.
C) Assign the Long data type to any field containing names.
D) Create the table in Table Datasheet view.

Question

Quizplus · Accepted Answer

Separating the first and last names into two fields allows for easier sorting and searching by either name. It also enables the use of honorifics and suffixes without causing data redundancy.

Which of the Following Is a Best Practice When You