final assessment

SC_AC16_2a_me_1.accdb

Home >Applied Sciences homework help >final assessment

IfSuccessful_Status	GA_Status_Icon	SAM_Logo
true
false

ID	FirstName	LastName	AssignmentGUID	UserID
false	Wilson	Aguilar-Pulla	{9A01FA72-F75B-4623-8E75-A0BC10834675}	{9A01FA72-F75B-4623-8E75-A0BC10834675}

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	DateHired
AM01	Abraham	Miller	503-555-6032	54 Quarry Ave.	Portland	OR	97210	¤ 32,540.00	6/1/16
GZ01	Gregory	Zdalnza	603-555-8765	7 Moose Head Rd.	Boise	ID	83720	¤ 29,675.00	9/14/16
KS02	Kathryn	Stenhope	503-555-0003	9 Shennadoah Ave.	Salem	OR	97311	¤ 34,576.00	10/5/15
MR01	Max	Riley	781-555-2323	24 Spring Rd.	Casper	WY	83114	¤ 30,450.00	8/6/16
RH01	Rowan	Horton	207-555-9009	12 Heather Rd.	Portland	OR	97211	¤ 35,275.00	7/13/15
SL01	Stephanie	Lorens	802-555-3339	15 River Rd.	Spokane	WA	99202	¤ 37,350.00	4/5/15
UG01	Ursula	Grea-Mayers	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	KS01
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	KS01
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	KS01

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
ID	Idaho
OR	Oregon
WA	Washington
WY	Wyoming

SELECT Advertiser.AdvertiserID, Advertiser.AdvertiserName, Advertiser.Address, Advertiser.City, Advertiser.State, Advertiser.PostalCode, Advertiser.AdRepNumber FROM Advertiser;

SELECT AdRep.LastName, Advertiser.AdvertiserName, Advertiser.[Current Due] FROM AdRep INNER JOIN Advertiser ON AdRep.AdRepNumber = Advertiser.AdRepNumber ORDER BY AdRep.LastName, Advertiser.AdvertiserName;

SELECT Billboard.BillboardID, Billboard.Location, Billboard.City, Billboard.State, Billboard.Height, Billboard.Width, Billboard.Illuminated, Billboard.DEC, Billboard.Type, Billboard.Facing FROM Billboard WHERE (((Billboard.State)="WA"));

SELECT Billboard.BillboardID, Billboard.Location, Billboard.State, Billboard.Type FROM Billboard;

SELECT Billboard.Type, Billboard.BillboardID FROM Billboard;

SELECT Billboard.BillboardID, Billboard.Location, Billboard.State, Billboard.Illuminated, Billboard.DEC, Billboard.Type, Billboard.Facing FROM Billboard;

SELECT Advertiser.AdvertiserName, Advertiser.Address, Advertiser.City, Advertiser.State, Advertiser.PostalCode FROM Advertiser;

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 Advertiser.AdRepNumber, Advertiser.AdvertiserName, Advertiser.[Current Due] FROM Advertiser;

SELECT Advertiser.AdvertiserID, Advertiser.AdvertiserName, Advertiser.[Current Due], Advertiser.AdRepNumber FROM Advertiser;

SELECT Billboard.BillboardID, Billboard.Location, Billboard.City, Billboard.State, Billboard.Type FROM Billboard;

SELECT Billboard.BillboardID, Billboard.City, Billboard.State, Billboard.DEC FROM Billboard;

SELECT Billboard.BillboardID, Billboard.Location, Billboard.Height, Billboard.Width FROM Billboard;

SELECT Advertiser.AdvertiserID, Advertiser.AdvertiserName, Advertiser.[Current Due], Advertiser.AdRepNumber FROM Advertiser;

SELECT Advertiser.City FROM Advertiser ORDER BY Advertiser.City;

SELECT Advertiser.AdvertiserID, Advertiser.AdvertiserName, Advertiser.State, Advertiser.[Current Due], Advertiser.AdRepNumber FROM Advertiser WHERE (((Advertiser.State)="WA"));