Access

profilejymojica
SC_AC16_3a_JesusMojica_1.accdb
IfSuccessful_Status GA_Status_Icon SAM_Logo
true
false
ID FirstName LastName AssignmentGUID UserID
false Jesus Mojica {2747B2D8-5B5E-4B77-AD2A-2C2EEFACB4CB} {2747B2D8-5B5E-4B77-AD2A-2C2EEFACB4CB}
ID FirstName LastName ProjectName SubmissionNum MaxScore Score EngineVersion
ID StepNumber Description IfSuccessful StepScore StepMaxScore ErrorText ActionName StepActionOrder
AdRepNumber LastName FirstName PhoneNumber Address City State PostalCode Salary DateHired Insurance
AM01 Miller Abraham 503-555-6032 54 Quarry Ave. Portland OR 97210 ¤ 32,540.00 6/1/16
GZ01 Zdalnza Gregory 603-555-8765 7 Moose Head Rd. Boise ID 83720 ¤ 29,675.00 9/14/16
KS02 Stenhope Kathryn 503-555-0003 9 Shennadoah Ave. Salem OR 97311 ¤ 34,576.00 10/5/15
MR01 Riley Max 781-555-2323 24 Spring Rd Casper WY 83114 ¤ 30,450.00 8/6/16
RH01 Horton Rowan 207-555-9009 12 Heather Rd. Portland OR 97211 ¤ 35,275.00 7/13/15
SL01 Lorens Stephanie 802-555-3339 15 River Rd. Spokane WA 99202 ¤ 37,350.00 4/5/15
UG01 Grea-Mayers Ursula 207-555-8534 342 Pine St. Seattle WA 98101 ¤ 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;