Which of the following is the best place to perform the above listed tasks?

You want to perform the following tasks to manipulate data before importing it into Access:

• Add fields.

• Combine fields.

• Use complex mathematical functions.

Which of the following is the best place to perform the above listed tasks?
A . Text file
B . Outlook folder
C . HTML file
D . Excel worksheet

View Answer

Answer: D

Explanation:

A Microsoft Office Excel worksheet is the best place to perform the following tasks to manipulate data before importing it into Access:

• Add or remove fields.

• Combine or split fields.

• Use complex mathematical functions.

You can easily import a worksheet or a named range from a worksheet into a new table or an existing table. You can also import some particular fields from a worksheet or a named range into Access. Answer options C, B, and A are incorrect. You can use these three places for importing data into Access, but all these have a complicated process of importing information.

Reference: http://office.microsoft.com/en-us/access

Chapter: DATABASE, ADVANCED-LEVEL

Objective: Import, Export and Link data