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 | |
4 | Jane | Taylor | 8206 Marshall Dr | Lenexa | KS | 66214 | 5552229101 | |
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 | |
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 | |
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 | |
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 | |
26 | Robert | Nelson | 201 Birch St | Overland Park | KS | 66206 | 5558884514 | Internet |
27 | Jaele | Clark | 620 King St | Overland Park | KS | 66210 | 5557776434 | |
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 | |
32 | Lisa | Gomez | 345 College Rd | Ridgedale | MO | 65777 | 5557778504 | |
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 | |
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 | |
43 | Lois | Gordon | 900 Barnes St | West Des Moines | IA | 50265 | 5556661324 | |
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;