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 :Data Communication and Computer Network

Describe Silly window problem. How it can be avoided?

• Q :Introduction of the term Uses and

Write down a brief introduction of the term ‘Uses and gratifications theory’?

• Q :Describe Grapevine communication Write

Write down a brief introduction of the term ‘Grapevine communication’ and also write down its effect on mass communication?

• Q :Functions of mass communication Write

Write down essential functions of mass communication?

• Q :Explanation of Algebraic Attacks Give a

Give a brief explanation of Algebraic Attacks.

• Q :Compositions of brass-melting point of

What are the compositions of brass, how can this metal be heat-treated, what is the melting point of this metal?

• Q :Comunity engagement and education

explain how pre- schools get fully involved in carrying out community activities

• Q :Explanation of Block Cipher Give a

Give a brief explanation of the term Block Cipher.

• Q :Name the liquid in which gold is

Name the liquid in which gold is dissolved.

• Q :IMPACT EVALUATE THE IMPACT OF A RECENT

EVALUATE THE IMPACT OF A RECENT HEALTH CARE INITIATIVE ON NURSING