Which of the following datatypes cannot be filtered by using common filters?
Each correct answer represents a complete solution. Choose two.
A.
OLE Object
B.
AutoNumber
C.
Hyperlink
D.
Calculated Field
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:
Increment
Random