Which of the following actions will you perform to accomplish the task?

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