PrattLast_Associates_MohamedMohamed.accdb

PrattLast_Associates_MohamedMohamed1.accdb

Home >Computer Science homework help >PrattLast_Associates_MohamedMohamed.accdb

IfSuccessful_Status	GA_Status_Icon	SAM_Logo
true
false

ID	FirstName	LastName	AssignmentGUID	UserID
false	Mohamed	Mohamed	{A97B0CD0-65BF-4981-AFAC-701FF87B22AF}	{A97B0CD0-65BF-4981-AFAC-701FF87B22AF}

ID	FirstName	LastName	ProjectName	SubmissionNum	MaxScore	Score	EngineVersion

ID	StepNumber	Description	IfSuccessful	StepScore	StepMaxScore	ErrorText	ActionName	StepActionOrder

Account Number	Account Name	Street	City	State	Postal Code	Amount Paid	Current Due	Account Manager Number
AC001	Avondale Community Bank	256 Main St.	Avondale	IL	60311	¤ 24,752.25	¤ 3,875.25	31
BL235	Bland Corp.	100 Granger Hwy.	Granger	IL	60314	¤ 29,836.65	¤ 2,765.30	35
CA043	Carlton Regional Clinic	589 Central Ave.	Carlton	IL	60313	¤ 30,841.05	¤ 3,074.30	58
CO621	Codder Plastics Co.	421 First Ave.	Bremerton	IN	46003	¤ 27,152.25	¤ 2,875.00	35
EC010	Eco Clothes Inc.	120 Pine St.	Davidson	IN	46010	¤ 19,620.00	¤ 1,875.00	58
HL111	Halko Legal Associates	321 Feathering Rd.	Gleneagle	IL	60319	¤ 25,702.20	¤ 3,016.75	58
JM323	JSP Manufacturing Inc.	1200 Franklin Blvd.	Wells	IN	46007	¤ 19,739.70	¤ 2,095.00	31
KC156	Key Community College System	35 Indiana Ave.	Walker	IN	46004	¤ 10,952.25	¤ 0.00	31
KV089	KAL Veterinary Services	116 Pine St.	Granger	IL	60314	¤ 34,036.50	¤ 580.00	35
LC005	Lancaster County Hospital	215 River St.	Granger	IL	46004	¤ 44,025.60	¤ 3,590.80	58
LI268	Lars-Idsen Inc.	829 Wooster Rd.	Davidson	IN	46010	¤ 0.00	¤ 1,280.75	35
MI345	Midwest Library Consortium	3400 Metro Pkwy.	Bremerton	IN	46003	¤ 21,769.20	¤ 2,890.60	31
ML008	Mums Landscaping Co.	865 Ridge Rd.	Wells	IN	46007	¤ 13,097.10	¤ 2,450.00	35
TP098	TAL Packaging Systems	12 Polk Ave.	Carlton	IL	60313	¤ 22,696.95	¤ 3,480.45	58
TW001	Tri-County Waste Disposal	345 Central Blvd.	Rushton	IL	60321	¤ 15,345.00	¤ 2,875.50	31

Account Manager Number	Last Name	First Name	Street	City	State	Postal Code	Start Date	Salary	Bonus Rate
31	Rivera	Haydee	325 Twiddy St.	Avondale	IL	60311	6/3/13	¤ 48,750.00	0.15
35	Simson	Mark	1476 Hartwell St.	Walker	IN	46004	5/19/14	¤ 40,500.00	0.12
42	Lu	Peter	5624 Murray Ave.	Davidson	IN	46007	8/3/15	¤ 36,750.00	0.09
58	Murowski	Karen	168 Truesdale Dr.	Carlton	IL	60313	11/9/16	¤ 24,000.00	0.08

SELECT DISTINCTROW * FROM Account;

SELECT Account.[Account Number], Account.[Account Name], Account.[Amount Paid], Account.[Current Due], Account.[Account Manager Number] FROM Account;

SELECT Account.[Account Number], Account.[Account Name], Account.[Amount Paid], Account.[Current Due] FROM Account WHERE (((Account.City)=[Enter City]));

SELECT DISTINCT CDbl((Sum(IIf(stepscore=1,1,0))/Sum(IIf(errortext<>'NO SHOW',1,0)))*100) AS Grade, Fix(100/(Sum(IIf(Not ([_GradingReportSteps]![ErrorText]='No Show'),1,0)))) AS GAWeight, 100 Mod (Sum(IIf(Not ([_GradingReportSteps]![ErrorText]='No Show'),1,0))) AS Remainder, Min([ID]) AS MinID, Sum(IIf(Not ([_GradingReportSteps]![ErrorText]='No Show'),1,0)) AS MaxGraded FROM _gradingreportsteps;

