Which of the following datatypes cannot be filtered by using common filters? Each correct answer represents a complete solution. Choose two.

Question

Options

• AOLE Object
• BAutoNumber
• CHyperlink
• DCalculated Field

• A
  83% (38)
• B
  11% (5)
• C
  7% (3)

Explanation

The following datatypes cannot be filtered by using common filters: OLE Object: 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. Calculated Field: The Calculated Field datatype is used to store the results of a calculation. The calculation should refer to other fields created in the same table. In order to create the calculation, a user can use the Expression Builder that provides the use of IntelliSense and an easy way to access expression values. Answer: C and B are incorrect. These datatypes can be filtered by using common filters. 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. 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:

No community discussion yet for this question.