MS Access Assignment

MS Access Assignment - MS Access Assignment Query 1 Unpaid...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
MS Access Assignment Query 1) Unpaid Payroll 1281 SQL: SELECT [Total Wages Due]![Total Wage]-[Paid Payroll 9/16/10]![Paid Wages] AS [Unpaid Payroll] FROM [Paid Payroll 9/16/10], [Total Wages Due]; Total Wage 2174.5 SQL: SELECT Sum([Timesheets]![Hours Worked]*[Employee]![Hourly Wage]) AS [Total Wage] FROM Employee INNER JOIN Timesheets ON Employee.[Employee #]=Timesheets. [Employee #]; Paid Wages 893.5 SQL: SELECT Sum([Employee]![Hourly Wage]*[Timesheets]![Hours Worked]) AS [Paid Wages] FROM (Employee INNER JOIN [Payroll Disbursements] ON Employee.[Employee #] = [Payroll Disbursements].[Employee #]) INNER JOIN Timesheets ON ([Payroll Disbursements].[Timesheet #] = Timesheets.[Timesheet #]) AND (Employee.[Employee #] = Timesheets.[Employee #]); Query 2) Customer Name Amount Owed Fred Kristi 278 SQL : SELECT Customer.[Customer Name], Sum([Sales Order Detail]![Quantity Sold]*[Sales Order Detail]![Sales Price]) AS [Amount Owed] FROM (Customer INNER JOIN [Sales Order] ON Customer.[Customer #] = [Sales Order].[Customer #]) INNER JOIN [Sales Order Detail] ON [Sales Order].[Sales Order #] = [Sales Order Detail].[Sales Order #] GROUP BY Customer.[Customer Name] HAVING (((Customer.[Customer Name])="Fred Kristi"));
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Query 3) Cost of Goods Sold 245 SQL: SELECT Sum([Item Prices].[Price]*[Sales Order Detail].[Quantity Sold]) AS [Cost of Goods Sold] FROM [Item Prices] INNER JOIN [Sales Order Detail] ON [Item Prices].[Item #] = [Sales Order Detail].[Item #]; Item # Price 1 15 2 25 3 15 4 10 5 15 6 25 7 15 8 15 SQL: SELECT [Purchase Order Detail].[Item #], [Purchase Order Detail].Price FROM [Purchase Order Detail]
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 11/15/2011 for the course ACC 343 taught by Professor Ames during the Spring '08 term at Miami University.

Page1 / 6

MS Access Assignment - MS Access Assignment Query 1 Unpaid...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online