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:

  1. In the database window click the tables tab.

  1. Click the new button on the toolbar.

  1. Choose Table wizard and click ok.
  2. Click Business or Personal > Sample Table.
  3. Choose the list of fields and add the field to your table you have all the fields you need.

  1. Click next and enter the name of the table.
  2. Select the option ‘Yes, set a primary key for me’.
  3. Click next.

  1. 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.

  1. Click Next
  2. Click Relationships.

  1. Select the Relationship.

  1. 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.