DATA ANALYSIS

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

   Related Questions in Other Subject