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…

The correct answer is C. Excel worksheet. 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…

Managing the Access Environment

Question

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?

Options

AHTML file
BText file
CExcel worksheet
DOutlook folder

How the community answered

(35 responses)

A
9% (3)
B
14% (5)
C
74% (26)
D
3% (1)

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 Answer: A, D, and B are incorrect. You can use these three places for importing data into Access, but all these have a complicated process of importing information.

Topics

#data import#Excel integration#pre-import manipulation#data preparation

Community Discussion

No community discussion yet for this question.

Full 77-885 Practice