MENU

Chapter 4 Microsoft Access Solutions

Question - 21 : - Write one example of each field, for which you would use 
  1. Text data type
  2. Memo data type

Answer - 21 : -

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.

Question - 22 : - Distinguish between Number and AutoNumber data type field. Give example of each.

Answer - 22 : - Distinguishing between Number and AutoNumber data

Number

AutoNumber

It holds numeric values which are used for calculations.

It allows to store numbers that are automatically generated for each record.

The field length of this data type is 1,2, 4, 8 or 16 bytes.

The field length of this data type is 4 bytes.

It does not support field property New values.

It supports the field property New values.

e.g. in a table Employee, Salary is a Number type field.

e.g. in a table Bank, the AccountNo is a AutoNumber field as, for every new customer, this field will automatically increase and will provide a new number.

Free - Previous Years Question Papers
Any questions? Ask us!
NodeJS Interview Questions Answers
ASP.Net Interview Questions Answers
Interview Questions Answers
×