SC_AC16_1a_Student_1.accdb
| IfSuccessful_Status | GA_Status_Icon | SAM_Logo |
| true | |
|
| false | |
|
| ID | FirstName | LastName | AssignmentGUID | UserID |
| false | Eric | Parker | {F9A44232-4442-4350-A613-33B8F0BEF5CE} | {F9A44232-4442-4350-A613-33B8F0BEF5CE} |
| ID | FirstName | LastName | ProjectName | SubmissionNum | MaxScore | Score | EngineVersion |
| ID | StepNumber | Description | IfSuccessful | StepScore | StepMaxScore | ErrorText | ActionName | StepActionOrder |
| AdRepNumber | FirstName | LastName | PhoneNumber | Address | City | State | PostalCode | Salary |
| AM01 | Abraham | Miller | 503-555-6032 | 54 Quarry Ave. | Portland | OR | 97210 | ¤ 32,540.00 |
| GZ01 | Gregory | Zdalnza | 603-555-8765 | 7 Moose Head Rd. | Boise | ID | 83720 | ¤ 29,675.00 |
| KS02 | Kathryn | Stenhope | 503-555-0003 | 9 Shennadoah Ave. | Salem | OR | 97311 | ¤ 34,576.00 |
| MR01 | Max | Riley | 781-555-2323 | 24 Spring Rd. | Casper | WY | 83114 | ¤ 30,450.00 |
| RH01 | Rowan | Horton | 207-555-9009 | 12 Heather Rd. | Portland | OR | 97211 | ¤ 35,275.00 |
| SL01 | Stephanie | Lorens | 802-555-3339 | 15 River Rd. | Spokane | WA | 99202 | ¤ 37,350.00 |
| UG01 | Ursula | Grea-Mayers | 207-555-8534 | 342 Pine St. | Seattle | WA | 98101 | ¤ 41,765.00 |
| AdvertiserID | AdvertiserName | Address | City | State | PostalCode | AdRepNumber |
| BillboardID | Location | City | State | Height | Width | Illuminated | DEC | Type | Facing |
| LHAR04 | Hwy 395 | Arden | WA | 8 | 24.0 | Yes | 4395 | Digital | North/South |
| LHBE01 | Hwy 97 | Beaver Marsh | OR | 8 | 24.0 | Yes | 3542 | | North/South |
| LHBU01 | Hwy 395 | Burns | OR | 10.5 | 48.0 | Yes | 1509 | | North/South |
| LHCA01 | Hwy 199 | Cave Junction | OR | 6 | 16.0 | No | 2024 | Junior Poster | North/South |
| LHCA03 | Hwy 20-26 | Casper | WY | 10 | 32.0 | No | 1288 | Bulletin | West Only |
| LHCH03 | Hwy 97 | Chemult | OR | 10 | 24.0 | Yes | 3411 | Digital | North/South |
| LHCH05 | Hwy 93 | Challis | ID | 8 | 24.0 | No | 506 | Poster | North/South |
| LHCO05 | Hwy 89 | Cokeville | WY | 10 | 20.0 | No | 506 | Poster | North/South |
| LHDA03 | Hwy 197 | Dallesport | WA | 8 | 20.0 | No | 3700 | Junior Poster | North/South |
| LHDC07 | Hwy 89 | Alpine | WY | 6 | 8.0 | No | 1964 | Junior Poster | North Only |
| LHDD01 | Hwy 26 | Dubois | WY | 8 | 24.0 | Yes | 1016 | Poster | East/West |
| LHGR01 | Hwy 18 | Grand Ronde | OR | 10 | 30.0 | Yes | 5182 | Bulletin | East/West |
| LHGR02 | Hwy 99 | Grants Pass | OR | 10 | 25.0 | Yes | 5838 | Poster | North Only |
| LHKE01 | Hwy 395 | Kettle Falls | WA | 6 | 10.0 | No | 7400 | Junior Poster | North/South |
| LHKL01 | Hwy 97 | Klamath Falls | OR | 10 | 24.0 | Yes | 4461 | Digital | North/South |
| LHMA01 | Hwy 97 | Madras | OR | 8 | 24.0 | Yes | 12070 | Digital | North/South |
| LHMP01 | Hwy 97 | Modoc Point | OR | 8 | 24.0 | Yes | 5500 | Poster | North/South |
| LHPA03 | Hwy 95 | Payette | ID | 12 | 24.0 | No | 3777 | Bulletin | North/South |
| LHRI01 | Hwy 95 | Riggins | ID | 8 | 24.0 | Yes | 1524 | Digital | North/South |
| LHRI02 | Hwy 20 | Rigby | ID | 14 | 48.0 | Yes | 13406 | Bulletin | North/South |
| LHRO01 | Hwy 101 | Rockaway | OR | 5 | 8.0 | No | 1702 | Junior Poster | North/South |
| LHSA01 | Hwy 114 | Salem | OR | 8 | 24.0 | Yes | 10224 | Poster | North/South |
| LHSA03 | Liberty Road | Salem | OR | 9 | 27.0 | Yes | 11808 | Poster | North/South |
| LHSA05 | Hwy 99 | Salem | OR | 8 | 24.0 | Yes | 10224 | Poster | North/South |
| LHTW01 | Hwy 93 | Twin Falls | ID | 6 | 12.0 | No | 1564 | Junior Poster | North/South |
| LHWE01 | Hwy 95 | Weiser | ID | 10.5 | 24.0 | No | 1748 | Poster | North/South |
| LHWE04 | I-90 Exit 60 | Wallace | ID | 14 | 48.0 | Yes | 6888 | Bulletin | East/West |
| LIBO01 | I-84 Exit 57 | Boise | ID | 21 | 47.0 | Yes | 14104 | Bulletin | East/West |
| LIRO01 | I-5 Exit 120 | Roseburg | OR | 12 | 48.0 | Yes | 27618 | Bulletin | North/South |
| LNPO01 | I-84 Exit 1 | Portland | OR | 14 | 48.0 | Yes | 110667 | Bulletin | East/West |
| LSCO05 | Hwy 42 | Coquille | OR | 8 | 25.0 | Yes | 5642 | Digital | East/West |
| LSEU01 | 6th Ave. | Eugene | OR | 10 | 24.0 | Yes | 19942 | Poster | East Only |
| LSEU05 | Maxwell St. | Eugene | OR | 12 | 24.0 | Yes | 5707 | Poster | East/West |
| LSEU07 | W. 11th St. | Eugene | OR | 10 | 24.0 | Yes | 21910 | Digital | East/West |
| LSGO01 | Hwy 142 | Goldendale | WA | 8 | 16.0 | No | 1748 | Digital | East/West |
| LSKL01 | S. 6th St. | Klamath Falls | OR | 8 | 24.0 | Yes | 11414 | Poster | East/West |
| LSSP01 | Hwy 126 | Springfield | OR | 7 | 14.0 | Yes | 10037 | Junior Poster | East/West |
| BillboardID | Location | City | State | Height | Width | Illuminated | DEC | Type | Facing |
| LHCA03 | Hwy 20-26 | Casper | WY | 10 | 32.0 | No | 1288 | Bulletin | West Only |
| LHCH05 | Hwy 93 | Challis | ID | 8 | 24.0 | No | 506 | Poster | North/South |
| LHCO05 | Hwy 89 | Cokeville | WY | 10 | 20.0 | No | 506 | Poster | North/South |
| LHDC07 | Hwy 89 | Alpine | WY | 6 | 8.0 | No | 1964 | Junior Poster | North Only |
| LHDD01 | Hwy 26 | Dubois | WY | 8 | 24.0 | Yes | 1016 | Poster | East/West |
| LHPA03 | Hwy 95 | Payette | ID | 12 | 24.0 | No | 3777 | Bulletin | North/South |
| LHRI01 | Hwy 95 | Riggins | ID | 8 | 24.0 | Yes | 1524 | Digital | North/South |
| LHRI02 | Hwy 20 | Rigby | ID | 14 | 48.0 | Yes | 13406 | Bulletin | North/South |
| LHTW01 | Hwy 93 | Twin Falls | ID | 6 | 12.0 | No | 1564 | Junior Poster | North/South |
| LHWE01 | Hwy 95 | Weiser | ID | 10.5 | 24.0 | No | 1748 | Poster | North/South |
| LHWE04 | I-90 Exit 60 | Wallace | ID | 14 | 48.0 | Yes | 6888 | Bulletin | East/West |
| LIBO01 | I-84 Exit 57 | Boise | ID | 21 | 47.0 | Yes | 14104 | Bulletin | East/West |
SELECT DISTINCTROW *
FROM AdRep;
SELECT DISTINCTROW *
FROM [Idaho Wyoming Billboards];
SELECT Billboard.BillboardID, Billboard.Location, Billboard.City, Billboard.State, Billboard.Height, Billboard.Width, Billboard.Illuminated, Billboard.DEC, Billboard.Type, Billboard.Facing
FROM Billboard;
SELECT [FirstName] & " " & [LastName] AS StudentName, [_GradingReport].ProjectName, "Submission #" & [SubmissionNum] AS SubmissionCt, [_GradingReport].Score, [_GradingReport].MaxScore, "Score is: " & [Score] & " out of " & [MaxScore] AS Grade, [_GradingReportSteps].[StepNumber] & ". " & [Description] AS Step, [_GradingReportSteps].[StepScore] & "/" & [_GradingReportSteps].[StepMaxScore] AS StepGrade, [_GradingReportSteps].ActionName, IIf([ifsuccessful]=True,Null,[ErrorText]) AS Feedback, [_GradingReportSteps].IfSuccessful, [_GradingIcons].GA_Status_Icon, [_GradingReportSteps].StepNumber, [_GradingReportSteps].StepActionOrder, [_GradingReportSteps].ID, [_GradingIcons].SAM_Logo, [_GradingReportSteps].Description, [_GradingReport].EngineVersion
FROM _GradingReport, _GradingIcons INNER JOIN _GradingReportSteps ON [_GradingIcons].[IfSuccessful_Status] = [_GradingReportSteps].IfSuccessful;
Eparker16
