Related InterviewSolutions

• When Memo data type is preferred over Text type for a field?
• What data type should you choose for a zipcode field in a table?(a) Text (b) Number (c) Memo (d) All of these
• Write one example of each field, for which you would use1. Text data type2. Memo data type
• Which field properties are used in Office Access 2007? Give the purpose of each field property.
• Give any one difference between freezing a field and hiding a field.
• What is a primary key? How do we set a primary key?
• What is Fixed Field Length?
• Write one example of data field for which you would set the Required property to Yes?
• What is the purpose of Default Value field property?
• The default data type for a field is(a) Number(b) AutoNumber(c) Currency(d) Text