Step 1 - Becoming Familiar with Database Terminology While there is an extensive list of terminology associated with database management, only a few of these terms are essential to the beginner. Common Field - A field that appears in both tables. The common field is used to connect tables. Table - A collection or records. Databas e - A collection of related tables.
Access is a relational database.
A database is only useful if it is designed to meet the specific needs of its users. Good database design requires careful planning to determine the fields, tables, and relationships needed to satisfy the data input and output requirements. Consider the type of information to be stored in the database and the type of reports that must be generated from the data. Plan fields that will produce this information. Group related fields into tables.