ECDL Exam ECDL-ADVANCED Topic 2 Question 70 Discussion

Actual exam question for ECDL's ECDL-ADVANCED exam

Question #: 70
Topic #: 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.

Show Suggested Answer

Suggested Answer: A

Chapter: DATABASE, ADVANCED-LEVEL

Objective: Table Design

by Lizbeth at May 24, 2023, 04:05 PM

Limited Time Offer

25%

Off

Get Premium ECDL-ADVANCED Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!