You can design a database table using Table Wizard. This is a quick and easy way of creating a table based on standard table and field designs. These are meant to reflect the requirements of the average database user and should be adequate for most purposes. To use the Table Wizard follow these steps:
Right-click your mouse when in the Database Manager window and select New followed by Table.
Click on the Table Wizard button in the "New Table" dialog. The "New Table Wizard" dialog is displayed.
In the Available Tables box the set of standard tables is listed, for example, Customer, Product and Employee. Click on one of these, say Customer, to select it and then click on Next.
The Available Fields box displays the standard fields that come with the table you have selected. For the Customer table these include name and address fields etc. Select the field that you want to be the first in your table and then click on the Add button (the topmost). The selected field is moved from the Available Fields box and placed in the Selected Fields box. Repeat this operation for the rest of the fields that you require.
If you decide that you don't want to use a field after you have moved it to the Selected Fields box, then select the field and click on the Remove button (the second) to return it to the Available Fields box. Likewise, if you want to change the order of fields, you can move selected fields back and forth - including groups of selected fields - by using the Add and Remove buttons. To move all the fields in the Available Fields box over to the Selected Fields box, use the Add All button (the third). The Remove All button (the fourth) moves everything in Selected Fields back to Available Fields.
Once you have chosen all the fields you want, click on Finish. This takes you to the "New Table" dialog, where you can format the fields, create captions and descriptions, define initial values, and even add extra fields that are not available through Table Wizard. See Creating fields in a database.