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.
HTML file
B.
Text file
C.
Excel worksheet
D.
Outlook folder
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 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.