Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Create an Access database for the following scenario: Patients buy prescription drugs from the NHF pharmacy. Data is recorded for the following objects: Patient Field
Create an 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 useTakes Yes or No onl Text, 100 characters Text, 20 characters Text, 2 characters 5- digit number Visit Field Visit ID Data type A unique number Patient's unique 9-digit number Date/Time Patient ID Visit date Insurance company Text, 25 characters Insurance group code Insurance Member code Amount billed Date Insurance paid Date/Time Text, 30 characters Text, 30 characters Currenc Create an 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 useTakes Yes or No onl Text, 100 characters Text, 20 characters Text, 2 characters 5- digit number Visit Field Visit ID Data type A unique number Patient's unique 9-digit number Date/Time Patient ID Visit date Insurance company Text, 25 characters Insurance group code Insurance Member code Amount billed Date Insurance paid Date/Time Text, 30 characters Text, 30 characters Currenc
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started