ECDL Exam ECDL-ADVANCED Topic 8 Question 60 Discussion

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