Microsoft Access Work

IfSuccessful_Status GA_Status_Icon SAM_Logo
true
false
ID FirstName LastName AssignmentGUID UserID
false Paulette West {01121CA1-7441-4AA2-A108-DA94031C3B66} {01121CA1-7441-4AA2-A108-DA94031C3B66}
ID FirstName LastName ProjectName SubmissionNum MaxScore Score EngineVersion
ID StepNumber Description IfSuccessful StepScore StepMaxScore ErrorText ActionName StepActionOrder
Category Description
Adventure Adventure experiences include skiing, scuba, biking, hiking, and climbing tours.
Eco Eco experiences work on environmental or ecological projects.
CustNo FName LName Street City State Zip Phone FirstContact
1 Mindi Scott 52411 Oakmont Rd Kansas City MO 64144 5554441234 Friend
2 Jacob Alman 2505 McGee St Waukee IA 50288 5551116931 Friend
3 Julia Bouchart 5200 Main St Kansas City MO 64105 5551113081 Mail
4 Jane Taylor 8206 Marshall Dr Lenexa KS 66214 5552229101 Mail
5 Samantha Garcia 600 Elm St Olathe KS 66031 5552227002 Friend
6 Kristen Collins 520 W 52nd St Kansas City KS 64105 5552223602 Radio
7 Tom Camel 520 W 52nd St Kansas City KS 64105 5552223602 Radio
8 Dick Lee 66020 King St Overland Park KS 66210 5552228402 Internet
9 Daniel Gonzalez 52520 W. 505 Ter Lenexa KS 66215 5553339871 Internet
10 Brad Perez 56 Jackson Rd Kansas City MO 64145 5553330401 Mail
11 Nancy Walker 466 Lincoln Rd Kansas City MO 64105 5553330401 Friend
12 Kathryn Hall 96 Lowell St Overland Park KS 66210 5554444404 Internet
13 Anne Johnson 525 Ambassador Dr Kansas City MO 64145 5554448844 Mail
14 Mary Jane Ramirez 903 East 504th St. Kansas City KS 64131 5554447414 Radio
15 Frank Torres 305 W. 99th St Lenexa KS 66215 5555664344 Radio
16 David Carter 7066 College Rd Overland Park KS 66211 5559997154 Internet
17 Jose Edwards 624 Richmond Ter Clive IA 50266 5556660365 Mail
18 Ralph Stewart 4435 Main St Greenfield IA 50849 5557778774 Internet
19 Naresh Blackwell 2345 Grand Blvd Kansas City KS 64108 5558886004 Friend
20 Elsie Smith 5253 Duck Creek Dr Iowa City IA 52240 5559998777 Friend
21 Toby Smith 5253 Duck Creek Dr Iowa City IA 52240 5559998777 Friend
22 Brandon Moore 3966 Woodland St West Des Moines IA 50266 5552228908 Internet
23 Gabriel Martin 345 College Rd Overland Park KS 66210 5553338505 Radio
24 Douglas Flores 525 College Rd Overland Park KS 66210 5554448505 Friend
25 Aaron Hill 2584 Meyer Rd Kansas City KS 64132 5557779414 Mail
26 Robert Nelson 201 Birch St Overland Park KS 66206 5558884514 Internet
27 Jaele Clark 620 King St Overland Park KS 66210 5557776434 Mail
28 Jenny Lewis 895 Lowell Dr Overland Park KS 66211 5556665084 Friend
29 Marcie Young 8320 Grant St Kansas City MO 64114 5552221388 Internet
30 Sharol Wood 2330 Shawnee Dr Westwood KS 66205 5553332434 Friend
31 Zohra Bell 506 Lowell St Point Lookout MO 65727 5556664404 Mail
32 Lisa Gomez 345 College Rd Ridgedale MO 65777 5557778504 Mail
33 Shirley Cruz 46 Maple Rd Hollister MO 65727 5551110403 Radio
34 Kori James 5234 Ash Rd Ridgedale MO 65777 5552228503 Radio
35 Jeanette Gray 4435 Main St Branson MO 65726 5552228773 Radio
36 Brad Long 123 Duck Creek Dr Johnston IA 50800 5553328888 Internet
37 Madison West 57 West 159th St Cushing PA 87087 5552887722 Radio
38 Nancy Cole 123 Duck Creek Dr Johnston IA 50800 5553328888 Internet
39 Tim Hayes 8206 Marshall Dr Lenexa KS 66214 5552229101 Mail
40 Hannah Hunter 66900 College Rd Overland Park KS 66210 5552225102 Radio
41 Marcus Mason 66900 College Rd Overland Park KS 66210 5552225102 Radio
42 Kris Shaw 900 Barnes St West Des Moines IA 50265 5556661324 Mail
43 Lois Gordon 900 Barnes St West Des Moines IA 50265 5556661324 Mail
44 Samuel Livingston 1551 Switzer St Gardner KS 66303 5556633366 Internet
45 Julie Livingston 1551 Switzer St Gardner KS 66303 5556633366 Internet
46 Aaron Wheeler 5989 Washington Ave Hollister MO 67827 5556766677 Internet
47 Kelsey Silva 7800 West 16th St Manhattan KS 66502 5556655522 Internet
48 Orlando Berry 7722 Mastin St Mission KS 63552 5558887722 Internet
49 Maria Armstrong 7722 Mastin St Mission KS 63552 5558887722 Internet
SalesNo SaleDate CustNo TripNo
1 4/28/20 18 1
2 4/28/20 32 1
3 4/28/20 6 3
4 4/28/20 42 1
5 4/28/20 43 1
6 4/28/20 19 1
7 4/29/20 3 12
8 4/29/20 7 3
9 5/3/20 33 10
10 5/3/20 31 10
11 5/3/20 12 10
12 5/3/20 17 10
13 5/9/20 4 2
14 5/29/20 34 1
15 5/30/20 30 36
16 5/30/20 43 36
17 5/30/20 39 36
18 5/30/20 15 36
19 5/30/20 7 47
20 5/30/20 4 36
21 5/30/20 6 47
22 5/30/20 42 36
23 5/30/20 18 36
24 5/31/20 38 36
25 5/31/20 36 36
26 6/1/20 40 36
27 6/1/20 41 36
28 6/28/20 25 1
29 6/29/20 6 36
30 6/29/20 5 2
31 6/29/20 29 2
32 6/29/20 11 2
33 6/29/20 3 2
34 6/29/20 2 2
35 6/29/20 1 2
36 6/29/20 7 36
37 6/30/20 15 2
38 6/30/20 14 2
39 7/5/20 43 51
40 7/5/20 6 51
41 7/5/20 7 51
42 7/5/20 42 51
43 7/6/20 8 51
44 7/6/20 17 51
45 7/7/20 9 36
46 7/7/20 9 51
47 7/7/20 41 51
48 7/7/20 40 51
49 7/7/20 19 51
50 7/7/20 11 51
51 7/7/20 12 36
52 7/9/20 5 51
53 7/9/20 26 3
54 7/9/20 19 3
55 7/10/20 20 3
56 7/10/20 24 3
57 7/10/20 21 3
58 7/10/20 22 3
59 7/11/20 30 3
60 7/11/20 28 3
61 7/11/20 29 3
62 7/11/20 43 3
63 7/11/20 42 3
64 7/12/20 11 5
65 7/12/20 15 5
66 7/12/20 10 4
67 7/12/20 13 4
68 7/13/20 34 5
69 7/13/20 14 5
70 7/13/20 35 5
71 7/13/20 17 5
72 7/13/20 13 5
73 7/13/20 12 5
74 7/17/20 15 6
75 7/17/20 31 6
76 7/18/20 33 6
77 7/18/20 42 6
78 7/18/20 32 6
79 7/18/20 43 6
80 7/19/20 18 6
81 7/19/20 25 6
82 7/20/20 16 7
83 7/20/20 22 7
84 7/20/20 27 7
85 7/20/20 28 7
86 7/24/20 23 7
87 7/24/20 20 7
88 7/24/20 21 7
89 7/31/20 24 8
90 7/31/20 27 9
91 8/1/20 26 8
92 8/4/20 17 9
93 8/5/20 15 9
94 8/5/20 29 9
95 8/6/20 25 8
96 8/7/20 23 8
98 8/8/20 36 44
99 8/11/20 38 44
100 8/11/20 42 46
101 8/12/20 43 46
102 8/12/20 20 45
103 8/13/20 21 45
104 8/14/20 44 3
105 8/15/20 45 3
106 8/15/20 46 3
107 8/15/20 47 3
StateName StateAbbreviation
Alaska AK
Alabama AL
Arkansas AR
Arizona AZ
California CA
Colorado CO
Connecticut CT
District of Columbia DC
Delaware DE
Florida FL
Georgia GA
Hawaii HI
Iowa IA
Idaho ID
Illinois IL
Indiana IN
Kansas KS
Kentucky KT
Louisiana LA
Massachusetts MA
Maryland MD
Maine ME
Michigan MI
Minnesota MN
Missouri MO
Mississippi MS
Montana MT
North Carolina NC
North Dakota ND
Nebraska NE
New Hampshire NH
New Jersey NJ
New Mexico NM
Nevada NV
New York NY
Ohio OH
Oklahoma OK
Oregon OR
Pennsylvania PA
Rhode Island RI
South Carolina SC
South Dakota SD
Tennessee TN
Texas TX
Utah UT
Virginia VA
Vermont VT
Washington WA
Wisconsin WS
West Virginia WV
Wyoming WY
TripNo TripName TripStartDate Duration City StateAbbrev Category Price
1 Stanley Bay Cleanup 7/4/20 3 Captiva FL Eco ¤ 750.00
2 Red Reef Cleanup 7/4/20 3 Islamorada FL Eco ¤ 1,500.00
3 Breckenridge Reconstruction 12/31/20 7 Breckenridge CO Eco ¤ 850.00
4 Boy Scout Project 8/1/20 7 Vail CO Eco ¤ 1,000.00
5 Bridgewater Country Study 8/5/20 10 Aspen CO Eco ¤ 2,000.00
6 Rocky Mountain Mission 8/9/20 3 Breckenridge CO Adventure ¤ 1,700.00
7 Monmouth Festival 11/10/20 7 Monmouth CO Eco ¤ 1,800.00
8 Great Fish Count 9/1/20 9 Denver CO Eco ¤ 700.00
9 Bikers for Ecology 9/10/20 5 Georgetown CO Adventure ¤ 800.00
10 Golden Hands Venture 5/21/20 4 Orlando FL Adventure ¤ 900.00
11 Hummer Trail Study 5/28/20 7 Key West FL Eco ¤ 1,250.00
12 Coastal Shore Cleanup 5/28/20 7 Captiva FL Adventure ¤ 1,000.00
13 High Adventurers 6/3/20 7 Ft. Lauderdale FL Adventure ¤ 1,400.00
15 Patriots in Disneyland 6/10/20 7 Orlando FL Adventure ¤ 1,500.00
17 Tropical Sailboat Voyage 6/17/20 7 Key West FL Adventure ¤ 1,450.00
18 Eagle Hiking Club 6/17/20 7 Aspen CO Adventure ¤ 1,500.00
19 Paradise Water Club 6/24/20 7 Fort Collins CO Adventure ¤ 1,400.00
20 Team Discovery 6/27/20 5 Breckenridge CO Adventure ¤ 1,200.00
21 Gulfside Birdwatchers 6/27/20 7 Tampa Bay FL Adventure ¤ 1,550.00
22 Perfect Waves Project 6/25/20 5 Huntington Beach CA Adventure ¤ 800.00
23 Outrigger Cleanup 6/27/20 7 Leadville CO Eco ¤ 1,000.00
24 Blue Canyon Youth Project 6/29/20 7 Breckenridge CO Adventure ¤ 1,400.00
25 Emmanuel Youth Club 6/29/20 7 Aspen CO Eco ¤ 900.00
26 Prairie Restoration Project 6/30/20 3 West Denver CO Eco ¤ 200.00
27 Butterfly House Construction 6/30/20 3 Denver CO Eco ¤ 400.00
28 Bass Habitat Project 6/30/20 4 Broomfield CO Eco ¤ 500.00
29 Silver Country Venture 7/11/20 14 Sacramento CA Adventure ¤ 3,500.00
30 Monterey Mysteries 7/12/20 7 Monterey CA Adventure ¤ 1,800.00
36 California Coastline Cleanup 8/22/20 7 San Diego CA Eco ¤ 1,200.00
37 Cactus Ecosystem 9/12/20 7 San Diego CA Eco ¤ 800.00
38 Water Education Foundation 9/19/20 14 Fresno CA Eco ¤ 1,300.00
39 Oakland Museum of Science 7/18/20 7 Oakland CA Eco ¤ 1,000.00
40 Redwood Forest Lab 9/27/20 14 Mill Valley CA Eco ¤ 1,500.00
41 Langguth Environment 10/17/20 10 Napa CA Eco ¤ 2,900.00
43 Japanese California Connection 8/17/20 4 Bolinas CA Eco ¤ 900.00
44 Bear Valley Adventures 8/17/20 3 Sacramento CA Adventure ¤ 800.00
45 Black Sheep Hikers 8/24/20 14 El Dorado Hills CA Adventure ¤ 3,000.00
46 Bigfoot Rafting Club 9/11/20 4 Placerville CA Adventure ¤ 850.00
47 Yosemite Park Cleanup 7/18/20 3 Sacramento CA Eco ¤ 1,250.00
48 Kings Canyon Bridge Builders 7/11/20 10 Three Rivers CA Eco ¤ 2,800.00
49 Golden State Tours 7/18/20 10 Sacramento CA Adventure ¤ 2,300.00
51 Mark Twain Forest Project 11/29/20 7 Branson CO Eco ¤ 1,200.00
52 Colorado Bald Eagle Watch Club 8/11/20 7 Estes Park CO Adventure ¤ 1,100.00
53 Convoy of Hope 12/31/20 14 San Diego CA Eco ¤ 1,000.00
54 Durango Wildfire Project 9/1/20 10 Durango CO Eco ¤ 1,400.00
55 Student Last Name Project 8/1/20 5 Boulder CO Eco ¤ 500.00
SELECT TourCategories.Category FROM TourCategories;
PARAMETERS __TripNo Value; SELECT DISTINCTROW * FROM CustomerSales AS CustomerRoster WHERE ([__TripNo] = TripNo);
SELECT States.StateAbbreviation, States.StateName FROM States;
SELECT DISTINCTROW * FROM States;
SELECT DISTINCTROW * FROM Trips;
SELECT Customers.CustNo, [LName] & “, ” & [FName] AS CustomerName FROM Customers ORDER BY [LName] & “, ” & [FName];
SELECT [States].[StateName], [States].[StateAbbreviation] FROM States ORDER BY [StateAbbreviation];
SELECT Sales.SalesNo, Customers.LName, Customers.FName, Trips.TripName FROM Trips INNER JOIN (Customers INNER JOIN Sales ON Customers.CustNo = Sales.CustNo) ON Trips.TripNo = Sales.TripNo ORDER BY Customers.LName, Customers.FName, Trips.TripName;
SELECT States.StateAbbreviation, States.StateAbbreviation, States.StateName FROM States ORDER BY States.StateName;
SELECT Categories.Category FROM Categories;
SELECT [Categories].[Category], [Categories].[Description] FROM Categories;
PARAMETERS __Category Value; SELECT DISTINCTROW * FROM Trips AS TripsByCategory WHERE ([__Category] = Category);
SELECT TourCategories.Category FROM TourCategories;
SELECT TourCategories.Category FROM TourCategories;
SELECT Trips.TripNo, Trips.TripName, Trips.TripStartDate, Trips.Duration, Trips.City, Trips.StateAbbrev, Trips.Category, Trips.Price FROM Trips ORDER BY Trips.TripName;
SELECT Customers.* FROM Customers WHERE (([State]<>”MO” Or [State] IS Null));
SELECT Trips.*, Categories.Description, Categories.Category AS Category_Categories FROM Categories INNER JOIN Trips ON Categories.Category = Trips.Category;
SELECT DISTINCTROW * FROM Trips;
SELECT Customers.CustNo, Customers.FName, Customers.LName, Customers.Street, Customers.City, Customers.State, Customers.Zip, Customers.Phone, Sales.SalesNo, Sales.SaleDate, Sales.CustNo, Trips.TripNo, Trips.TripName, Trips.TripStartDate, Trips.Duration, Trips.City, Trips.StateAbbrev, Trips.Category, Trips.Price FROM Trips INNER JOIN (Customers INNER JOIN Sales ON Customers.CustNo = Sales.CustNo) ON Trips.TripNo = Sales.TripNo WHERE (((Sales.SalesNo)=[Forms]![Switchboard]![cboFindCustomer]));
SELECT Customers.CustNo, Customers.FName, Customers.LName, [LName] & “, ” & [FName] AS CustomerName, Customers.Street, Customers.City, Customers.State, Customers.Zip, Customers.Phone, Customers.FirstContact, Sales.TripNo, Sales.CustNo, Sales.SaleDate FROM Customers INNER JOIN Sales ON Customers.CustNo = Sales.CustNo;
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 Categories.Category, Categories.Description FROM Categories;
SELECT Trips.TripName, Customers.LName, Customers.FName, Sales.SaleDate FROM Trips INNER JOIN (Customers INNER JOIN Sales ON Customers.CustNo = Sales.CustNo) ON Trips.TripNo = Sales.TripNo ORDER BY Trips.TripName, Customers.LName;
SELECT Trips.TripName, Trips.TripStartDate, Trips.Duration, Trips.City, Trips.StateAbbrev, Trips.Category, Trips.Price, Sales.SaleDate, Customers.FName, Customers.LName, Customers.Street, Customers.City, Customers.State, Customers.Zip, Customers.Phone, Customers.FirstContact FROM Trips INNER JOIN (Customers INNER JOIN Sales ON Customers.CustNo = Sales.CustNo) ON Trips.TripNo = Sales.TripNo ORDER BY Trips.TripName;
SELECT Categories.Category, Trips.TripName, Trips.TripStartDate, Trips.Price FROM Categories INNER JOIN Trips ON Categories.Category = Trips.Category ORDER BY Categories.Category, Trips.TripName;
SELECT States.StateName, Trips.TripName, Trips.TripStartDate, Trips.Price, States.StateAbbreviation FROM States INNER JOIN Trips ON States.StateAbbreviation = Trips.StateAbbrev WHERE (((States.StateAbbreviation)=[Forms]![Switchboard]![cboFindState])) ORDER BY States.StateName, Trips.TripName;
 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!