A record is a collection of related fields. An Employee record may contain a name field(s), address fields, birthdate field and so on. A file is a collection of related records.
Tables are also called datasheets. Each table in a database holds data about a different, but related, subject. Data is stored in records. A record is composed of fields and contains all the data about one particular person, company, or item in a database.
You can think of a traditional database as an electronic filing system, organized by fields, records, and files. A field is a single piece of information; a record is one complete set of fields; and a file is a collection of records. For example, a telephone book is analogous to a file.
As a guideline, a database field refers to the columns, or data categories, that are used by all entries/rows. ... A database record is, basically, a row that contains unique data in each of the fields. A database will usually contain a large number of records but only a small number of fields.