Working with a database

Tables organize your data. All databases in Access contain at least one table. Tables store data, so they're essential building blocks of any database.

A database should have a separate table for every major subject, such as employee records, customer orders, shipping methods, or suppliers.

Each table contains rows called records and columns called fields;

• A record is a collection of facts about a particular person, event, CD, or other item of interest.
• A field is a single kind of fact that may apply to each person, event, or other record