You work as a Database Designer for Tech Perfect Inc. The company has a Windows Vista-based computer with Microsoft Office 2010 installed on it. You want to automate the import and export operations available on the External Data tab while working on Microsoft Office Access 2010 .
Which of the following actions will you perform to accomplish the task?
A . Write a macro.
B . Save the database as a spreadsheet file.
C . Define a VBA code.
D . Use commands on the External Data tab.
Answer: A and C
Explanation:
In order to accomplish the task, you should perform one of the following tasks:
Write a macro.
Define a VBA (Visual Basic for Applications) code.
These tasks automate the import and export operations available on the External Data tab while working on Microsoft Office Access 2010.
Answer option D is incorrect. You can use commands on the External Data tab to manually import and export data.
Answer option B is incorrect. You cannot save the database as a spreadsheet file.
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