SELECT GradingSummaryReportGrade.StudentName, GradingSummaryReportGrade.ProjectName, [_GradingIcons].GA_Status_Icon, [_GradingIcons].SAM_Logo, GradingSummaryReportGrade.SubmissionCt, GradingSummaryReportGrade.Grade, GradingSummaryReportGrade.NoShow, GradingSummaryReportGrade.StepNumber, GradingSummaryReportGrade.Justified, GradingSummaryReportGrade.Step, GradingSummaryReportGrade.Action_CT, GradingSummaryReportGrade.ID, GradingSummaryRounding.GAFlip AS GradedID, IIf([GradingSummaryReportGrade]![ActionName]="NO SHOW","",[GradingSummaryReportGrade]![ActionName]) AS AN, GradingSummaryReportGrade.ActionGrade, GradingSummaryReportGrade.IfSuccessful, (IIf([GradingSummaryReportGrade].[NoShow]=1,0,(IIf([GradingSummary].[MaxGraded]-[GradedID]>=Remainder,[GradingSummary].[GAWeight],([GradingSummary].[GAWeight]+1))))) AS GaStepW, (IIf(GradingSummaryReportGrade.IfSuccessful=0,('0/' & GAStepW),(GAStepW & '/' & GAStepW))) AS GAScore, GradingSummaryReportGrade.Description, [_GradingReportSteps].StepScore, IIf([StepScore]=0 And ([NoShow]=0),[ErrorText],"") AS Feedback, GradingSummaryReportGrade.StepActionOrder, [ActionGrade]*[GaStepW] AS Total_Grade, [_GradingReport].EngineVersion FROM GradingSummary, _GradingReport, ((GradingSummaryReportGrade INNER JOIN GradingSummaryRounding ON GradingSummaryReportGrade.ID = GradingSummaryRounding.ID) INNER JOIN _GradingIcons ON GradingSummaryReportGrade.IfSuccessful = [_GradingIcons].IfSuccessful_Status) INNER JOIN _GradingReportSteps ON GradingSummaryReportGrade.ID = [_GradingReportSteps].ID ORDER BY GradingSummaryReportGrade.ID, GradingSummaryReportGrade.StepActionOrder;

SELECT DISTINCT * FROM [SELECT [_GradingReport].FirstName &' '& [_GradingReport].LastName AS StudentName,'Score is : ' & (select top 1 Cint(Grade) from GradingSummary) & ' out of 100' AS Grade, [_GradingReport].ProjectName, 'Submission # ' & submissionNum AS SubmissionCt, [_GradingReportSteps].[StepNumber] & '. ' & [Description] AS Step, [_GradingReportSteps].StepScore AS AllowPartialGrading, (select count(stepNumber) from [_GradingReportSteps] where ActionName <> 'NO SHOW') AS Action_CT, [_GradingReportSteps].StepNumber, IIf([_GradingReportSteps].IfSuccessful=True And errortext<>'NO SHOW',1,0) AS ActionGrade, (select count(stepNumber) from [_GradingReportSteps] t where t.StepNumber = [_GradingReportSteps].stepnumber AND t.ErrorText<> 'NO SHOW' and t.stepscore=1) & "/" & (select count(stepNumber) from [_GradingReportSteps] t where t.StepNumber = [_GradingReportSteps].stepnumber AND ErrorText<> 'NO SHOW') AS StepGrade, [_GradingReportSteps].ActionName, IIf([ifsuccessful]=False,[ErrorText],'') AS Feedback, [_GradingReportSteps].IfSuccessful, [_GradingReportSteps].ID, [_GradingReportSteps].StepActionOrder, [_GradingReportSteps].Description, IIf([_GradingReportSteps].[ErrorText]='NO SHOW','. Non-Graded - ','. ') AS [Space], IIf([_GradingReportSteps].[ErrorText]='NO SHOW','Non-Graded - ','') AS Justified, IIf(ErrorText='NO SHOW',1,0) AS NoShow FROM _GradingReport, _GradingReportSteps GROUP BY [_GradingReport].FirstName &' '& [_GradingReport].LastName, [_GradingReport].ProjectName, [_GradingReportSteps].StepScore, [_GradingReportSteps].StepNumber, [_GradingReportSteps].ActionName, [_GradingReportSteps].IfSuccessful, [_GradingReportSteps].ID, [_GradingReportSteps].StepActionOrder, [_GradingReportSteps].Description, [_GradingReport].FirstName, [_GradingReport].SubmissionNum, [_GradingReport].Score, [_GradingReport].MaxScore, [_GradingReportSteps].StepMaxScore, [_GradingReportSteps].ErrorText union all SELECT [_GradingReport].FirstName &' '& [_GradingReport].LastName AS StudentName,'' AS Grade, [_GradingReport].ProjectName, 'Submission # ' & submissionNum AS SubmissionCt, [_GradingReportSteps].[StepNumber] & '. ' & [Description] AS Step, [_GradingReportSteps].StepScore AS AllowPartialGrading, (select count(stepNumber) from [_GradingReportSteps] where errorText <> 'NO SHOW') AS Action_CT, [_GradingReportSteps].StepNumber, IIf([_GradingReportSteps].IfSuccessful=True And errortext<>'NO SHOW',1,0) AS ActionGrade, (select count(stepNumber) from [_GradingReportSteps] t where t.StepNumber = [_GradingReportSteps].stepnumber AND ErrorText<> 'NO SHOW & stepscore=1') & "/" & (select count(stepNumber) from [_GradingReportSteps] t where t.StepNumber = [_GradingReportSteps].stepnumber AND [_GradingReportSteps].StepScore=1 AND ErrorText<> 'NO SHOW') AS StepGrade, [_GradingReportSteps].ActionName, IIf([ifsuccessful]=False,'',[ErrorText]) AS Feedback, [_GradingReportSteps].IfSuccessful, [_GradingReportSteps].ID, [_GradingReportSteps].StepActionOrder, [_GradingReportSteps].Description, IIf([_GradingReportSteps].[ErrorText]='NO SHOW','. Non-Graded - ','. ') AS [Space], IIf([_GradingReportSteps].[ErrorText]='NO SHOW','Non-Graded - ','') AS Justified, IIf(ErrorText='NO SHOW',1,0) AS NoShow FROM _GradingReport, _GradingReportSteps GROUP BY [_GradingReport].FirstName &' '& [_GradingReport].LastName, [_GradingReport].ProjectName, [_GradingReportSteps].StepScore, [_GradingReportSteps].StepNumber, [_GradingReportSteps].ActionName, [_GradingReportSteps].IfSuccessful, [_GradingReportSteps].ID, [_GradingReportSteps].StepActionOrder, [_GradingReportSteps].Description, [_GradingReport].FirstName, [_GradingReport].SubmissionNum, [_GradingReport].Score, [_GradingReport].MaxScore, [_GradingReportSteps].StepMaxScore, [_GradingReportSteps].ErrorText ]. AS a WHERE (((a.grade)<>"")) ORDER BY a.StepNumber, a.StepActionOrder;

