ECDL ECDL-ADVANCED valid study dumps : ECDL/ICDL Advanced

Alan is a student of DFH Public School. He is creating a project report using Microsoft Excel XP. In the process of creating a project, he needs to frequently open a file that he has already created. Therefore, he wants to assign this file as a hyperlink to the 'Research' button on the Standard toolbar. Which of the following steps will he take to accomplish the task?

• A. Choose Format > Style
  Select Hyperlink from the Style name box.
  Click the Modify button.
  Select the required formatting.
• B. Choose Tools > Customize
  Right-click on the toolbar button, and then choose Assign Hyperlink > Open from the shortcut menu.
  Select the file to be linked to.
• C. Choose Tools > Options from the menu bar.
  Click the AutoFormat As You Type tab.
  Clear the Internet and network paths with hyperlink check box.
• D. Right-click on the toolbar button, and then choose Hyperlink from the shortcut menu. Select the file to be linked to.

James works as a Database Designer for AccessSoft Inc. The company has a Windows Vista computer, which has a database named Orders. The database contains a table named OrderDetails. Users run queries against the database to place orders of customers. They also retrieve data related to the processing of orders and information about the customers who place orders. Users complain that the retrieval of data is very slow. James opens the following query:
SELECT * FROM OrderDetails;
What should he do to enhance the performance of the query?

• A. Use the DISTINCT clause with the SELECT statement.
• B. Use the WHERE clause with the SELECT statement.
• C. Use the GROUP BY clause with the SELECT statement.
• D. Use the TOP clause with the SELECT statement.

You have a table named Expressions in Microsoft Office Access 2007 and you export this table directly to a SharePoint list. Which of the following actions will MS Access perform while you export the table?

• A. It converts the table to an HTML table.
• B. It creates a copy of the table and stores the copy as a list.
• C. It exports only the main datasheet.
• D. It creates a RTF document.

Which of the following steps will you take to insert a caption to an image?

• A. Insert > Insert Caption > Caption
• B. References > Caption > Insert a Caption
• C. References > Insert Caption > Caption
• D. Insert > Caption > Insert a Caption

Which of the following view types allows a user to manipulate data on the form created in Access 2010?

• A. Datasheet view
• B. PivotTable view
• C. PivotChart view
• D. Form view