Newest ECDL-ADVANCED Practice Questions at Zero Cost

Get a glimpse of the real ECDL-ADVANCED certification exam challenges with our free ECDL-ADVANCED practice test questions.

Question 1

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.

Correct Answer: 1

A, C, D

Question 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.

Correct Answer: 2

A, B, D

Question 3

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.

Correct Answer: 3

Question 4

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 two tables named Customers and Details created in Microsoft Access 2010. You need to retrieve some selected information of customers for each state in which your company does business. Which of the following types of query will you create to accomplish the task?

AParameter query

BCrosstab query

CSelect query

DAction query
Explanation:
To accomplish the task, you will create a parameter query.
The different types of queries in Microsoft Access 2010 are as follows:
Select query: It retrieves and displays records in the Table window in Datasheet view.
Crosstab query: It calculates and restructures data for easier analysis.
Action query: It performs operations on the records that match specified criteria.
Parameter query: It allows a user to prompt for a specific information to use as selection criteria in the query.

Correct Answer: 4

Question 5

You work as an Office Assistant for Company Inc. You are creating a presentation, and you have four bullet points in the presentation. You want to turn the bullet points into the Basic Matrix diagram that increases the efficiency and effectiveness of the presentation as shown in the following images: Which of the following will you use to accomplish the task?

AConvert

BSmartArt

CShape Effects

DChange Shape
Explanation:
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. Through the SmartArt graphics, the audience of a presentation can understand and recall information better than a text. Before creating a SmartArt graphic, it is necessary to visualize what type and layout are best for displaying data, and what a user wants to convey with the SmartArt graphic. Take the following steps to create a SmartArt graphic from bulleted texts:
Select bulleted points.
Click the Home tab. In the Paragraph group, click the Convert to SmartArt icon.
The SmartArt gallery appears. Select a layout to be applied.
The selected bulleted texts will be converted to the selected SmartArt graphic.
Answer option C is incorrect. The Shape Effects option is used to apply shape effects (such as Glow, Bevel, etc.) on objects.
Answer option D is incorrect. The Change Shape option is used to change the shape of a picture.
Answer option A is incorrect. The Convert button is used to convert a SmartArt graphic to shape or text, so that it can be customized.
Chapter: PRESENTATION, ADVANCED - LEVEL
Objective: Multimedia

Correct Answer: 5

Master the ECDL Advanced ECDL-ADVANCED exam like never before! You’ve reviewed the free ECDL-ADVANCED practice questions, but the actual ECDL certification exam demands more. Elevate your preparation with Certsmarket premium ECDL-ADVANCED practice exam questions.

Explore Free ECDL-ADVANCED Practice Questions for Exam Mastery

Our Community

What our students say about us?