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?
Each correct answer represents a complete solution. Choose two.
A.
Use commands on the External Data tab.
B.
Save the database as a spreadsheet file.
C.
Define a VBA code.
D.
Write a macro.
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 A is incorrect. You can use commands on the External Data tab to manually import and
export data.
Answer B is incorrect. You cannot save the database as a spreadsheet file.