ECDL Exam ECDL-ADVANCED Topic 8 Question 96 Discussion

Actual exam question for ECDL's ECDL ADVANCED WORD PROCESSING exam

Question #: 96
Topic #: 8

[All ECDL ADVANCED WORD PROCESSING Questions]

James works as a Database Designer for AccessSoft Inc. The company has a Windows Vista-based computer with Microsoft Office 2007 installed on it. The company uses Microsoft Office Access 2007 database named Sales. He has to link a text file to the Access database. He clicks the office button and opens the text file. The file is displayed in the Link Text Wizard. What will happen when James clicks the Finish button in the wizard?

AData of the text file is appended to an existing table and gets affected if there is a change of data in the text file.

BThe data is copied into a new table and is not affected if there is a change of data in the text file.

CA new database will be created and a linked table will be created in the database.

DA linked table will be created in an existing database.

Show Suggested Answer

Suggested Answer: C

When James opens a text file in Microsoft Access, a new database is created and a linked table is created in the new database after the Finish button is clicked in the wizard. The database is created with the same name as that of the text file. The wizard provides an option of renaming the table. The default name of the table is same as that of the text file.

Chapter: DATABASE, ADVANCED-LEVEL

Objective: Import, Export and Link data

by Marica at Sep 06, 2024, 02:02 PM

Limited Time Offer

25%

20 days ago

Option D sounds right. A linked table is the way to go when you want to connect a text file to an existing database.

upvoted 0 times

Pedro

2 days ago

I agree, option D is the correct choice.

upvoted 0 times

...

Annita

23 days ago

I'm leaning towards D, actually.

upvoted 0 times

...

Wynell

25 days ago

I disagree, I believe it's C.

upvoted 0 times

...

Monte

1 months ago

I think the answer is B.

upvoted 0 times

...