Creating Tables in Design View

1. Click New on the database toolbar.
2. Click Blank database.

3. Specify the name and click create.
4. A blank database opens.
5. Create database objects like tables, forms etc.

6. Select design view.
7. Enter the fields and the data types for the employee table.

8. Save the employee table as tb:employee

9. Similarly type in the fields for the job table.
10. Set the job code data type to Auto number and make it the primary key.
11. Save as tb:job

12. For the Contact and skills table there will be no primary key.However, the social security number will be indexed with no duplicates.
13. Save the tables as tb:contact and tb:skills.