Such fields include social security numbers, identification codes, part numbers, or product serial numbers. It might be necessary to assign a unique number to each record or to allow Access to assign one automatically. Include a common field in related tables. The common field is used to connect one table logically with another table. For example, each student record might include a counselor code that matches the counselor code listed for each counselor in the counselor table.
Data redundancy occurs when the data is stored in more than one place in the database.
Determine the properties of each field. Field properties include field name, field type, maximum number of characters, field description, and validity checks. Properties assigned to the fields determine the types of information that can be retrieved from the database. Creating a table consists of naming fields, assigning field data types and defining properties for the fields, specifying a primary key, and maintaining records. It is best to choose a field name that describes the purpose of the field so that it is easy to remember.