Question

II)Identify the valid and invalid field names by giving reasons:
1.Name
2.Father's name
3.Date of birth
4.Admission No.
5.Blood Group
6.Postal Address
7.Contact No.
8.E-mail ID​

Answer 1

Answer:

valid--->1.,3.,5.,6.

invalid--->2.,4.,7.,8.

Answer 2

Answer:

•Name — Invalid because 'name' is a keyword in MS Access.

•Father's name — Invalid because it has a special character in it.

•Date of birth — Valid because it has no special character in it.

•Admission No. — Invalid because it has a special character (.) in it.

•Blood Group — Valid because it has no special character in it.

•Postal Address — Valid because it has no special character in it.

•Contact No. — Invalid because it has a special character (.) in it.

•E-mail ID — Invalid because it has a special character (-) in it.