Access problems

profilehgao1023
recycle_database_start_file.accdb
Home>Computer Science homework help>Access problems
ID FirstName LastName ProjectName SubmissionNum MaxScore Score
ID StepNumber Description IfSuccessful StepScore StepMaxScore ErrorText ActionName StepActionOrder
AwardName
1000 pound level
2000 pound level
3000 pound level
CenterNo CenterName CenterStreet CenterCity CenterState CenterZip CenterPhone ContactFirst ContactLast Hazardous
1 Escambia County Landfill 13009 Bumper Road Pensacola FL 32520 5551236666 Wilson Barry true
2 Rolling Hills Trash 6990 Rolling Hills Road West Pensacola FL 32525 5552227897 Lumon Valentino true
3 Advanced Disposal Service 12444 Murlen Drive West Pensacola FL 32525 5557809999 Grover May false
4 Perdido Landfill 78900 180th Street Pensacola FL 32520 5551111234 Candy Robertson false
ClubNo ClubName ClubStreet ClubCity ClubState ClubZip ClubPhone FName LName
1 Access Users Group 111 Elm Street Pensacola FL 32520 5551238888 Arlene Millen
2 Boy Scouts Troop 6 22 West 67th Street Pensacola FL 32520 5551117777 Jordan Mahring
3 Great Plains 4-H Club 44 East 99th Street Ferry Pass FL 32514 5552222222 Yaneth Smith
4 Lions of Bellview 777 Oxford Street Bellview FL 34421 5553333111 John Harmon
5 Junior League 3333 Princeton Lane Warrington FL 32507 5552134333 Earl Hutchison
6 Girl Scouts Troop 12 55 Oak Road Milton FL 32570 5551224444 Brittany Langguth
7 Oak Hill Liberty 888 Switzer Drive Pace FL 32571 5551239999 Amanda Wang
DepositNo DepositDate Weight CenterNo ClubNo
1 1/4/14 60.0 1 2
2 1/6/14 90.0 2 7
3 2/14/14 50.0 3 7
4 2/18/14 30.0 2 2
5 2/21/14 50.0 4 6
6 2/22/14 100.0 3 6
7 2/28/14 125.0 2 4
8 3/16/14 60.0 1 2
9 4/4/14 115.0 1 4
10 4/19/14 105.0 1 2
11 5/19/14 90.0 2 2
12 5/20/14 80.0 3 1
13 5/21/14 50.0 4 1
14 6/1/14 60.0 4 6
15 6/2/14 65.0 3 4
16 6/8/14 75.0 3 5
17 6/9/14 95.0 2 2
18 6/10/14 90.0 2 1
19 7/11/14 85.0 1 2
20 7/12/14 95.0 1 4
21 7/17/14 65.0 4 6
22 7/18/14 85.0 3 4
23 7/20/14 45.0 2 5
24 8/20/14 205.0 1 7
25 8/21/14 105.0 2 1
26 9/19/14 30.0 3 2
27 10/20/14 60.0 4 4
28 10/21/14 40.0 3 4
29 10/31/14 90.0 2 4
30 11/1/14 80.0 1 1
31 11/2/14 25.0 2 4
32 11/3/14 100.0 4 2
33 11/17/14 85.0 4 5
34 11/18/14 75.0 3 5
35 11/19/14 85.0 3 6
36 11/30/14 90.0 3 5
37 12/2/14 80.0 2 6
38 12/4/14 70.0 2 7
39 12/7/14 80.0 1 7
40 12/9/14 50.0 4 6
41 1/30/15 60.0 1 1
42 1/30/15 100.0 2 6
43 2/4/15 80.0 1 4
44 2/4/15 75.0 4 4
45 2/8/15 150.0 2 5
46 2/13/15 185.0 2 6
47 2/14/15 50.0 4 1
48 2/16/15 35.0 1 7
49 2/17/15 40.0 3 1
50 2/18/15 185.0 4 6
51 2/20/15 200.0 3 2
52 2/22/15 75.0 4 5
53 2/23/15 80.0 1 4
54 2/26/15 65.0 2 4
55 3/2/15 150.0 1 5
56 3/3/15 50.0 3 4
57 3/4/15 45.0 3 7
58 3/5/15 75.0 4 5
59 3/6/15 200.0 1 1
60 3/7/15 145.0 4 6
61 4/19/15 115.0 4 6
62 4/20/15 65.0 4 1
63 4/22/15 105.0 2 1
64 4/23/15 90.0 4 2
65 4/25/15 65.0 1 1
66 4/30/15 205.0 3 2
67 5/1/15 105.0 4 6
68 5/7/15 190.0 3 2
69 6/4/15 90.0 4 4
70 6/7/15 65.0 3 4
71 6/19/15 65.0 1 4
72 6/20/15 85.0 4 5
73 6/22/15 95.0 3 1
74 7/7/15 75.0 3 5
75 7/8/15 200.0 2 1
76 8/31/15 50.0 4 6
77 9/24/15 200.0 2 5
78 10/1/15 90.0 3 5
79 10/2/15 90.0 4 4
80 10/4/15 80.0 2 5
81 1/30/14 60.0 4 1
82 1/30/14 100.0 4 1
83 2/4/14 80.0 1 4
84 2/4/14 75.0 2 4
85 2/8/14 150.0 2 5
86 2/13/14 200.0 2 6
87 2/14/14 50.0 2 1
88 2/16/14 50.0 1 7
89 2/17/14 40.0 3 1
90 2/18/14 100.0 4 7
91 2/20/14 200.0 4 2
92 2/22/14 75.0 4 6
93 2/23/14 80.0 1 4
94 2/26/14 100.0 4 6
95 3/2/14 150.0 2 5
96 3/3/14 70.0 4 4
97 3/4/14 100.0 3 7
98 3/5/14 150.0 3 5
99 3/6/14 200.0 4 1
100 3/7/14 50.0 2 6
SELECT [FirstName] & " " & [LastName] AS StudentName, [_GradingReport].ProjectName, "Submission #" & [SubmissionNum] AS SubmissionCt, "Score is " & [Score] & " out of " & [MaxScore] AS Grade, [_GradingReportSteps].[StepNumber] & ". " & [Description] AS Step, GradingSummaryReportGrade.AllowPartialGrading, GradingSummaryReportGrade.Action_CT, GradingSummaryReportGrade.ActionCorrect, roundScore([AllowPartialGrading],[GradingSummaryReportGrade].[StepMaxScore],[ActionCorrect],[Action_CT]) & "/" & [GradingSummaryReportGrade].[StepMaxScore] AS StepGrade, [_GradingReportSteps].ActionName, IIf([ifsuccessful]=True,Null,[ErrorText]) AS Feedback, [_GradingReportSteps].IfSuccessful, [_GradingReportSteps].StepNumber, [_GradingReportSteps].StepActionOrder, [_GradingReportSteps].ID, [_GradingReportSteps].Description FROM _GradingReport, _GradingReportSteps INNER JOIN GradingSummaryReportGrade ON [_GradingReportSteps].StepNumber = GradingSummaryReportGrade.StepNumber;
SELECT [_GradingReportSteps].StepNumber, [_GradingReportSteps].StepScore AS AllowPartialGrading, [_GradingReportSteps].StepMaxScore, Count([_GradingReportSteps].ID) AS Action_CT, Sum(IIf([IfSuccessful]=-1,1,0)) AS ActionCorrect, Sum(IIf([IfSuccessful]=0,1,0)) AS ActionWrong FROM _GradingReportSteps GROUP BY [_GradingReportSteps].StepNumber, [_GradingReportSteps].StepScore, [_GradingReportSteps].StepMaxScore;