Reference no: EM13300602

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