Experts Advice on MS Access Tables

Table is a set data elements organized of rows and columns. It is also a convenient representation of a relation. The following advices may be of help in designing MS Access tables.

Advice 1:
It is very important to have a very simplified and normalized setup of table structure because it really affect the good and comprehensive development of the database project.

Advice 2:
Before you design the table, you need to determine first the related entities of your database. Then, actuate the corresponding fields or unit of information which will comprise your entity.

Advice 3:
Designing of the Table is the most important part in a relational systems database. A good design of the table will effect in a database that hold volume of data and also it will last a longer period of time. There will be less support of your database once it has an efficient and quality design.

Advice 4:
You may have a comprehensive and categorized naming convention of tables as you design them so that you can easily remember and classify your database relationship. You can refer on the figure below, one of the ways on categorizing or grouping your tables.


Advice 5:
Table definition of primary keys is very essential for better normalization of your tables because primary keys will be used for relating to other defined tables as the foreign key. You can design primary keys in suitable with your entity either it is user defined or autocremental. You can refer on the figure below the sample on how to specify primary key on your table.