In which of the following views will you open the table?

You work as a Database Designer for Company Inc. The company uses Microsoft Access 2010 for creating and managing databases. You have created a database named Detail.

The database consists of 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?
A . Datasheet
B . Design
C . Pivot Table
D . Layout

View Answer

Answer: B

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.

Answer option A is incorrect. A DataSheet view is a type of view in which a table is displayed with its fields and data. A user can double-click on the caption and rename a field or create a new 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 D is incorrect. You can use the Layout view to make changes in the design while viewing data in a form or report.

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

Reference: ECDL/ICDL Exam Course Manual, Contents: "Design"

Chapter: DATABASE, ADVANCED-LEVEL

Objective: Table Design