Home » Microsoft Access » 05 - Tables
5
Creating a Table using the Table Wizard
You can create a table using the table wizard. The wizard has both personal and business sample databases.
To create a table using the Table Wizard:
- In the database window click the tables tab.
- Click the new button on the toolbar.
- Choose Table wizard and click ok.
- Click Business or Personal > Sample Table.
- Choose the list of fields and add the field to your table you have all the fields you need.
- Click next and enter the name of the table.
- Select the option ‘Yes, set a primary key for me’.
- Click next.
- In case you decide to set the primary key, select the field from the drop-down list and then specify how the data are added.
- Click Next
- Click Relationships.
- Select the Relationship.
- A Relationship is created.
14. You can modify the design, start entering the data or enter data using a form that the wizard creates.
15. Click Finish.