SC_AC16_3a_me_1.accdb
| IfSuccessful_Status | GA_Status_Icon | SAM_Logo |
| true | |
|
| false | |
|
| ID | FirstName | LastName | AssignmentGUID | UserID |
| false | Wilson | Aguilar-Pulla | {B2FF44D2-772C-476E-8A05-5D240A67E61A} | {B2FF44D2-772C-476E-8A05-5D240A67E61A} |
| ID | FirstName | LastName | ProjectName | SubmissionNum | MaxScore | Score | EngineVersion |
| ID | StepNumber | Description | IfSuccessful | StepScore | StepMaxScore | ErrorText | ActionName | StepActionOrder |
| AdRepNumber | LastName | FirstName | Address | City | State | PostalCode | PhoneNumber | Salary | DateHired | Insurance |
| AM01 | Miller | Abraham | 54 Quarry Ave. | Portland | OR | 97210 | 503-555-6032 | ¤ 32,540.00 | 6/1/16 |
|
| GZ01 | Zdalnza | Gregory | 7 Moose Head Rd. | Boise | ID | 83720 | 603-555-8765 | ¤ 29,675.00 | 9/14/16 |
|
| KS02 | Stenhope | Kathryn | 9 Shennadoah Ave. | Salem | OR | 97311 | 503-555-0003 | ¤ 34,576.00 | 10/5/15 |
|
| MR01 | Riley | Max | 24 Spring Rd | Casper | WY | 83114 | 781-555-2323 | ¤ 30,450.00 | 8/6/16 |
|
| RH01 | Horton | Rowan | 12 Heather Rd. | Portland | OR | 97211 | 207-555-9009 | ¤ 35,275.00 | 7/13/15 |
|
| SL01 | Lorens | Stephanie | 15 River Rd. | Spokane | WA | 99202 | 802-555-3339 | ¤ 37,350.00 | 4/5/15 |
|
| UG01 | Grea-Mayers | Ursula | 342 Pine St. | Seattle | WA | 98101 | 207-555-8534 | ¤ 41,765.00 | 12/12/14 |
|
| AdvertiserID | AdvertiserName | Address | City | State | PostalCode | Current Due | AdRepNumber |
| BBF32 | Babbage CPA Firm | 464 Linnell Dr. | Seattle | WA | 98104 | ¤ 7,875.25 | UG01 |
| BCC76 | Burns Community College | 867 Ridge Ave. | Burns | OR | 97720 | ¤ 5,452.30 | RH01 |
| BMS53 | Boise Medical Services | 134 Main St. | Boise | ID | 83720 | ¤ 6,152.25 | GZ01 |
| CDS29 | Carter Dental Services | 123 Second St. | Dallesport | WA | 98617 | ¤ 5,475.75 | SL01 |
| CRR15 | Columbia River Rafters | 125 River Blvd. | Portland | OR | 97209 | ¤ 3,600.50 | RH01 |
| CWW01 | Casper Western Wear | 10 Broadway St. | Casper | WY | 83114 | ¤ 4,125.50 | MR01 |
| GAD74 | Grant Antique Dealers | 78 Catawba Dr. | Grants Pass | OR | 97526 | ¤ 1,200.00 | GZ01 |
| GCF56 | Goldendale City Foundation | 65 Simpson Dr. | Goldendale | WA | 98620 | ¤ 2,400.00 | SL01 |
| GPM12 | Grants Pass Motel | 235 Second Ave. | Grants Pass | OR | 97526 | ¤ 2,460.75 | AM01 |
| GRI03 | Germann Inn | 345 Hartsel Ave. | Madras | OR | 97741 | ¤ 2,870.65 | AM01 |
| HAR01 | Haydee's Restaurant | 234 Twiddy St. | Eugene | OR | 97402 | ¤ 2,500.00 | RH01 |
| HCH10 | Hendley County Hospital | 216 Rivard Blvd. | Spokane | WA | 99201 | ¤ 7,234.60 | SL01 |
| IOA23 | Idaho Outdoor Adventures | 12 Third St. | Twin Falls | ID | 83301 | ¤ 6,500.00 | KS02 |
| KDS21 | KAL Design Studio | 116 Pine St. | Arden | WA | 99202 | ¤ 1,550.50 | UG01 |
| KGS04 | Kyle General Store | 421 First St. | Cokeville | WY | 83114 | ¤ 2,875.50 | MR01 |
| LCA42 | Lewis and Clark Adventures | 100 Main St. | Goldendale | WA | 98620 | ¤ 4,500.00 | SL01 |
| LFS02 | Lewis Furniture Store | 267 Main St. | Payette | ID | 83661 | ¤ 2,890.70 | MR01 |
| MBT14 | Mike's Bike Tours | 234 Gilham St. | Salem | OR | 97301 | ¤ 1,345.60 | KS02 |
| PJG34 | Patricia Jean Greenhouses | 345 Magee Ave. | Seattle | WA | 98101 | ¤ 2,450.00 | UG01 |
| RER23 | Rivers Edge Restaurant | 125 River Rd. | Kettle Falls | WA | 99141 | ¤ 1,375.00 | GZ01 |
| SLA77 | Smarter Law Associates | 764 Main St. | Portland | OR | 97209 | ¤ 0.00 | AM01 |
| TVS17 | Theon Veterinary Services | 346 Austin Ave. | Casper | WY | 83114 | ¤ 2,500.00 | MR01 |
| WEC05 | Western Energy Company | 12 Polk St. | Kettle Falls | WA | 99141 | ¤ 0.00 | GZ01 |
| WSC01 | Wood Sports Complex | 578 Central Ave. | Cave Junction | OR | 97523 | ¤ 3,590.80 | KS02 |
| BillboardID | Location | City | State | Height | Width | Illuminated | DEC | Type | Facing |
| LHAR04 | Hwy 395 | Arden | WA | 8.0 | 24.0 | Yes | 4395 | Digital | North/South |
| LHBE01 | Hwy 97 | Beaver Marsh | OR | 8.0 | 24.0 | Yes | 3542 | Digital | North/South |
| LHBU01 | Hwy 395 | Burns | OR | 10.5 | 48.0 | Yes | 1509 | Poster | North/South |
| LHCA01 | Hwy 199 | Cave Junction | OR | 6.0 | 16.0 | No | 2024 | Junior Poster | North/South |
| LHCA03 | Hwy 20-26 | Casper | WY | 10.0 | 32.0 | No | 1288 | Bulletin | West Only |
| LHCH03 | Hwy 97 | Chemult | OR | 10.0 | 24.0 | Yes | 3411 | Digital | North/South |
| LHCH05 | Hwy 93 | Challis | ID | 8.0 | 24.0 | No | 506 | Poster | North/South |
| LHCO05 | Hwy 89 | Cokeville | WY | 10.0 | 20.0 | No | 506 | Poster | North/South |
| LHDA03 | Hwy 197 | Dallesport | WA | 8.0 | 20.0 | No | 3700 | Junior Poster | North/South |
| LHDC07 | Hwy 89 | Alpine | WY | 6.0 | 8.0 | No | 1964 | Junior Poster | North Only |
| LHDD01 | Hwy 26 | Dubois | WY | 8.0 | 24.0 | Yes | 1016 | Poster | East/West |
| LHGR01 | Hwy 18 | Grand Ronde | OR | 10.0 | 30.0 | Yes | 5182 | Bulletin | East/West |
| LHGR02 | Hwy 99 | Grants Pass | OR | 10.0 | 25.0 | Yes | 5838 | Poster | North Only |
| LHKE01 | Hwy 395 | Kettle Falls | WA | 6.0 | 10.0 | No | 7400 | Junior Poster | North/South |
| LHKL01 | Hwy 97 | Klamath Falls | OR | 10.0 | 24.0 | Yes | 4461 | Digital | North/South |
| LHMA01 | Hwy 97 | Madras | OR | 8.0 | 24.0 | Yes | 12070 | Digital | North/South |
| LHMP01 | Hwy 97 | Modoc Point | OR | 8.0 | 24.0 | Yes | 5500 | Poster | North/South |
| LHPA03 | Hwy 95 | Payette | ID | 12.0 | 24.0 | No | 3777 | Bulletin | North/South |
| LHRI01 | Hwy 95 | Riggins | ID | 8.0 | 24.0 | Yes | 1524 | Digital | North/South |
| LHRI02 | Hwy 20 | Rigby | ID | 14.0 | 48.0 | Yes | 13406 | Bulletin | North/South |
| LHRO01 | Hwy 101 | Rockaway | OR | 5.0 | 8.0 | No | 1702 | Junior Poster | North/South |
| LHSA01 | Hwy 114 | Salem | OR | 8.0 | 24.0 | Yes | 10224 | Poster | North/South |
| LHSA03 | Liberty Road | Salem | OR | 9.0 | 27.0 | Yes | 11808 | Poster | North/South |
| LHSA05 | Hwy 99 | Salem | OR | 8.0 | 24.0 | Yes | 10224 | Poster | North/South |
| LHTW01 | Hwy 93 | Twin Falls | ID | 6.0 | 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.0 | 48.0 | Yes | 6888 | Bulletin | East/West |
| LIBO01 | I-84 Exit 57 | Boise | ID | 21.0 | 47.0 | Yes | 14104 | Bulletin | East/West |
| LIRO01 | I-5 Exit 120 | Roseburg | OR | 12.0 | 48.0 | Yes | 27618 | Bulletin | North/South |
| LNPO01 | I-84 Exit 1 | Portland | OR | 14.0 | 48.0 | Yes | 110667 | Bulletin | East/West |
| LSCO05 | Hwy 42 | Coquille | OR | 8.0 | 25.0 | Yes | 5642 | Digital | East/West |
| LSEU01 | 6th Ave. | Eugene | OR | 10.0 | 24.0 | Yes | 19942 | Poster | East Only |
| LSEU05 | Maxwell St. | Eugene | OR | 12.0 | 24.0 | Yes | 5707 | Poster | East/West |
| LSEU07 | W. 11th St. | Eugene | OR | 10.0 | 24.0 | Yes | 21910 | Digital | East/West |
| LSGO01 | Hwy 142 | Goldendale | WA | 8.0 | 16.0 | No | 1748 | Digital | East/West |
| LSKL01 | S. 6th St. | Klamath Falls | OR | 8.0 | 24.0 | Yes | 11414 | Poster | East/West |
| LSSP01 | Hwy 126 | Springfield | OR | 7.0 | 14.0 | Yes | 10037 | Junior Poster | East/West |
| State | StateName |
| CA | California |
| NV | Nevada |
| RentalID | BillboardID | Facing | Cost | Months | BeginDate | Discount | AdvertiserID |
| 1700200 | LHBU01 | North | 775.0 | 3.0 | 6/5/17 | | BCC76 |
| 1700201 | LNPO01 | East | 1600.0 | 4.0 | 5/2/17 | | CRR15 |
| 1700202 | LNPO01 | West | 1400.0 | 8.0 | 3/14/17 | | SLA77 |
| 1700204 | LHAR04 | North | 2500.0 | 1.0 | 9/4/17 | | KDS21 |
| 1700205 | LHSA03 | North | 800.0 | 2.0 | 7/1/17 | | MBT14 |
| 1700206 | LHSA03 | South | 800.0 | 2.0 | 7/1/17 | | MBT14 |
| 1700208 | LHGR02 | North | 790.0 | 2.0 | 9/12/17 | | GAD74 |
| 1700209 | LHTW01 | North | 350.0 | 5.0 | 4/11/17 | | IOA23 |
| 1700210 | LHDA03 | South | 300.0 | 6.0 | 6/5/17 | | CDS29 |
| 1700211 | LHCO05 | North | 875.0 | 4.0 | 5/12/17 | | KGS04 |
| 1700212 | LHWE01 | South | 900.0 | 1.0 | 9/12/17 | | BMS53 |
| 1700213 | LSGO01 | West | 2875.0 | 10.0 | 2/1/17 | | LCA42 |
| 1700215 | LHMA01 | South | 3000.0 | 3.0 | 6/5/17 | | GRI03 |
| 1700216 | LHCA03 | West | 2750.0 | 4.0 | 6/24/17 | | CWW01 |
| 1700217 | LHCA01 | North | 325.0 | 7.0 | 3/21/17 | | WSC01 |
| 1700219 | LHPA03 | South | 1625.0 | 3.0 | 8/13/17 | | LFS02 |
| 1700220 | LSEU01 | East | 775.0 | 2.0 | 7/1/17 | | HAR01 |
| 1700221 | LSEU05 | West | 775.0 | 2.0 | 7/1/17 | | HAR01 |
| 1700222 | LHDD01 | East | 825.0 | 1.0 | 9/14/17 | | KGS04 |
| 1700223 | LHKE01 | South | 365.0 | 3.0 | 8/25/17 | | HCH10 |
| 1700224 | LHAR04 | South | 3500.0 | 10.0 | 2/1/17 | | LCA42 |
| 1700225 | LHKE01 | North | 375.0 | 3.0 | 6/12/17 | | RER23 |
| 1700226 | LHCH05 | North | 700.0 | 4.0 | 5/25/17 | | IOA23 |
| 1700227 | LIBO01 | West | 1525.0 | 6.0 | 7/1/17 | | BMS53 |
| State | StateName |
| ID | Idaho |
| OR | Oregon |
| WA | Washington |
| WY | Wyoming |
SELECT DISTINCTROW *
FROM Rentals;
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;
SELECT AdRep.AdRepNumber, AdRep.FirstName, AdRep.LastName
FROM AdRep;
guilardres
