Write one example of each field, for which you would use1. Text data t

1.	Write one example of each field, for which you would use1. Text data type2. Memo data type
Answer» 1. Text data type It allows to store text or combination of text and numbers as well as numbers that don’t require calculations such as phone number. This data type allows maximum 255 characters to store. e.g. if Employee is a table and Emp_No, Name and Description are fields, then name will be a Text field. Because, name is a character entry field. 2. Memo data type It allows long blocks of text that uses text formatting, e.g. in the Employee table, the field Description will be of Memo data type, because the length of description of employee may be large.

Write one example of each field, for which you would use1. Text data type2. Memo data type

Answer»

1. Text data type It allows to store text or combination of text and numbers as well as numbers that don’t require calculations such as phone number. This data type allows maximum 255 characters to store.

e.g. if Employee is a table and Emp_No, Name and Description are fields, then name will be a Text field. Because, name is a character entry field.

2. Memo data type It allows long blocks of text that uses text formatting, e.g. in the Employee table, the field Description will be of Memo data type, because the length of description of employee may be large.

Discussion

No Comment Found

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