ECDL ADVANCED WORD PROCESSING ECDL-ADVANCED Exam Questions

Answer : C

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 B 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 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 D 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

Answer : C

Take the following steps to remove background of slides:

Click the Design tab.

Select the Background Styles drop down menu in the Design tab. Click the Reset Slide Background option to remove background of slides.

Answer options B, A, and D are incorrect. These are not valid steps to remove background of slides. Reference: ECDL/ICDL Exam Course Manual, Contents: 'Background of slides'

Chapter: PRESENTATION, ADVANCED - LEVEL

Objective: Pictures, Images, Drawn Objects

Answer : D

The Gradient Fill option contains an option Direction to change the direction of fill color. In order to accomplish the task, you have to right-click the chart title, select the Gradient Fill radio button, and then select a direction to be applied.

Answer option C is incorrect. The Picture or Texture Fill option is used to apply the texture or picture on the chart title.

Answer option D is incorrect. Label Options contains checkboxes for specifying the values of the label text.

Chapter: PRESENTATION, ADVANCED - LEVEL

Objective: Charts/Graphs

Answer : A, B, D

Slide Master comprises a set of formatting groups. Following are the elements of Slide Master:

1. Edit master

2. Master layout

3. Edit theme

4. Background

5. Page setup

6. Close

Chapter: PRESENTATION, ADVANCED - LEVEL

Objective: Managing Presentations

Answer : D

You have two tables named table1 and table2 in Microsoft Office Access 2007. In order to perform the given tasks, you will build a one-to-one relationship between both tables. This relationship provides functions to perform all these tasks.

What is a one-to-one relationship between common fields in a table?

A one-to-one relationship is an association between two tables in which each record in one table can have only one related record in another table. This type of relationship is not generally used because it is easier to shift all the fields in one table. A one-to-one relationship is created if both of the related fields are primary keys or have unique limitations. A one-to-one relationship performs the following tasks:

* It divides a table with many columns.

* It isolates part of a table for security reasons.

* It stores short-lived data and deletes this data by deleting the table.

* It stores information that applies only to a subset of the main table.

Answer option A is incorrect. A one-to-many relationship is the most common type of relationship. In this type of relationship, a row in the first table can have one or more matching rows in the second table, but a row in second table can have only one matching row in the first table. For example, the States and Cities tables have a one-to-many relationship. Each state has many cities, but each city comes under only one state. A one-to-many relationship is created if the foreign key column does not have a unique constraint.

Answer option B is incorrect. A many-to-many relationship is an association in which two one-to-many relationships are connected together through a third table. This third table is called the junction table. A many-to-many relationship can be viewed in a database that contains Products, Orders, and Order Details tables. The Orders table and the Products table have a many-to-many relationship that is defined by creating two one-to-many relationships to the Order Details table. Each record in the Orders table has many records in the Products table and each record in the Products table has many records in the Orders table.

Answer option C is incorrect. Container-managed relationships (cmr) are relationships that exist between two entity beans within a local interface. The bean provider declares these relationships in the bean class, and the container implements the relationships using the information defined in the deployment descriptor. There are three kinds of container-managed relationships as follows:

1. One-to-one

2. One-to-many

3. Many-to-many

The relationship fields in the bean class are represented using the abstract get and set methods. Reference: http://office.microsoft.com/en-us/access/ha101205341033.aspx#1

Chapter: DATABASE, ADVANCED-LEVEL

Objective: Table Design

Answer : D

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

Answer : B

Take the following steps to protect control fields in a form:

Select the control that you want to protect.

Select the Ribbon's Developer tab. Click the Properties option in the Controls group.

The Content Control Properties dialog box will open. In the Content Control Properties dialog box, check both options given in the Locking section, i.e., Content Control cannot be deleted and Contents cannot be edited. Click the OK button.

After doing the above steps, whenever you try to edit or delete control fields, you will get an error message in the status bar of the form.

Answer options C, A, and D are incorrect. These are not valid steps to protect the control fields. Reference: ECDL/ICDL Exam Course Manual, Contents: 'Protect control fields'

Chapter: ADVANCED WORD PROCESSING

Objective: Enhancing Productivity