What Is a Record in Microsoft Access?

A record in Microsoft Access refers to a group of fields, such as a telephone number, address and name, which are pertinent to a particular item. Each record within a table holds information about a single entity.

A record is sometimes referred to as a row, while a field is also known as a column. There are several ways to delete, add or edit records in a table using Microsoft Access. Users can directly manipulate records in Datasheet view. A query can be created and designed to edit and view records by simply running the query. Alternatively, a form can also be designed and created based on a database query or table then used to manipulate records.