ECDL-ADVANCED Exam Practice Test Instant Access

Question 1

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?

AEntity

BDomain

CData

DReferential
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 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.

Answer : A

Chapter: DATABASE, ADVANCED-LEVEL

Objective: Table Design

Question 2

You work as a Database Designer for ABC Inc. The company has a Windows Vista-based computer with Microsoft Office 2007 installed on it. The computer contains a database named Information in Microsoft Office Access 2007. The database contains a table named Employees with the following fields:

Employee Name

Employee ID

Department

Salary

You want to view a list of fields in the table. In which of the following views will you open the table?

ADesign

BPivot Table

CLayout

DDatasheet
Explanation:
In order to view a list of fields in the table, you must open the table in the Design view.The Design view of a table displays its fields and datatypes. New fields can be added to the table and assigned to a datatype. A user cannot insert data in this view. The datatype of a field can be formatted and other table properties such as field size, validation rule, etc., can be set for the field.

The datatype of the new field is defined by the data inserted in it by a user. The default datatype is text. The datatype can be explicitly assigned to a field through the Datatype list in the Data type and Formatting group on the DataSheet tab.

Answer option C is incorrect. You can use Layout view to make changes in the design while you view data in a form or report
Answer option B is incorrect. The PivotTable view of a table can be used to display the data of a table in the desired format. This view cannot be used to create or delete a field or modify its properties. The data can be filtered according to fields. When the PivotTable view is opened, a blank work area is displayed and the columns of the table are displayed in the Pivot Table Field List window. A user has to drag and drop the fields to view the desired result.

Answer : A

Chapter: DATABASE, ADVANCED-LEVEL

Objective: Table Design

Question 3

In which of the following formats can the date and time be formatted?

Each correct answer represents a complete solution. Choose all that apply.

Amm/dd/yyyy

Bh:m:s

Ch:m

Dmm/dd/yyyy h:m:s
Explanation:
The Format property is used to format the Date/Time datatype. The date and time can be formatted as follows:
General Date: The date is displayed in the format of mm/dd/yyyy h:m:s. For example,
10/19/2011 6:30:45 PM
Long Date: The date is displayed in the following format:
Friday, October 19, 2011
Medium Date: The date is displayed in the following format:
19-Oct-11
Short Date: The date is displayed in the format of mm/dd/yyyy. For example,
10/19/2011
Long Time: The time is displayed in the format of h:m:s. For example,
6:30:45 PM
Medium Time: The time is displayed in the format of h:m. For example,
6:30 PM
Short Time: The time is displayed in the following format:
18:30

Answer : A, B, C, D

Chapter: DATABASE, ADVANCED-LEVEL

Objective: Form Design

Question 4

You have created a PowerPoint presentation but due to some reason, you want to save that presentation in PDF. Which of the following steps will you take to accomplish the task?

AOn the Quick Access toolbar, click the Convert Presentation to PDF option, and select the file type as PDF

BExport the presentation from the Home tab and save the presentation in PDF.

CClick the Convert Presentation to PDF option in the View tab and save PDF

DOn the Quick Access toolbar, click the Save as type drop down menu, and select the file type as PDF
Explanation:
Take the following steps to save a presentation in PDF:
Click the Save As icon in the Quick Access toolbar.

Write the name of file in the File name section, click the Save as type drop down menu, and select the file type as PDF.

Click the Save button.

Answer options C, B, and A are incorrect. These are not valid steps to save a presentation in PDF.
Reference: ECDL/ICDL Exam Course Manual, Contents: 'Save a presentation in PDF'
Chapter: PRESENTATION, ADVANCED - LEVEL
Objective: Slides

Answer : D

Question 5

Jasmine is creating a presentation. When she selects a textbox and starts typing, the existing text is not replaced with what she has typed. Which of the following is the most likely cause of the issue?

AShe selects the border of the text box and starts typing.

BShe selects the text box and delete it.

CShe selects the slide and starts typing.

DShe selects the text of the text box and starts typing.
Explanation:
Whenever she selects the border of a text box, she will not be able to write a text in it.
Answer option D is incorrect. When she selects the text of the text box, she will be able to overwrite the existing text.
Answer option C is incorrect. When she selects the slide, she will be able to apply various formats and animations.
Answer option B is incorrect. When she deletes the text box, the selected text will be automatically deleted.
Chapter: PRESENTATION, ADVANCED - LEVEL
Objective: Design Considerations

Answer : A

Question 6

You work in an office and you are assigned the task of preparing a document. You insert a table in the document and your document has a number of objects. You want to use gridlines for proper alignment between objects. For this, you have to display gridlines of the table. However, clicking the Borders button on the Design tab will not help in displaying the gridlines. Which of the following is the cause of the issue?

AYou are viewing the document in Print Layout view.

BYou are viewing the document in a Web browser.

CYou are viewing the document in Draft view.

DYou are viewing the document marked as final.
Explanation:
Gridlines are used to show cell boundaries of a table on the screen. These gridlines will display where the table does not have borders. They appear only on the screen where they are not printed. The user cannot see the changes wherever the gridlines are behind the borders if you hide the gridlines in a table that has these borders by default. All tables have black 1/2 point, single-line, solid-line borders that are printed. In order to view the gridlines, remove the borders. If the user is viewing a document in the Web browser, gridlines will never be visible.
Answer options C and A are incorrect. You can view gridlines of a table in the Draft and Print Layout views. The Draft view is used to view the document as a draft to allow a user to quickly edit the text. Headers and footers are not visible in this view. The Print Layout view is used to view a document as it would appear on a printed page.
Answer option D is incorrect. The gridlines of a table are not affected by the use of the mark as final feature.
Answer options C and A are incorrect. You can view gridlines of a table in the Draft and Print Layout views. The Draft view is used to view the document as a draft to allow a user to quickly edit the text. Headers and footers are not visible in this view. The Print Layout view is used to view a document as it would appear on a printed page.
Answer option D is incorrect. The gridlines of a table are not affected by the use of the mark as final feature.
Chapter: ADVANCED WORD PROCESSING
Objective: Formatting

Answer : B

Question 7

Which of the following sections are included in the default layout of the Report Design view?

Each correct answer represents a complete solution. Choose all that apply.

APage Header

BGroup Header/Footer

CPage Footer

DDetail
Explanation:
The following sections are included in the default layout of the Report Design view:
Page Header: It is displayed at the top of each page. Page Header includes a logo, column heading, page number, etc.
Detail: It displays the data and their associated labels that are included for the table or query fields added to the report.
Page Footer: It is displayed at the bottom of each page. Page Footer includes a report name, date and time, coding, page number, etc.
Answer option B is incorrect. It is not a valid section included in the default layout of the Report Design view.

Answer : A, C, D

Chapter: DATABASE, ADVANCED-LEVEL

Objective: Report Design

ECDL ADVANCED WORD PROCESSING Exam Practice Test