SOLVED QUESTIONS-DM

Q1.

  1. What is the field size property of an AutoNumber datatypes in MS Access?
  2. Give the difference between MEMO and TEXT type field used in MS Access.
  3.  What is the caption property for a field in MS Access? What caption is assigned by default?
  4.  Explain the validation text and validation rule properties for a text type field.
  5. Name two data types in which field property allow zero length is available in MS Access.

Q2. Give an example of the Memo datatype.

Q3.

  1. What happens when you enter numbers in a Text data type field?
  2.  When is the Memo data type preferred over the Text data type for a field?

Q4.

  1.  Name two possible primary key fields for an Employee table.
  2. How do the Text and Memo field types differ from each other? Explain with the help of an example.