I am trying to figure out how to correctly set up relational tables in Microsoft access and also click on "enforce referential integrity", but whatever I'm doing is incorrect. I need help in Access 2010 please. This is my question:

The BusyB Company wants to store data about its employee skills. Each employee may possess one or more specific skills, and several employees may have the same skill. Include the following facts in the database:

date hired

date of birth

date skill acquired

employee name

employee number

pay rate

skill name

skill number

supervisor

a. Design a set of relational tables to store these data.

b. Identify the primary key for each table, and identify any needed foreign keys.

c. Implement your schema using any relational DBMS. Specify primary and foreign keys, and enforce referential integrity. Demonstrate the soundness of your design by entering sample data in each table.

I found the answer here, but it was utterly unhelpful. I need specific guidance.

Thank you,

Alisa Marie Amlie