Which of the following datatypes is used for inserting a number automatically and incrementing it by one when a new record is inserted in a table?
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:
Answer B is incorrect. The Memo datatype stores alphanumeric values. These values can be numbers, alphabets, special characters such as <, >, ?, etc. This datatype is used in place of the Text datatype. It can store 65,535 characters. It also accepts text with rich text format, paragraphs, descriptions, etc.
Answer 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.
Answer D is incorrect. The Yes/No datatype is a Boolean datatype that is used to specify whether a condition is true or false. A record can be retrieved based on any given condition. A user can use the WHERE clause to retrieve the data for those records that have been set to yes or no.
Currently there are no comments in this discussion, be the first to comment!