What Is The Definition Of A Table In A Database?

In a database such as Access, a table is a collection of records with the same fields.

A field is an individual piece of information, like a first name, last name or phone number, about an item or person, or it is the space in which such information is stored (you can also have a blank field.)

A record is the complete set of information (consisting of several fields) relating to one item or person.

A table may contain a list of records of, for example, your customers. A database can consist of just one table, but in fact it usually has far more. A computerised database like Access can hold thousands of tables.

Add Comment

Report