Using Access for any other suitable database management softwarel, add the HospitalNumber field to the single table database PATIENT Choose text as the data type for this field Include validation checks to ensure that 8 characters must be entered starting with HN followed by 6 digits for example HN123456 Choose suitable data to store in each primary key field for the 6 patients in the table

Question

Using Access for any other suitable database management softwarel, add the HospitalNumber field to the single table database PATIENT     Choose   text   as the data type for this field     Include validation checks to ensure that 8 characters must be entered starting with HN followed by 6 digits for example HN123456     Choose suitable data to store in each primary key field for the 6 patients in the table

SolutionInn · Accepted Answer

The Answer is in the image, click to view ...

Question: Using Access for any other suitable database management softwarel, add the HospitalNumber field to the single table database PATIENT. >> Choose text as the data

Step by Step Solution