ECDL/ICDL Advanced - ECDL-ADVANCED Exam Practice Test
Which of the following are the types of the TextBox control?
Each correct answer represents a complete solution. Choose all that apply.
Each correct answer represents a complete solution. Choose all that apply.
Correct Answer: A,B,C
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
Choose and re-order the steps that you will take to create a report based on the Staffs table in Microsoft Office Access 2010.




Correct Answer:

1 - In the Navigation pane, click the Staffs table
2 - Click the Create tab.
3 - Click the Report tool.
4 - Click the Save button
5 - type a name for hte report
6 - Click the OK button.
Explanation:
Take the following steps to create a report in Microsoft Office Access 2010:
In the Navigation pane, click the table that is required to be used in the report.

Click the Create tab.

Click the Report tool on the Reports group.

Click the Save button.

Type a name for the report and then click the OK button.

Reference:
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Report Design
You work as a System Analyst for Company Inc. You are using Microsoft PowerPoint 2010. You have inserted a chart in the presentation. You want to insert an equation in the chart. Which of the following will you use to accomplish the task?
Correct Answer: E
Vote an answer
Which of the following are elements of Slide Master?
Each correct answer represents a complete solution. Choose all that apply.
Each correct answer represents a complete solution. Choose all that apply.
Correct Answer: B,C,D
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
You work as an Office Assistant for Company Inc. You are creating a document in Word 2010. You have assigned a bookmark to a block of text or to an item; the bookmark will appear on the screen in brackets. After a bookmark has been assigned to a location, it will appear as an I-beam. Which pane in the following image of the Word Options dialog box is used to accomplish the task?


Correct Answer:

Explanation:
If users assign a bookmark to a block of text or to an item, the bookmark will appear on the screen in brackets ([. . .]). If a bookmark is assigned to a location, the bookmark will appear as an I-beam. The brackets and I-beam are not printed. Take the following steps to display the bookmark indicators:
1. Click on the File tab and then click Options.
2. The Word Options dialog box opens.
3. Click the Advanced pane. Select the Show bookmarks check box under Show document content.
4. Click the OK button.
Chapter: ADVANCED WORD PROCESSING
Objective: Referencing
You are working on an Access report named Progress. You want to apply a layout to the report that is similar to a paper form, with labels to the left of each field. Mark the tab/button that you will click to accomplish the task.


Correct Answer:

Explanation:
In order to accomplish the task, you should click the Arrange contextual tab, and then click the Stacked button in the Table group.

Reference:
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Report Design
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?
SELECT * FROM OrderDetails;
What should he do to enhance the performance of the query?
Correct Answer: C
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
Which of the following steps will you take to remove background of slides?
Correct Answer: D
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
You work as an Office Assistant for Company Inc. You are assigned the task of preparing a document. You have inserted some bullet points in the document. Now you want to use a picture as the bullet sign in the document. Which of the following will you use to accomplish the task?


Correct Answer:

Explanation:
A user can change the symbol of a bullet by using the Bullets drop-down list.
Chapter: ADVANCED WORD PROCESSING
Objective: Formatting
Which of the following statements will you use to delete a table from a database?
Correct Answer: C
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).