Need Help with converting Excel data to Access

Create a Microsoft Access database for the Doc-n-the-Box pharmacy.

Create the table(s), field(s), data type(s), primary key(s), etc. for the database and populate it with the data provided in the Excel file.

Create the relationship(s) between/among the tables, as appropriate

Query 1 Create an alphabetized list of the male patients who have used the Doc-n-the-Box. Your output should include the Last Name, First Name, Patient ID#, Phone, Date of Birth,

and allergies, if any.

Query 2 Create a list of patients and the drug(s) that has/have been prescribed for them. Your output should include the Patients Last Name, Patients First Name, Patient ID #, Drug Name, UPN, Instructions, Number of Refills Authorized, and Rx Expiration Date. Sort it by Number of Refills authorized (ascending)

Query 3 Create a list of the Health Plans with a list of individuals for each plan. Your output should include the Health Plan Name, Health Plan ID#, Patient Last Name, Patient First Name, and Patient ID#. This list should be alphabetized by Health Plan Name, and alphabetized by Patient Last Name within each Health Plan category.

Patient ID	First Name	Last Name	Phone	Date of Birth	Gender	Health Plan	Allergies
19	Dusty	Springfield	(435) 693-1212	4/5/1990	F	H0971	Codeine derivatives, merperidine
10	Jonathan	Cardenas	(928) 551-5547	8/22/1994	M	H1695	Peanuts
23	Jennifer	Holiday	(928) 888-3545	11/21/1989	F	H1205
18	Anders	Kroll	(505) 499-6541	9/11/1994	M	H10119	Penicillin
14	Mary	Ambrose	(435) 444-1233	4/15/1990	F	H10119	Shellfish
15	Gina	Mercado	(970) 514-3212	6/17/1989	F	H0971	Morphine
4	Steven	Nuggent	(435) 122-4545	10/12/1986	M	H1941	Penicillin
11	Paula	Hargus	(505) 744-1889	6/11/1990	F	H1205
22	Jose	Hargus	(505) 498-6478	6/30/1987	M	H1695	Morphine, morphine derivatives
24	Kimberley	Smith	(928) 647-2477	1/16/1989	F	H10119
20	Kevin	Bacon	(435) 477-8989	6/22/1990	M	H1941
21	Cesar	Romero	(970) 631-2222	1/14/1987	M	H3410	Peanuts
1	Ted	Williams	(970) 644-1214	12/11/1994	M	H0971	Pine Tar
17	Maria	Gabel	(970) 223-4157	8/12/1990	F	H1205	Penicillin
8	Sonia	Cardenas	(928) 551-5547	4/12/1988	F	H3410	Penicillin, cephalosporins
25	Anton	Scallia	(515) 246-4579	6/22/1984	M	H4567	Heart Medication
26	John	Hopkins	(202) 456-7891	6/13/1992	M	H4567	Chicken
27	Amy	Wolf	(212) 789-1456	9/13/1992	F	H9785	Codeine derivatives, merperidine
28	Diane	Keaton	(456) 789-1456	12/12/1990	F	H4567