ECDL ecdl-advanced practice test

Question 1

You work as a Database Designer for Tech Perfect Inc. The company has a Windows Vista-based
computer with Microsoft Office 2010 installed on it. The computer has a database named Exam
Datasheet created in Microsoft Office Access 2010. You want to import a table named Students which
271/274
Questions & Answers PDF
P-
is created in another database named Info. Choose and re-order the steps that you will take to
accomplish the task.

Answer:

Click the External Data tab.

Click the Import Access Database button.

Select the Info database file.

Choose the import option.

Click the OK button.

Choose the Students table.

Click the OK button.

Explanation:
Take the following steps to import a table from a database in Microsoft Office Access 2010:
Click the External Data tab.

Click the Import Access Database button.

Select the database file to import.
Choose the import option and click the OK button.
272/274
Questions & Answers PDF
P-

Select the required tables and click the OK button.

Reference:
http://office.microsoft.com/en-us/access
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Import, Export and Link data
273/274
Questions & Answers PDF
P-
274/274

Question 2

You work as an Office Assistant for Company Inc. You are creating a presentation in which you have
applied the layout and you are using the normal view. Now you have made some changes in the
layout and you want to save it with a name so that it can be used in the future. For this, you have to
switch from the normal view to another view. Mark the view in the following image of the View tab
to rename the layout.

Answer:

Explanation:
When you add placeholders to a layout and if the content in those placeholders changes the purpose
270/274
Questions & Answers PDF
P-
of the layout, you'll want to rename the layout. Take the following steps to rename a layout:
Click on the View tab. In the Master Views group, click Slide Master.

Right-click the layout thumbnail that you want to rename in the pane that contains the slide master
and layout thumbnails.

The Rename Layout dialog box opens. In the Layout name box, enter the new name of the layout,
and then click the Rename button.

On the Slide Master tab, click Close Master View in the Close group.

Chapter: PRESENTATION, ADVANCED - LEVEL
Objective: Slides

Question 3

Which of the following options will you use to make all the changes made to the document visible
inline in the document?
269/274
Questions & Answers PDF
P-

• A. Sort comments
• B. Track Changes
• C. Comment
• D. Balloons

Answer:

D

Explanation:
Balloons are used to display deletions, comments, formatting changes, and the content that has
been moved. By default, balloons are used to display all the changes that are made while reviewing a
document. If you want to see all the changes inline, you can change settings so that tracked changes
and comments display in the desired way.
Answer option C is incorrect. Comment is used to let the creator know what other person thinks of
the document.
Answer option B is incorrect. The Track Changes option is used to view all the changes done by the
reviewer(s).
Answer option A is incorrect. It is not a valid option to make all the changes made to the document
visible inline in the document.
Reference: ECDL/ICDL Exam Course Manual, Contents: "Balloons"
Chapter: ADVANCED WORD PROCESSING
Objective: Collaborative Editing

Question 4

Jasmine creates a presentation. She wants to start another presentation after completing the current
presentation during the slide show. Which of the following will she use to accomplish the task?

• A. Hyperlink
• B. Reuse Slides
• C. Action Buttons
• D. SmartArt

Answer:

A

Explanation:
Hyperlinking is a process to introduce a dynamic textual environment by attaching links to the
Uniform Resource Locator (URL). It is used to link various elements of a slide to another slide. It can
also be used to interconnect excel sheets, word document, or any other presentation. A user can
create a hyperlink to the following:
A slide in the same presentation.
A slide in a different presentation.
An e-mail address.
A page or file on the Web.
A new file.
Answer option B is incorrect. The Reuse Slides feature is used when a user selects a slide from a
presentation and reuses it into another presentation.
Answer option D is incorrect. SmartArt is a visual graphic used to represent the information
effectively and efficiently. It is used to create designer-quality illustrations. A user can increase the
emphasis of information by adding SmartArt. Though a SmartArt graphics audience of a presentation
can understand and recall information better than a text, it is necessary to visualize what type and
layout are best for displaying data, and what a user wants to convey with a SmartArt graphic. A user
can quickly convert slide text to a SmartArt graphic. In addition, a user can add animation to a
SmartArt graphic in Office PowerPoint 2010 presentations.
Answer option C is incorrect. The action buttons are the predefined buttons that are used to traverse
quickly and efficiently in a presentation. They are used for defining hyperlinked objects. The
hyperlinked objects can be a Web page, a file, or a network location. The action buttons are mostly
used for self-executing presentations.
Chapter: PRESENTATION, ADVANCED - LEVEL
Objective: Multimedia

Question 5

James works as a Database Designer for AccessSoft Inc. The company has a Windows Vista-based
computer with Microsoft Office 2007 installed on it. The company uses Microsoft Office Access 2007
database named Sales. He has to link a text file to the Access database. He clicks the office button
and opens the text file. The file is displayed in the Link Text Wizard. What will happen when James
clicks the Finish button in the wizard?

• A. Data of the text file is appended to an existing table and gets affected if there is a change of data in the text file.
• B. The data is copied into a new table and is not affected if there is a change of data in the text file.
• C. A new database will be created and a linked table will be created in the database.
• D. A linked table will be created in an existing database.

Answer:

C

