A record is one complete set of information in a database.
A field is the name for the different categories, or column headings, in a database.
FName | LName |
---|---|
John | Smith |
Jane | Smith |
In the table above, there are two fields and two records.
The fields are "FName" and "LName", which stand for "First Name" and "Last Name"
The records are "John Smith" and "Jane Smith"