SC_AC16_10a

profileDogstar1
SC_AC16_10a_FirstLast_1.accdb
Home>Computer Science homework help>SC_AC16_10a
IfSuccessful_Status GA_Status_Icon SAM_Logo
true
false
ID FirstName LastName AssignmentGUID UserID
false First Last {39B9047B-E2F2-4E70-916E-70CF1D93F4C6} {39B9047B-E2F2-4E70-916E-70CF1D93F4C6}
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 Special Skills
AM01 Miller Abraham 54 Quarry Ave. Portland OR 97210 503-555-6032 ¤ 32,540.00 6/1/16 Fluent in Spanish
GZ01 Zdalnza Gregory 7 Moose Head Rd. Boise ID 83720 603-555-8765 ¤ 29,675.00 9/14/16 Trains new employees
KS02 Stenhope Kathryn 9 Shennadoah Ave. Salem OR 97311 503-555-0003 ¤ 34,576.00 10/5/15 Bachelor's degree in Marketing
MR01 Riley Max 24 Springtown Rd. Casper WY 83114 781-555-2323 ¤ 30,450.00 8/6/16 Likes to travel; makes routine checks of billboards
RH01 Horton Rowan 12 Heather Rd. Portland OR 97211 207-555-9009 ¤ 35,275.00 7/13/15 Bachelor's degree in Business Administration
SL01 Lorens Stephanie 15 River Rd. Spokane WA 99202 802-555-3339 ¤ 37,350.00 4/5/15 Working on a Master's degree in Communications
UG01 Grea-Mayers Ursula 342 Pine St. Seattle WA 98101 207-555-8534 ¤ 41,765.00 12/12/14 Fluent in Spanish
AdvertiserID AdvertiserName Address City State PostalCode Phone Amount Paid Current Due AdRepNumber Customer Notes
BBF32 Babbage CPA Firm 464 Linnell Dr. Seattle WA 98104 ¤ 5,678.25 ¤ 7,875.25 UG01
BCC76 Burns Community College 867 Ridge Ave. Burns OR 97720 ¤ 0.00 ¤ 5,452.30 RH01
BMS53 Boise Medical Services 134 Main St. Boise ID 83720 6035552883 ¤ 7,562.40 ¤ 6,152.25 GZ01 Designs own ads
CDS29 Carter Dental Services 123 Second St. Dallesport WA 98617 ¤ 3,452.10 ¤ 5,475.75 SL01
CRR15 Columbia River Rafters 125 River Blvd. Portland OR 97209 ¤ 4,567.25 ¤ 3,600.50 RH01
CWW01 Casper Western Wear 10 Broadway St. Casper WY 83114 ¤ 0.00 ¤ 4,125.50 MR01
GAD74 Grant Antique Dealers 78 Catawba Dr. Grants Pass OR 97526 ¤ 1,500.00 ¤ 1,200.00 GZ01
GPM12 Grants Pass Motel 235 Second Ave. Grants Pass OR 97526 ¤ 2,460.75 ¤ 2,460.75 AM01
GRI03 Germann Inn 345 Hartsel Ave. Madras OR 97741 ¤ 1,325.45 ¤ 2,900.50 AM01
HAR01 Haydee's Restaurant 234 Twiddy St. Eugene OR 97402 ¤ 3,000.00 ¤ 2,500.00 RH01
HCH10 Hendley County Hospital 216 Rivard Blvd. Spokane WA 99201 ¤ 9,456.75 ¤ 7,234.60 SL01
IOA23 Idaho Outdoor Adventures 12 Third St. Twin Falls ID 83301 ¤ 4,200.00 ¤ 6,500.00 KS02
KDS21 KAL Design Studio 116 Pine St. Arden WA 99202 ¤ 775.00 ¤ 1,550.50 UG01
KGS04 Kyle General Store 421 First St. Cokeville WY 83114 ¤ 3,452.00 ¤ 2,875.50 MR01
LCA42 Lews and Clark Adventures 100 Main St. Goldendale WA 98620 ¤ 2,500.00 ¤ 4,500.00 SL01
LFS02 Lewis Furniture Store 267 Main St. Payette ID 83661 ¤ 1,234.50 ¤ 2,890.70 MR01
MBT14 Mike's Bike Tours 234 Gilham St. Salem OR 97301 ¤ 1,090.75 ¤ 1,345.60 KS02
PJG34 Patricia Jean Greenhouses 345 Magee Ave. Seattle WA 98101 ¤ 1,345.00 ¤ 2,450.00 UG01
RER23 Rivers Edge Restaurant 125 River Rd. Kettle Falls WA 99141 ¤ 1,200.00 ¤ 1,375.00 GZ01
SLA77 Smarter Law Associates 764 Main St. Portland OR 97209 ¤ 7,500.00 ¤ 0.00 AM01
TVS17 Theon Veterinary Services 346 Austin Ave. Casper WY 83114 ¤ 2,225.60 ¤ 2,500.00 MR01
WEC05 Western Energy Company 12 Polk St. Kettle Falls WA 99141 ¤ 3,450.80 ¤ 0.00 GZ01
WSC01 Wood Sports Complex 578 Central Ave. Cave Junction OR 97523 ¤ 2,345.50 ¤ 3,590.80 KS02
BillboardID Location City State Height Width SqrFt Illuminated DEC Type
LHAR04 Hwy 395 Arden WA 8.0 24.0 192.0 Yes 4395 Digital
LHBE01 Hwy 97 Beaver Marsh OR 8.0 24.0 192.0 Yes 3542 Digital
LHBU01 Hwy 395 Burns OR 10.5 48.0 504.0 Yes 1509 Poster
LHCA01 Hwy 199 Cave Junction OR 6.0 16.0 96.0 No 2024 Junior Poster
LHCA03 Hwy 20-26 Casper WY 10.0 32.0 320.0 No 1288 Bulletin
LHCH03 Hwy 97 Chemult OR 10.0 24.0 240.0 Yes 3411 Digital
LHCH05 Hwy 93 Challis ID 8.0 24.0 192.0 No 506 Poster
LHCO05 Hwy 89 Cokeville WY 10.0 20.0 200.0 No 506 Poster
LHDA03 Hwy 197 Dallesport WA 8.0 20.0 160.0 No 3700 Junior Poster
LHDC07 Hwy 89 Alpine WY 6.0 8.0 48.0 No 1964 Junior Poster
LHDD01 Hwy 26 Dubois WY 8.0 24.0 192.0 Yes 1016 Poster
LHGR01 Hwy 18 Grand Ronde OR 10.0 30.0 300.0 Yes 5182 Bulletin
LHGR02 Hwy 99 Grants Pass OR 10.0 25.0 250.0 Yes 5838 Poster
LHKE01 Hwy 395 Kettle Falls WA 6.0 10.0 60.0 No 7400 Junior Poster
LHKL01 Hwy 97 Klamath Falls OR 10.0 24.0 240.0 Yes 4461 Digital
LHMA01 Hwy 97 Madras OR 8.0 24.0 192.0 Yes 12070 Digital
LHMP01 Hwy 97 Modoc Point OR 8.0 24.0 192.0 Yes 5500 Poster
LHPA03 Hwy 95 Payette ID 12.0 24.0 288.0 No 3777 Bulletin
LHRI01 Hwy 95 Riggins ID 8.0 24.0 192.0 Yes 1724 Digital
LHRI02 Hwy 20 Rigby ID 14.0 48.0 672.0 Yes 13406 Bulletin
LHRO01 Hwy 101 Rockaway OR 5.0 8.0 40.0 No 1702 Junior Poster
LHSA01 Hwy 114 Salem OR 8.0 24.0 192.0 Yes 10224 Poster
LHSA03 Liberty Road Salem OR 9.0 27.0 243.0 Yes 11808 Poster
LHSA05 Hwy 99 Salem OR 8.0 24.0 192.0 Yes 10224 Poster
LHTW01 Hwy 93 Twin Falls ID 6.0 12.0 72.0 No 1564 Junior Poster
LHWE01 Hwy 95 Weiser ID 10.5 24.0 252.0 No 1748 Poster
LHWE04 I-90 Exit 60 Wallace ID 14.0 48.0 672.0 Yes 6888 Bulletin
LIBO01 I-84 Exit 57 Boise ID 21.0 47.0 987.0 Yes 14104 Bulletin
LIRO01 I-5 Exit 120 Roseburg OR 12.0 48.0 576.0 Yes 27618 Bulletin
LNPO01 I-84 Exit 1 Portland OR 14.0 48.0 672.0 Yes 110667 Bulletin
LSCO05 Hwy 42 Coquille OR 8.0 25.0 200.0 Yes 5642 Digital
LSEU01 6th Ave. Eugene OR 10.0 24.0 240.0 Yes 19942 Poster
LSEU05 Maxwell St. Eugene OR 12.0 24.0 288.0 Yes 5707 Poster
LSEU07 W. 11th St. Eugene OR 10.0 24.0 240.0 Yes 21910 Digital
LSGO01 Hwy 142 Goldendale WA 8.0 16.0 128.0 No 1748 Digital
LSKL01 S. 6th St. Klamath Falls OR 8.0 24.0 192.0 Yes 11414 Poster
LSSP01 Hwy 126 Springfield OR 7.0 14.0 98.0 Yes 10037 Junior Poster
BillboardTypeID Description
BN Bulletin
DL Digital
JP Junior Poster
PT Poster
RentalID BillboardID Facing Cost Deposit Months BeginDate Discount Rental Contract AdvertiserID
1700200 LHBU01 North ¤ 775.00 ¤ 0.00 3.0 6/5/17 false BCC76
1700201 LNPO01 East ¤ 1,600.00 ¤ 0.00 4.0 5/2/17 false CRR15
1700202 LNPO01 West ¤ 1,400.00 ¤ 0.00 8.0 3/14/17 true SLA77
1700204 LHAR04 North ¤ 2,500.00 ¤ 0.00 1.0 9/4/17 false KDS21
1700205 LHSA03 North ¤ 800.00 ¤ 0.00 2.0 7/1/17 false MBT14
1700206 LHSA03 South ¤ 800.00 ¤ 0.00 2.0 7/1/17 false MBT14
1700208 LHGR02 North ¤ 790.00 ¤ 0.00 2.0 9/12/17 false GAD74
1700209 LHTW01 North ¤ 350.00 ¤ 0.00 5.0 4/11/17 false IOA23
1700210 LHDA03 South ¤ 300.00 ¤ 0.00 6.0 6/5/17 true CDS29
1700211 LHCO05 North ¤ 875.00 ¤ 0.00 4.0 5/12/17 false KGS04
1700212 LHWE01 South ¤ 900.00 ¤ 0.00 1.0 9/12/17 false BMS53
1700213 LSGO01 West ¤ 2,875.00 ¤ 0.00 10.0 2/1/17 false LCA42
1700215 LHMA01 South ¤ 3,000.00 ¤ 0.00 3.0 6/5/17 false GRI03
1700216 LHCA03 West ¤ 2,750.00 ¤ 0.00 4.0 6/24/17 true CWW01
1700217 LHCA01 North ¤ 325.00 ¤ 0.00 7.0 3/21/17 false WSC01
1700219 LHPA03 South ¤ 1,625.00 ¤ 0.00 3.0 8/13/17 false LFS02
1700220 LSEU01 East ¤ 775.00 ¤ 0.00 2.0 7/1/17 false HAR01
1700222 LHDD01 East ¤ 825.00 ¤ 0.00 1.0 9/14/17 false KGS04
1700223 LHKE01 South ¤ 365.00 ¤ 0.00 3.0 8/25/17 false HCH10
1700224 LHAR04 South ¤ 3,500.00 ¤ 0.00 10.0 2/1/17 false LCA42
1700225 LHKE01 North ¤ 375.00 ¤ 0.00 3.0 6/12/17 false RER23
1700226 LHCH05 North ¤ 700.00 ¤ 0.00 4.0 5/25/17 true IOA23
1700227 LIBO01 West ¤ 1,525.00 ¤ 0.00 4.0 7/1/17 false BMS53
1700229 LHPA03 North ¤ 1,625.00 ¤ 0.00 3.0 8/14/17 false LFS02
1700230 LHGR02 North ¤ 790.00 ¤ 0.00 1.0 2/1/17 false GPM12
State StateName
CA California
ID Idaho
NV Nevada
OR Oregon
WA Washington
WY Wyoming
SELECT AdRep.AdRepNumber, AdRep.LastName FROM AdRep ORDER BY AdRep.LastName;
SELECT [AdRep].[AdRepNumber], [AdRep].[FirstName], [AdRep].[LastName] FROM AdRep ORDER BY [AdRepNumber];
SELECT [Billboard].[BillboardID], [Billboard].[City] FROM Billboard;
PARAMETERS __BillboardID Value; SELECT DISTINCTROW * FROM [SELECT [Billboard].[BillboardID], [Billboard].[Location], [Billboard].[State] FROM Billboard]. AS [Rentals and Billboards Form] WHERE ([__BillboardID] = BillboardID);
SELECT DISTINCTROW * FROM AdRep;
SELECT DISTINCTROW * FROM Advertiser;
SELECT DISTINCTROW * FROM Advertiser;
SELECT DISTINCTROW * FROM Billboard;
SELECT DISTINCTROW * FROM States;
SELECT DISTINCTROW * FROM Rentals;
SELECT DISTINCTROW * FROM Rentals;
SELECT DISTINCTROW * FROM States;
SELECT DISTINCTROW * FROM States;
SELECT DISTINCTROW * FROM Advertiser;
SELECT DISTINCTROW * FROM Billboard;
SELECT AdRep.AdRepNumber, AdRep.LastName, AdRep.FirstName, AdRep.DateHired, AdRep.[Special Skills] FROM AdRep WHERE (((AdRep.DateHired)>#1/1/2016#) AND ((AdRep.[Special Skills]) Like "*Spanish*"));
SELECT AdRepNumber, FirstName, Address, City, State, PostalCode FROM AdRep;
SELECT AdRep.AdRepNumber, AdRep.FirstName, AdRep.LastName, Advertiser.AdvertiserID, Advertiser.AdvertiserName, Advertiser.[Amount Paid], Advertiser.[Current Due] FROM AdRep INNER JOIN Advertiser ON AdRep.AdRepNumber = Advertiser.AdRepNumber;
SELECT AdRep.AdRepNumber, Advertiser.AdvertiserID, Rentals.RentalID, [Cost]*[Months] AS [Total Cost] FROM (AdRep INNER JOIN Advertiser ON AdRep.AdRepNumber = Advertiser.AdRepNumber) INNER JOIN Rentals ON Advertiser.AdvertiserID = Rentals.AdvertiserID;
SELECT AdRepNumber, FirstName, LastName, City, State FROM AdRep;
SELECT AdRepNumber, FirstName, LastName, Address, City, State FROM AdRep WHERE State = 'OR';
SELECT BillboardID, Location, City, State, DEC FROM Billboard;
SELECT BillboardID, Location, City, State, Type FROM Billboard WHERE Type = 'Digital';
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 COUNT(BillboardID) AS NumberBillboards FROM Billboard;
SELECT BillboardID, StateName FROM Billboard, States;
SELECT BillboardID FROM Billboard WHERE State = 'OR';
SELECT RentalID, BillboardID, Cost, Months, BeginDate FROM Rentals;
SELECT RentalID, BillboardID, Cost, Months FROM Rentals;
SELECT AdRepNumber, LastName, FirstName, State FROM AdRep;