Explanation:
When James opens a text file in Microsoft Access, a new database is created and a linked table is
268/274
Questions & Answers PDF
P-
created in the new database after the Finish button is clicked in the wizard. The database is created
with the same name as that of the text file. The wizard provides an option of renaming the table. The
default name of the table is same as that of the text file.
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Import, Export and Link data

Question 6

Which of the following are the ways to create a new blank presentation?
Each correct answer represents a complete solution. Choose all that apply.

• A. Click New Slide in the Home tab and then select the Blank presentation option.
• B. Right-click on the current presentation slide and click the New Slide option.
• C. Press Ctrl+M to insert a new blank presentation.
• D. Right-click on the first slide and click the New Slide option.

Answer:

A, D C

Explanation:
Following are the ways to create a blank presentation:
Click New Slide in the Home tab and then select the Blank presentation option.
266/274
Questions & Answers PDF
P-

Right-click on the first slide and click the New Slide option.
267/274
Questions & Answers PDF
P-

Press Ctrl+M to insert a new blank presentation.
Answer option B is incorrect. It is not a correct way to create a new blank presentation.
Reference: ECDL/ICDL Exam Course Manual, Contents: "New blank presentation"
Chapter: PRESENTATION, ADVANCED - LEVEL
Objective: Slides

Question 7

Which of the following are the types of action queries?
Each correct answer represents a complete solution. Choose all that apply.

• A. Update
• B. Delete
• C. Insert
• D. Append

Answer:

B, A, and D

Explanation:
An action query is used to update multiple records in one operation.
Following are the four types of action queries:
Delete queries: A delete query is used to delete records from one or more tables.
Update queries: An update query is used to modify fields. It is used to update a field with an
expression or data from another table.
Append queries: An append query is used to add records from one or more tables to the end of one
265/274
Questions & Answers PDF
P-
or more other tables.
Make-table queries: A make-table query is used to create a new table from all or part of the data in
one or more tables.
Answer option C is incorrect. It is not a valid type of action query.
Reference: ECDL/ICDL Exam Course Manual, Contents: "Action query"
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Table Design

Question 8

Which of the following properties binds the forms and reports to a source from which data is to be
264/274
Questions & Answers PDF
P-
retrieved?

• A. ControlSource
• B. RowSource
• C. RecordSource
• D. Can Grow

Answer:

C

Explanation:
The RecordSource property belongs to the form and report objects. This property binds the object to
a source from which data is to be retrieved. This source can be a table or a query. When a form or a
report is bound to a table or a query, the controls can be bound to a column of the table through the
ControlSource property.
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 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 B is incorrect. The RowSource property belongs to the combo box and list box
controls. When these controls are bound to a column by the RowSource property, all the data of the
column is displayed in the list box or the combo box.
Reference:
http://office.microsoft.com/en-us/access
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Query Design

Question 9

You work as a Database Designer for Tech Perfect Inc. The company has a Windows Vista-based
computer with Microsoft Office 2010 installed on it. The computer has two tables named Customers
and Details created in Microsoft Access 2010. You need to retrieve some selected information of
customers for each state in which your company does business. Which of the following types of
query will you create to accomplish the task?

• A. Parameter query
• B. Crosstab query
• C. Select query
• D. Action query

Answer:

A

Explanation:
To accomplish the task, you will create a parameter query.
The different types of queries in Microsoft Access 2010 are as follows:
Select query: It retrieves and displays records in the Table window in Datasheet view.
Crosstab query: It calculates and restructures data for easier analysis.
Action query: It performs operations on the records that match specified criteria.
Parameter query: It allows a user to prompt for a specific information to use as selection criteria in
the query.
Reference:
http://office.microsoft.com/en-us/access
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Query Design

Question 10

You have created a database named Addresses by using Microsoft Access 2010. You want to maintain
the uniqueness of rows in the table. Which of the following integrities will you use to accomplish this
task?

• A. Entity
• B. Domain
• C. Data
• D. Referential

Answer:

A

Explanation:
Entity integrity enforces the uniqueness of rows in a table. The uniqueness of rows can be enforced
by the identifier column(s) through indexes, UNIQUE constraints, PRIMARY KEY constraints, or
IDENTITY properties.
Answer option D is incorrect. Referential integrity means that the foreign key in any referencing table
must always refer to a valid row in the referenced table. Referential integrity ensures that the
263/274
Questions & Answers PDF
P-
relationship between two tables remains synchronized during updates and deletes. For a foreign key
to be valid, it must contain either the value NULL, or an existing key value from the primary or unique
key columns referenced by the foreign key. To enforce referential integrity, a foreign key column link
to the primary key column should be created in the related table.
Answer option C is incorrect. Data integrity is a mechanism that ensures that the data is not modified
during transmission from source to destination. This means that the data received at the destination
should be identical as that sent from the source. In order to maintain data integrity, the data values
must be within a defined range and in the correct format. For example, the value of an employee's
age must be within the range of 20-60 years, which means that the age cannot be below 20 years
and more than 60 years.
Answer option B is incorrect. Domain integrity enforces data validity by restricting the data type,
valid values (using CHECK constraints and rules), and range of possible values (using FOREIGN KEY
constraints) for columns in a table.
Reference: ECDL/ICDL Exam Course Manual, Contents: "Entity integrity"
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Table Design