- All Exams Instant Download
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
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
Latest ECDL-ADVANCED Dumps Valid Version with 232 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
Subscribe
Login
0 Comments
Inline Feedbacks
View all comments