SELECT S.ID, IIf(S.[ErrorText]='No Show',0,(S.ID-(SELECT COUNT(M.ID) FROM [_GradingReportSteps] M where M.[ErrorText]='NO SHOW' AND S.ID>M.ID))-[GradingSummary].[MinID]+1) AS GAFlip FROM GradingSummary, _GradingReportSteps AS S INNER JOIN _GradingReportSteps AS M ON S.ID = M.ID;

SELECT Account.[Account Number], Account.[Account Name], Account.[Amount Paid], Account.[Current Due] FROM Account WHERE (((Account.[Account Number])="JM323"));

SELECT Account.[Account Number], Account.[Account Name], Account.[Amount Paid], Account.[Current Due] FROM Account WHERE (((Account.[Account Name]) Like "K*"));

SELECT Account.[Account Number], Account.[Account Name], Account.[Amount Paid], Account.[Current Due] FROM Account WHERE (((Account.[Current Due])=0));

SELECT [Account Manager].[Account Manager Number], [Account Manager].[Last Name], [Account Manager].[First Name], [Account Manager].[Start Date] FROM [Account Manager] WHERE ((([Account Manager].[Start Date])>#1/1/2015#));

SELECT Account.[Account Number], Account.[Account Name], Account.[Amount Paid], Account.[Current Due], Account.[Account Manager Number] FROM Account WHERE (((Account.[Current Due])>2500) AND ((Account.[Account Manager Number])="31"));

SELECT DISTINCT Account.City FROM Account ORDER BY Account.City;

SELECT DISTINCT Account.[Account Number], Account.[Account Name], Account.[Account Manager Number], Account.[Amount Paid] FROM Account ORDER BY Account.[Account Manager Number], Account.[Amount Paid];

SELECT Account.[Account Number], Account.[Account Name], Account.[Amount Paid], Account.[Current Due], [Amount Paid]+[Current Due] AS [Total Amount] FROM Account;

SELECT Avg(Account.[Amount Paid]) AS [AvgOfAmount Paid] FROM Account WHERE (((Account.[Account Manager Number])="31"));

SELECT Account.[Account Manager Number], Avg(Account.[Amount Paid]) AS [AvgOfAmount Paid] FROM Account GROUP BY Account.[Account Manager Number];

SELECT [Account Manager].[Account Manager Number], [Account Manager].[Last Name], [Account Manager].[First Name], Account.[Account Number], Account.[Account Name] FROM [Account Manager] LEFT JOIN Account ON [Account Manager].[Account Manager Number] = Account.[Account Manager Number] ORDER BY [Account Manager].[Account Manager Number], Account.[Account Number];

TRANSFORM Sum(Account.[Current Due]) AS [SumOfCurrent Due] SELECT Account.[State], Sum(Account.[Current Due]) AS [Total Of Current Due] FROM Account GROUP BY Account.[State] PIVOT Account.[Account Manager Number];