Most Recent ECDL-ADVANCED Exam Questions & Answers

The default place holders of the Slide Master view cannot apply a hyperlink. You have to create a text box, and then type the text to apply the hyperlink.

Answer option B is incorrect. Mark as Final is used to make a document read only, so that all the proofing, typing, and editing commands get disabled. It is used to prevent the document from being changed.

Answer option C is incorrect. IRM is used to grant access permissions to the users. It is used to protect the content from other users by providing only specific rights to them.

Answer option D is incorrect. Encrypt Document is used to secure a presentation by using a password. It uses encryption to apply security settings.

Chapter: PRESENTATION, ADVANCED - LEVEL

Objective: Multimedia

In order to enhance the performance of the query, James will use the WHERE clause with the SELECT statement as follows:

SELECT * FROM OrderDetails WHERE custname='customer name';

The WHERE clause is used to filter data given in the table. The filter is based on one or more columns given after the SELECT statement. The columns are separated by commas.

Answer option C is incorrect. The DISTINCT clause is used to prevent rows from getting duplicated in the result set. It can only be used with the SQL SELECT statement.

The syntax for the DISTINCT clause is as follows:

SELECT DISTINCT <columns>

FROM <table_name>

WHERE <conditions>

Answer option B is incorrect. The TOP clause is used to retrieve data for the first set of rows. The example is as follows:

SELECT * TOP 10 FROM OrderDetails;

The statement will retrieve only the top ten rows from the OrderDetails table.

Answer option D is incorrect. The GROUP BY clause groups selected rows on the basis of values of specified column(s) for each row, and returns a single row of summary information for each group. Rows that have the same values in the specified grouping column(s) are grouped together. The GROUP BY clause suppresses duplicate rows for the grouping column(s). It does not guarantee the order of the result set. Therefore, the ORDER BY clause should be used with the GROUP BY clause to sort the result set in the desired order. The syntax of the GROUP BY clause is given below:

SELECT column_name, aggregate_function(column_name) FROM table_name WHERE column_name operator value GROUP BY column_name

Consider the following example, EMPLOYEE_EXPENSES table:

P_ID

LastName

Expenses

1

Harry

1000

2

Steve

400

3

Harry

2000

To group the total sum (total order) of each employee from the EMPLOYEE_EXPENSES table, run the following command:

SELECT LastName, Expenses FROM Orders GROUP BY LastName

The output of the command will appear as:

LastName

Expenses

Harry

3000

Steve

400

Chapter: DATABASE, ADVANCED-LEVEL

Objective: Query Design

A TextBox control is an editable control in which a user can edit and modify data. It is of the following types:

Unbound: An unbound textbox control is an empty control. It is not bound to any column of any table. It can be bound to a column by using the ControlSource property.

Bound: A bound textbox control is bound to a column of a table. It displays a single record of the column.

Calculated: It can be used for calculations based on the expression provided in the textbox.

Answer option A is incorrect. It is not a valid type of the TextBox control.

Chapter: DATABASE, ADVANCED-LEVEL

Objective: Form Design

An action query is used to update multiple records in one operation. It is a form of select query that performs an action on the results of the selection process. There are four types of action queries available in Microsoft Office Access 2007, which are as follows:

1. Delete queries: A delete query allows to delete records from one or more tables.

2. Update queries: An update query allows to modify fields. This is used to update a field with an expression or data from another table.

3. Append queries: An append query allows to add records from one or more tables to the end of one or more other tables.

4. Make-table queries: A make-table query allows to create a new table from all or part of the data in one or more tables.

Chapter: DATABASE, ADVANCED-LEVEL

Objective: Query Design

Following are paragraph-level formatting controls:

* Widow/Orphan Control: It is used to prevent a single paragraph line from being stranded on a page all by itself.

* Keep with Next: It is used to force a paragraph to appear with the paragraph that follows.

* Keep Lines Together: It is used to prevent a paragraph from breaking across two pages.

* Page Break Before: It is used to force an automatic page break before the paragraph.

* Do not Hyphenate: It is used to instruct Microsoft Word not to perform hyphenation in a given paragraph.

Chapter: ADVANCED WORD PROCESSING

Objective: Formatting