Can anyone please help me with this project ( step by step) . Thank you

You arrive at Secure Systems, Inc., for a database administrator position interview. After meeting the Human Resources coordinator, you are given a test to demonstrate your skills in Access. You are asked to create a database from scratch to keep track of all the candidates for the positions currently open at Secure Systems. (We assume that a given candidate can be interviewed for one job opening/position only, and for a given job opening/position many candidates can be interviewed.)

Use these requirements using Microsoft Access:

Create and Name the database DP_ITE120_YourLastnameFirstname.

b.Create two tables: Candidates, and JobOpenings. Create the fields for each table using the suggested fields below. Populate the tables with records indicated in e and f below.

Include a field to rank each candidate on a scale of 1 to 5 (5 is highest).

Set the table relationship between Candidates and JobOpenings. Enforce the referential integrity.

Add 10 candidates yourself and 9 other students in your class in the Candidates table.

Add the Database Administrator job and four (4) other sample jobs in the JobOpenings table.

Create a query that lists all the database Administrator interviews with a ranking of 4 or 5. Add the last name and first name of the candidate to the query design. Run and save the query. Choose a name for the query.

Suggested fields for the Candidates table:

Candidate ID (to be used as primary key)

First Name

Middle Name

Last Name

Address

Zip code

State

Gender

Ranking

Highest degree

Field of study

Job Number (to be used as foreign key)

Suggested fields for the JobOpenings table:

Job Number (to be sued as primary key)

Title

Description

Yearly Wage

Starting date