ECDL Exam ECDL-ADVANCED Topic 6 Question 5 Discussion

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.

Chapter: DATABASE, ADVANCED-LEVEL

Objective: Import, Export and Link data