Create an Access (Microsoft Access) database for the following scenario:

Patients buy prescription drugs from the NHF pharmacy. Data is recorded for the following objects:

Patient Field A unique Data type atient ID Last name First name Date of birth Gender Phone 9-digit number Text, 25 characters Text, 25 characters Date Takes either "F" or "M" Use input mask format as ___) Example:(402)333-4567 Address City State Zip code Tobacco use Text, 100 characters Text, 20 characters Text, 2 characters 5- digit number Takes Yes or No onl Patient Field A unique Data type atient ID Last name First name Date of birth Gender Phone 9-digit number Text, 25 characters Text, 25 characters Date Takes either "F" or "M" Use input mask format as ___) Example:(402)333-4567 Address City State Zip code Tobacco use Text, 100 characters Text, 20 characters Text, 2 characters 5- digit number Takes Yes or No onl