nerdexam
Microsoft

77-885 · Question #19

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…

The correct answer is C. Define a VBA code. D. Write a macro. In order to accomplish the task, you should perform one of the following tasks: 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…

Managing the Access Environment

Question

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.

Options

  • AUse commands on the External Data tab.
  • BSave the database as a spreadsheet file.
  • CDefine a VBA code.
  • DWrite a macro.

How the community answered

(60 responses)
  • A
    7% (4)
  • B
    17% (10)
  • C
    77% (46)

Explanation

In order to accomplish the task, you should perform one of the following tasks: 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 Answer: B is incorrect. You cannot save the database as a spreadsheet file.

Topics

#import/export automation#VBA code#macros#External Data tab

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 77-885 Practice