Question

difference between text and numeric type field

Answer 1

This is true in any database (Access, Oracle). A number field is technically called a "NUMERIC" field. Only numbers can be inserted into a field that has this designator. A text field is for characters or numbers. It can be a "CHAR" (character), a VARCHAR (characters or numbers). It's basically a way of putting rules on columns--what type of data belongs there.

Answer 2

the field which have text/letters are called text fields
the fields which have numbers are called numeric fields