nerdexam
Microsoft

77-885 · Question #104

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. The computer has a database named OrdersDatabase…

The correct answer is A. The report will not get affected. After renaming the table, you will find that the report will not get affected. The report will remain connected to the table and work successfully. Answer: D is incorrect. The report will remain connected to the table and work successfully. Answer: C is incorrect. No error will…

Designing Reports

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. The computer has a database named OrdersDatabase created in Microsoft Office Access 2010. The database contains several tables. You have created a report named OrdersReport, which is connected to a table named OrdersTable. After some days, you have renamed the table as OrdersInfo. How will this change affect the report?

Options

  • AThe report will not get affected.
  • BThe report will look blank.
  • CThe report will generate an error.
  • DThe report will be disconnected.

How the community answered

(15 responses)
  • A
    80% (12)
  • C
    7% (1)
  • D
    13% (2)

Explanation

After renaming the table, you will find that the report will not get affected. The report will remain connected to the table and work successfully. Answer: D is incorrect. The report will remain connected to the table and work successfully. Answer: C is incorrect. No error will be generated after renaming the connected table. Answer: B is incorrect. The report will display the information from the connected table.

Topics

#table renaming#report data source#record source#object dependencies

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 77-885 Practice