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.

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