Question

what is the relationship between a field and record

Answer 1

In database terminology, a records hold all the information or data about one specific object that has been entered into database. In excel records are normally organized in worksheet.

Answer 2

field is a specific category of a information in a table .in a table fields are usually shown in columns and it has its own field name in the top.and record is a collection of fields of one person, place,or thing in a table. records are arranged in rows.