Free ECDL ECDL-ADVANCED Exam Actual Questions

The questions for ECDL-ADVANCED were last updated On Nov 16, 2024

Question No. 1

Which of the following types of action queries allows a user to add records from one or more tables to the end of one or more other tables?

Show Answer Hide Answer
Correct Answer: A

An action query is used to update multiple records in one operation. It is a form of select query that performs an action on the results of the selection process. There are four types of action queries available in Microsoft Office Access 2007, which are as follows:

1. Delete queries: A delete query allows to delete records from one or more tables.

2. Update queries: An update query allows to modify fields. This is used to update a field with an expression or data from another table.

3. Append queries: An append query allows to add records from one or more tables to the end of one or more other tables.

4. Make-table queries: A make-table query allows to create a new table from all or part of the data in one or more tables.


Chapter: DATABASE, ADVANCED-LEVEL

Objective: Query Design

Question No. 2

Which of the following properties binds the object to a source from which data is to be retrieved?

Show Answer Hide Answer
Correct Answer: A

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

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 No. 3

Which of the following datatypes will you use to store files in a field?

Show Answer Hide Answer
Correct Answer: B

Chapter: DATABASE, ADVANCED-LEVEL

Objective: Table Design

Question No. 4

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?

Show Answer Hide Answer
Correct Answer: A

Question No. 5

Which of the following datatypes generates a consecutive number that can be used as the primary key of a table?

Show Answer Hide Answer
Correct Answer: B

The AutoNumber datatype is used for inserting a number automatically and incrementing it by one when a new record is inserted in a table. The increment can be changed through the New Values property. This property has the following two values:

Increment

Random

The AutoNumber datatype generates a consecutive number that can be used as the primary key of a table. Answer option C is incorrect. The Currency datatype is used to store monetary values. The format of the currency can be changed by using the Format property. The various formats of the Currency datatype are as follows:

* General Number

* Currency

* Euro

* Fixed

* Standard

* Percent

* Scientific

Answer option D is incorrect. The Hyperlink datatype is used to store a hyperlink that is linked to a Web page or to a local or network file. It can store 1GB of data. Any type of file can be linked through this datatype. Each row of a table contains only one hyperlink.

Answer option A is incorrect. The OLE Object datatype is used to attach files and add binary data to a table. This datatype stores each data in a bitmap format. This results in an increase in the size of a database file. Only a single file can be added to each row of a table. The files attached can be Microsoft Office files, graphics files, sound files, pdf files, etc.


Chapter: DATABASE, ADVANCED-LEVEL

Objective: Table Design