Read following instruction and check attached files. For activity 3, using the three spreadsheets attached here,:
1. Upload these into a new database called Curtin Hospital 2006_07 and in design view of each table, ensure the field properties are correct
2. Create a query using the Curtin Patient Data 06_07 table and call it qryLength_of_Stay. In this query show the UMRN, AdmNumber, AdmisDate, DischDate. Create a new column called LOS. In this column, subtract the AdmisDate from the DischDate to obtain the length of stay
3. Create a query using the Curtin Patient Data 06_07 table and the Financial Data 06_07 table and call the query Top_5%_Doctors. Produce a query which shows the top 5% doctors in terms of total revenue generated
4. Create a query using the Curtin Patient Data 06_07 table and the Financial Data 06_07 table and call the query Ward_26_Female_Sameday_HBF_Cases. Produce a query that identifies the UMRN for all female patients who were admitted to ward 26 for a same day case who billed HBF 5. Expanding on the above query, remove the UMRN field and add the TotalChg field from the Financial Data 06_07 table. Save the query as Ward_26_Female_Sameday_HBF_Charges. Identify the total charges generated for this ward for female same day HBF cases
Attachment:- 1980_1Activity3ExpectedResults.docx
Attachment:- curtin patient data 06_07.xlsx
Attachment:- financial_data_06_07.xlsx
Attachment:- list_of_doctors.xlsx