Question

By default all the fields will have ------data type
a) other[OTHER]
b) float[FLOAT]
c) Text[VARCHAR]
d)Real[REAL]

Answer 1

c) Text[VARCHAR] is the answer

Answer 2

By default all the fields will have c) Text[VARCHAR] data type.

Explanation:

• Consider the data type of a field as a collection of characteristics that apply to all of the values in the field. Values recorded in a Text field, for example, can only contain letters, numbers, and a restricted range of punctuation characters, and a Text field can only have 255 characters.

• In a Text field, Microsoft Access just saves the characters input in the field; it does not save space characters for unused locations. Set the FieldSize property to limit the amount of characters that may be input.

• The TEXT data type is used to store any text data. It can contain single-byte and multibyte characters that are supported by the locale.