- Some things are better worked out on paper - design your table on a piece of paper rather than putting it straight into Access
- Choose a name for each field
Use names that will be obvious to you, since as you will see later, these are not the names that you will have to use on reports. The Access naming rules apply when naming fields; words are capitalised and separated by an underscore or hyphen (to avoid the use of spaces). A field containing a customer's address might be Customer_Address or CustomerAddress.
- Choose the data type for each field
The common data types are as follows.
- Test the written out design with some 'worst case' examples
- Decide if any of the fields are not required
