ECDL ECDL-ADVANCED Exam Actual Questions

Name: ECDL ADVANCED WORD PROCESSING
Brand: QA4Exam
SKU: ECDL-ADVANCED
Price: 30 USD
Availability: InStock
Rating: 5.0 (250 reviews)

The questions for ECDL-ADVANCED were last updated on Sep 21, 2024.

Viewing page 1 out of 46 pages.
Viewing questions 1-5 out of 232 questions

Unlock Access to All 232 Questions & Answers

Question No. 1

Which of the following properties binds the forms and reports to a source from which data is to be retrieved?

AControlSource

BRowSource

CRecordSource

DCan Grow
Explanation:
The RecordSource property belongs to the form and report objects. This property binds the object to a source from which data is to be retrieved. This source can be a table or a query. When a form or a report is bound to a table or a query, the controls can be bound to a column of the table through the ControlSource property.
Answer option D is incorrect. The Can Grow property allows a control to adjust its dimensions according to the contents present in the control. A control grows vertically to adjust its contents so that all the contents can be displayed. The default value of the Can Grow property is false.
Answer option A is incorrect. The ControlSource property bounds a control to a field of a table. If a control is bound to a field by using this property, the control is known as a bound control. If the value of this property is blank, the control is known as an unbound control. If the ControlSource property contains an expression, the control is known as a calculated control.
Answer option B is incorrect. The RowSource property belongs to the combo box and list box controls. When these controls are bound to a column by the RowSource property, all the data of the column is displayed in the list box or the combo box.

Show Answer

Correct Answer: C

Chapter: DATABASE, ADVANCED-LEVEL

Objective: Query Design

Question No. 2

Which of the following are the types of action queries?

Each correct answer represents a complete solution. Choose all that apply.

AUpdate

BDelete

CInsert

DAppend
Explanation:
An action query is used to update multiple records in one operation.
Following are the four types of action queries:
Delete queries: A delete query is used to delete records from one or more tables.
Update queries: An update query is used to modify fields. It is used to update a field with an expression or data from another table.
Append queries: An append query is used to add records from one or more tables to the end of one or more other tables.
Make-table queries: A make-table query is used to create a new table from all or part of the data in one or more tables.
Answer option C is incorrect. It is not a valid type of action query.

Show Answer

Correct Answer: A, B, D

Chapter: DATABASE, ADVANCED-LEVEL

Objective: Table Design

Question No. 3

Which of the following are the ways to create a new blank presentation?

Each correct answer represents a complete solution. Choose all that apply.

AClick New Slide in the Home tab and then select the Blank presentation option.

BRight-click on the current presentation slide and click the New Slide option.

CPress Ctrl+M to insert a new blank presentation.

DRight-click on the first slide and click the New Slide option.

Show Answer

Correct Answer: A, C, D

Following are the ways to create a blank presentation:

Click New Slide in the Home tab and then select the Blank presentation option.

Right-click on the first slide and click the New Slide option.

Press Ctrl+M to insert a new blank presentation.

Answer option B is incorrect. It is not a correct way to create a new blank presentation.

Chapter: PRESENTATION, ADVANCED - LEVEL

Objective: Slides

Question No. 4

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 Answer

Correct 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

Question No. 5

Jasmine creates a presentation. She wants to start another presentation after completing the current presentation during the slide show. Which of the following will she use to accomplish the task?

AHyperlink

BReuse Slides

CAction Buttons

DSmartArt

Show Answer

Correct Answer: A

Hyperlinking is a process to introduce a dynamic textual environment by attaching links to the Uniform Resource Locator (URL). It is used to link various elements of a slide to another slide. It can also be used to interconnect excel sheets, word document, or any other presentation. A user can create a hyperlink to the following:

A slide in the same presentation.

A slide in a different presentation.

An e-mail address.

A page or file on the Web.

A new file.

Answer option B is incorrect. The Reuse Slides feature is used when a user selects a slide from a presentation and reuses it into another presentation.

Answer option D is incorrect. SmartArt is a visual graphic used to represent the information effectively and efficiently. It is used to create designer-quality illustrations. A user can increase the emphasis of information by adding SmartArt. Though a SmartArt graphics audience of a presentation can understand and recall information better than a text, it is necessary to visualize what type and layout are best for displaying data, and what a user wants to convey with a SmartArt graphic. A user can quickly convert slide text to a SmartArt graphic. In addition, a user can add animation to a SmartArt graphic in Office PowerPoint 2010 presentations.

Answer option C is incorrect. The action buttons are the predefined buttons that are used to traverse quickly and efficiently in a presentation. They are used for defining hyperlinked objects. The hyperlinked objects can be a Web page, a file, or a network location. The action buttons are mostly used for self-executing presentations.

Chapter: PRESENTATION, ADVANCED - LEVEL

Objective: Multimedia

Unlock All Questions for ECDL ECDL-ADVANCED Exam

Full Exam Access, Actual Exam Questions, Validated Answers, Anytime Anywhere, No Download Limits, No Practice Limits

Get All 232 Questions & Answers