Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Information System

Authors: James A. Hall

7th Edition

978-1439078570, 1439078572

More Books

Students also viewed these Accounting questions