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

• ##### Q :What does allotropic mean What does

What does allotropic mean what does iron and steel have to do with it?

• ##### Q :Statistics Virtual call centers are

Virtual call centers are staffed by individuals working out of their homes. Most home agents earn \$ 10 to \$15 per hour without benefits versus \$7 to \$9 per hour with benefits at a traditional call center ( Business Week, January 23,2006). Regional Airways is considering employing home agents, but on

• ##### Q :Telemarketing can be made more effectual

In what manner telemarketing can be made more effectual?

• ##### Q :Agencies function of bank give me 20

give me 20 pages about agencies function of bank

• ##### Q :Bronchitis disease what is the

what is the relationship between inflammation and fever (bronchitis disease)?

• ##### Q :Organizational communication "What are

"What are the main implications of the Hawthorne Studies? What were the implications of the study on organizational theory?"

• ##### Q :Different media employ for mass

Write down the different media employ for mass communication?

• ##### Q :Introduction of the term Dependency

Write down a brief introduction of the term ‘Dependency theory’ in mass communication?

• ##### Q :Strain aging based on the dislocation

How we illustrate strain aging based on the dislocation theory?

• ##### Q :Orlando Figes. European Russia AND

THIS IS ONE HOMEWORK I will send you my peer response as soon as they finish it.