ECDL-ADVANCED Exam Questions Instant Access

Question 1

Which of the following queries prompts a user for information to be used in the query?

ASelect

BParameter

CAction

DUnmatched
A parameter query prompts a user for information to be used in the query. For example, a range of dates. This type of query is commonly useful when queries are used as the basis for a report that is run periodically, but with different values at different times.
Answer option A is incorrect. A select query is used to retrieve data from one or more tables. It is used to display the results in a datasheet.
Answer option D is incorrect. An unmatched query is a form of select query that locates records in one table that does not have related records in another table. For example, a user can use this to locate people in the customer table who do not have an order in the order table. The Find Unmatched Query wizard guides the user through the process of specifying the tables and fields to use in the query.
Answer option C is incorrect. An action query is used to update multiple records in one operation.

Answer : B

Chapter: DATABASE, ADVANCED-LEVEL

Objective: Table Design

Question 2

Which option of Freeze Panes will you use to freeze a row in a worksheet?

AUnfreeze Panes

BFreeze Column

CFreeze Selected Row

DFreeze Top Row
Explanation:
Take the following steps to freeze a row in a worksheet:
Go to the Freeze Panes drop down menu in the View tab.

Select the Freeze Top Row option in the Freeze Panes drop down menu.

After completing the above steps, you will see that the row is not moving while scrolling the worksheet.

Answer options A, B, and C are incorrect. These options cannot be used for this purpose.
Reference: ECDL/ICDL Exam Course Manual, Contents: 'Freeze Panes'
Chapter: ADVANCED SPREADSHEETS
Objective: Editing

Answer : D

Question 3

Which of the following is a list of the references in a legal document, such as cases, statutes, and rules, along with the page numbers on which the references appear?

ATable of Authorities

BTable of Contents

CTable of Pictures

DTable of Figures

Answer : A

Table of Authorities is a list of the references in a legal document, such as cases, statutes, and rules, along with the page numbers on which the references appear.

Answer option B is incorrect. Table of Contents is a list of chapters and their sections of a book or a document. Use the list along with the respective page numbers of the chapters and their sections for easy navigation.

Answer option D is incorrect. Table of Figures is a list of the captions for pictures, charts, graphs, slides, or other illustrations in a document. Table of Figures given along with the page numbers on which the captions appear.

Answer option C is incorrect. It is not a valid type of list.

Chapter: ADVANCED WORD PROCESSING

Objective: Collaborative Editing

Question 4

Which of the following steps will you take to add an AutoCorrect entry?

AClick the AutoCorrect Options on the Data tab.

BClick the PowerPoint Options on the Insert and AutoCorrect Options button.

CClick the AutoCorrect Options on the Format.

DClick the PowerPoint Options on the Microsoft Office button and AutoCorrect Options button.

Answer : D

Take the following steps to add an AutoCorrect entry:

Click the Microsoft Office button. Click the PowerPoint Options button.

The PowerPoint Options dialog box appears. Click on the Proofing page tab, and then click the AutoCorrect Options button.

The AutoCorrect dialog box appears. In the Replace text box, type a word that is commonly misspelled. In the With text box, type the correct spelling of the word. Click the Add button, and then click the OK button.

Answer options A, B, and C are incorrect. These are not correct ways to add an AutoCorrect entry.

Chapter: PRESENTATION, ADVANCED - LEVEL

Objective: Managing Presentations

Question 5

Which of the following text box properties is used to determine whether the text box is bound, unbound, or calculated?

AControlSource

BTextFormat

CName

DCan Grow

Answer : A

The ControlSource property is used to determine whether the text box is bound, unbound, or calculated. 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 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 C is incorrect. The name property refers to the name given to a control in a form or a report. The default name of the control is the control name plus 1, 2, 3, etc. The name of the control should be meaningful so that it can be easily used during programming. The value of this property cannot be changed programmatically. It can be changed only in design view.

Answer option B is incorrect. The TextFormat property of a control helps to change a text to rich text format. This helps to apply multiple formatting options for the text in a control. A user can change the format of the text to bold, italics, etc., The user can also change the font of the selected text and can apply other types of formatting.

Chapter: DATABASE, ADVANCED-LEVEL

Objective: Form Design

Question 6

You are working on an Access form named Form-A. You have opened Property Sheet to view the form's properties and make the required changes. Property Sheet consists of five tabs with a different set of properties. Which of the following tabs specifies how a value is displayed and the data source is bound to control source, input mask, validation rule, default value, and other data type?

AData

BEvent

CFormat

DOther
Explanation:

The Data tab of Property Sheet specifies how a value is displayed and the data source is bound to control source, input mask, validation rule, default value, and other data type.

What are the various tabs of the Property Sheet?
The various tabs of the Property Sheet are as follows:
Format: It specifies how a label or value is displayed. It includes font, size, border, special effect, and scroll bar.
Data: It specifies how a value is displayed and the data source is bound to control source, input mask, validation rule, default value, and other data types.
Event: It displays all events in the form of a call to a macro or a VBA procedure.
Other: It displays additional characteristics of control, such as control name and description.
All: It displays all properties of control.

Answer : A

Chapter: DATABASE, ADVANCED-LEVEL

Objective: Form Design

Question 7

You have created a database named Sales. The database consists of a table named Employees. You want to ensure that all names of the employees should be displayed while filling a form. Which of the following controls will you use to accomplish the task?

ALabel

BTextbox

CCombobox

DListbox

Answer : C, D

You will use the listbox and combobox controls. When these controls are bound to a column of a table, all data of that column is displayed in these controls. You cannot edit or delete the data from these controls. You can only view the data.

Answer option B is incorrect. The textbox control is bound to a column but it displays only one record at a time. According to the scenario, you want to ensure that all names of the employees should be displayed and the textbox control will not accomplish this task.

Answer option A is incorrect. The label control does not have the ControlSource property so it cannot be bound to any column of any table. A label is used to provide a name to a bound control. Reference: ECDL/ICDL Exam Course Manual, Contents: 'Form'

Chapter: DATABASE, ADVANCED-LEVEL

Objective: Form Design

ECDL ADVANCED WORD PROCESSING ECDL-ADVANCED Exam Questions