Access Module 7 SAM Project 1
triceyrIL_AC16_7a_LatriceReaves_1.accdb
IfSuccessful_Status | GA_Status_Icon | SAM_Logo |
---|---|---|
true | ||
false |
ID | FirstName | LastName | AssignmentGUID | UserID |
---|---|---|---|---|
false | Latrice | Reaves | {81E75495-9AA6-4A61-A32A-1664864A97F8} | {81E75495-9AA6-4A61-A32A-1664864A97F8} |
ID | FirstName | LastName | ProjectName | SubmissionNum | MaxScore | Score | EngineVersion |
---|
ID | StepNumber | Description | IfSuccessful | StepScore | StepMaxScore | ErrorText | ActionName | StepActionOrder |
---|
Abbrev | StateTerritory |
---|---|
AK | Alaska |
AL | Alabama |
AR | Arkansas |
AS | American Samoa |
AZ | Arizona |
CA | California |
CO | Colorado |
CT | Connecticut |
DC | District Of Columbia |
DE | Delaware |
FL | Florida |
FM | Federated States Of Micronesia |
GA | Georgia |
GU | Guam |
HI | Hawaii |
IA | Iowa |
ID | Idaho |
IL | Illinois |
IN | Indiana |
KS | Kansas |
KY | Kentucky |
LA | Louisiana |
MA | Massachusetts |
MD | Maryland |
ME | Maine |
MH | Marshall Islands |
MI | Michigan |
MN | Minnesota |
MO | Missouri |
MP | Northern Mariana Islands |
MS | Mississippi |
MT | Montana |
NC | North Carolina |
ND | North Dakota |
NE | Nebraska |
NH | New Hampshire |
NJ | New Jersey |
NM | New Mexico |
NV | Nevada |
NY | New York |
OH | Ohio |
OK | Oklahoma |
OR | Oregon |
PA | Pennsylvania |
PR | Puerto Rico |
PW | Palau |
QLD | Queensland |
RI | Rhode Island |
SC | South Carolina |
SD | South Dakota |
TN | Tennessee |
TX | Texas |
UT | Utah |
VA | Virginia |
VI | Virgin Islands |
VT | Vermont |
WA | Washington |
WI | Wisconsin |
WV | West Virginia |
WY | Wyoming |
CountryName |
---|
Australia |
Bahamas |
Belize |
Bonaire |
Brazil |
Cayman Islands |
Cuba |
Curacao |
Cyprus |
Egypt |
Fiji |
Honduras |
Israel |
Jamaica |
Mexico |
United Kingdom |
US Virgin Islands |
USA |
DiveMasterID | LName | Address | City | StateProvince | ZipPostalCode | PhoneNumber | Birthday |
---|---|---|---|---|---|---|---|
1 | Schwartz | 111 Maple Street | Filmont | NM | 77881 | 5555550101 | 5/5/83 |
2 | Langguth | 222 Oak Street | Erie | PA | 34567 | 5555552344 | 2/29/80 |
3 | Eagan | 333 Elm Avenue | New York City | NY | 15875 | 5555557890 | 2/26/89 |
4 | Min | 444 Lincoln Way | Ft. Dodge | IA | 50111 | 5555557777 | 7/16/96 |
5 | Friend | 555 Perry Street | Key Largo | FL | 29922 | 5555554545 | 9/5/77 |
6 | Piper | 12345 100th Street | Long Beach | CA | 90222 | 5555551234 | 8/27/81 |
7 | Kobach | 12344 99th Street | Branson | MO | 55880 | 5555557788 | 9/30/82 |
8 | Huck | 128 Main Street | Green River | FL | 24242 | 5555557799 | 9/26/84 |
9 | Lincoln | 789 Jackson Street | Dallas | TX | 68686 | 6662234343 | 1/30/86 |
10 | Aaron | 600 Lenexa Road | Hartford | CT | 12345 | 2227060500 | 2/5/85 |
ID | DiveMasterID | Location | City | State | Country | StartDate | Lodging | TripPrice | Rating | Certification | Participants | TripReport |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | Great Barrier Reef | Cairns | Australia | 5/13/17 | Royal Palm | ¤ 3,000.00 | 4.0 | true | 5 | A goal of the trip is to help identify feeding locations for the humpback dolphin. | |
2 | 2 | Grand Bahama Island | Bimini | Bahamas | 2/6/17 | Travel 6 Inn | ¤ 2,000.00 | 4.0 | false | 6 | ||
3 | 2 | Grand Bahama Island | Nassau | Bahamas | 10/6/17 | Marriott Sands | ¤ 2,500.00 | 3.0 | true | 12 | ||
4 | 3 | Grand Bahama Island | Nassau | Bahamas | 12/29/16 | Fairwind | ¤ 2,200.00 | 4.0 | false | 10 | ||
5 | 4 | Black Beards Cruises | Nassau | Bahamas | 4/30/15 | Fairwind | ¤ 2,400.00 | 4.0 | false | 11 | ||
6 | 5 | Grand Bahama Island | Nassau | Bahamas | 12/15/16 | Fairwind | ¤ 2,000.00 | 3.0 | true | 15 | ||
7 | 6 | Ambergris Caye | Belize City | Belize | 4/25/17 | Sun Breeze | ¤ 4,000.00 | 4.0 | false | 7 | ||
8 | 6 | Ambergris Caye | Belize City | Belize | 4/24/17 | Sun Breeze | ¤ 4,100.00 | 4.0 | false | 6 | ||
9 | 8 | South Shore | Kralendijk | Bonaire | 10/1/16 | Pink Flamingo | ¤ 3,900.00 | 4.0 | false | 4 | ||
10 | 9 | South Shore | Kralendijk | Bonaire | 6/19/17 | Sea Star | ¤ 3,600.00 | 4.0 | false | 5 | ||
11 | 8 | South Shore | Kralendijk | Bonaire | 10/2/16 | Pink Flamingo | ¤ 3,500.00 | 5.0 | false | 10 | Overall, the trip was fantastic! The diving was absolutely spectacular! Some of our favorite sites are: Alice in Wonderland, Andrea II, and Pink Beach. Weather: We went October 9-16. This is their rainy season, but it only rained one day and didn't stop us from diving. Otherwise, it was partly cloudy to mostly sunny (bring sunscreen!) and the temperature was 85-90 degrees every day. There's always a nice breeze and the evenings cooled off really nice. Very comfortable. | |
12 | 9 | South Shore | Kralendijk | Bonaire | 6/20/17 | Sea Star | ¤ 3,400.00 | 5.0 | false | 12 | Three great dives today. Bari Reef, Salt Pier, and back to Bari for a REALLY late-night dive. The Salt Pier was exciting for us as we missed this dive the last time we were here. Dinner tonight was at Richards. Beautiful place! | |
13 | 10 | South Shore | Kralendijk | Bonaire | 3/29/17 | Sea Star | ¤ 4,600.00 | 5.0 | false | 13 | Oooh, Bonaire is a great place to be if you like relaxed vacations. You don't have to worry about boats leaving without you, or times of departure. You just hire a pick-up and off you go. Almost every dive site at the coastline, you can do a shore dive. This really is great and relaxing. | |
14 | 10 | South Shore | Kralendijk | Bonaire | 5/18/16 | Pink Flamingo | ¤ 3,500.00 | 4.0 | false | 5 | ||
15 | 8 | South Shore | Kralendijk | Bonaire | 10/20/15 | Sea Star | ¤ 3,700.00 | 3.0 | false | 6 | ||
16 | 7 | Fernando de Noronha | Pernambuco | Brazil | 4/12/17 | Port Arrowhead | ¤ 4,900.00 | 3.0 | false | 3 | ||
17 | 7 | Fernando de Noronha | Pernambuco | Brazil | 8/3/17 | Port Arrowhead | ¤ 5,100.00 | 3.0 | false | 7 | ||
18 | 7 | Angra dos Reis | Rio de Janeiro | Brazil | 3/19/16 | Sunset City | ¤ 5,200.00 | 3.0 | false | 8 | ||
19 | 7 | Arraial do Cabo | Rio de Janeiro | Brazil | 4/2/17 | Sunset City | ¤ 5,200.00 | 4.0 | false | 10 | ||
20 | 6 | Arraial do Cabo | Rio de Janeiro | Brazil | 2/24/17 | Sunset City | ¤ 4,500.00 | 4.0 | false | 11 | ||
21 | 1 | Grand Cayman | George Town | Cayman Islands | 5/11/16 | Diving Lodge | ¤ 3,300.00 | 4.0 | false | 13 | ||
22 | 2 | Grand Cayman | George Town | Cayman Islands | 4/27/15 | Diving Lodge | ¤ 3,200.00 | 5.0 | false | 12 | This has been the best vacation we have taken. The most relaxing and great diving. | |
23 | 3 | Grand Cayman | George Town | Cayman Islands | 8/31/16 | Diving Lodge | ¤ 3,300.00 | 5.0 | false | 11 | As always, this trip to Cayman was great. The weather was good. The guests were great. | |
24 | 1 | Grand Cayman | George Town | Cayman Islands | 8/31/16 | Diving Lodge | ¤ 3,100.00 | 5.0 | false | 10 | This was our third trip to Grand Cayman, our second time with Cayman Diving Lodge. The day we went to Stingray City, we did two dives on the way there, had lunch on the boat, then dove Stingray City. The fish were abundant--many Parrotfish, Blennys (those guys are so cute!), Butterflyfish, Jacks, Tarpon, Snappers, Triggerfish, Spotted Drums Jawfish, and several Barracuda, Filefish, Flyingfish, Groupers, Hogfish, Morays, Scorpionfish, and Turtles. The highlights of this trip were the Turtles, Nurse Sharks, and Octopi. The night dives we did were filled with cool creatures. We saw Green Moray Eels, Sharptail Eels, Spotted Moray Eels (one so small that its head was about the size of a dime), Porcupinefish, Slipper Lobster, and Octopi. | |
25 | 1 | Grand Cayman | George Town | Cayman Islands | 5/10/17 | Sunset Hotel | ¤ 3,000.00 | 4.0 | false | 16 | ||
26 | 2 | Grand Cayman | George Town | Cayman Islands | 9/23/17 | Sunset Hotel | ¤ 3,100.00 | 4.0 | false | 8 | ||
27 | 5 | West Shore | Havana | Cuba | 1/22/15 | Copa Cabana | ¤ 2,900.00 | 3.0 | true | 7 | ||
28 | 3 | East Shore | Willemstad | Curacao | 7/2/16 | Prince Resort | ¤ 3,250.00 | 5.0 | false | 6 | ||
29 | 3 | East Shore | Willemstad | Curacao | 1/22/15 | Prince Resort | ¤ 3,300.00 | 4.0 | false | 6 | ||
30 | 4 | Big Island | Willemstad | Curacao | 5/6/17 | Prince Resort | ¤ 7,000.00 | 4.0 | false | 10 | ||
31 | 5 | Summer Lake | Hurghada | Egypt | 9/9/16 | Ramada Inn | ¤ 7,500.00 | 3.0 | true | 10 | ||
32 | 5 | Winter Lake | Sharm El Naga | Egypt | 9/30/16 | Sala Dive Center | ¤ 7,400.00 | 3.0 | true | 9 | ||
33 | 5 | Winter Lake | Sharm El Sheikh | Egypt | 9/29/15 | Rosada Dive Center | ¤ 8,300.00 | 3.0 | false | 8 | ||
34 | 5 | Winter Lake | Sharm El Sheikh | Egypt | 7/10/17 | Rosada Dive Center | ¤ 6,000.00 | 3.0 | false | 6 | ||
35 | 6 | Two Islands | Nadi | Fiji | 3/17/15 | Coco Bay Resort | ¤ 6,200.00 | 4.0 | false | 8 | ||
36 | 6 | Two Islands | Nadi | Fiji | 3/18/15 | Coco Bay Resort | ¤ 6,300.00 | 4.0 | false | 10 | ||
37 | 4 | Sunset Reef | Roatan | Honduras | 3/9/17 | Tony's Resort | ¤ 5,200.00 | 5.0 | true | 12 | ||
38 | 1 | Sunset Reef | Roatan | Honduras | 3/9/17 | Tony's Resort | ¤ 5,300.00 | 3.0 | false | 13 | ||
39 | 3 | Sunset Reef | Roatan | Honduras | 3/9/17 | Lover's Bay Resort | ¤ 5,400.00 | 4.0 | false | 11 | ||
40 | 3 | Sunset Reef | Roatan | Honduras | 10/14/17 | Lover's Bay Resort | ¤ 5,500.00 | 4.0 | false | 10 | ||
41 | 4 | Sunset Reef | Roatan | Honduras | 5/6/17 | Lover's Bay Resort | ¤ 5,000.00 | 3.0 | false | 8 | ||
42 | 2 | Tree of Life Lake | Eilat | Israel | 3/9/17 | Kibbutz Dive | ¤ 8,700.00 | 4.0 | false | 7 | ||
43 | 1 | North Shore | Montego Bay | Jamaica | 3/4/16 | Village Sand | ¤ 4,500.00 | 3.0 | false | 8 | ||
44 | 2 | Flaming Reef | Cabo San Lucas | Mexico | 4/28/16 | Village by the Sea | ¤ 3,000.00 | 4.0 | false | 8 | ||
45 | 2 | Flaming Reef | Cabo San Lucas | Mexico | 5/7/16 | Village by the Sea | ¤ 3,200.00 | 3.0 | false | 9 | ||
46 | 2 | Flaming Reef | Cabo San Lucas | Mexico | 4/29/16 | Village by the Sea | ¤ 3,100.00 | 3.0 | false | 10 | ||
47 | 3 | Gold Shore | Cancun | Mexico | 10/8/17 | Hyatt Sands | ¤ 3,300.00 | 4.0 | false | 12 | ||
48 | 4 | Gold Shore | Cancun | Mexico | 8/28/17 | Hyatt Sands | ¤ 3,400.00 | 4.0 | false | 12 | ||
49 | 5 | Columbia Shallows | Cozumel | Mexico | 3/4/15 | Westin Del Mar | ¤ 3,350.00 | 3.0 | false | 14 | ||
50 | 5 | Columbia Shallows | Cozumel | Mexico | 2/8/16 | Westin Del Mar | ¤ 3,600.00 | 3.0 | false | 10 | ||
51 | 5 | Columbia Shallows | Cozumel | Mexico | 2/6/16 | Westin Del Mar | ¤ 3,200.00 | 3.0 | false | 9 | ||
52 | 6 | Columbia Shallows | Cozumel | Mexico | 2/5/17 | Atempo Resort | ¤ 3,580.00 | 3.0 | false | 8 | ||
53 | 6 | Columbia Shallows | Cozumel | Mexico | 4/27/17 | Atempo Resort | ¤ 3,500.00 | 3.0 | false | 7 | ||
54 | 7 | Columbia Shallows | Cozumel | Mexico | 8/23/15 | Atempo Resort | ¤ 3,700.00 | 3.0 | false | 10 | ||
55 | 7 | Columbia Shallows | Cozumel | Mexico | 8/22/15 | Atempo Resort | ¤ 4,100.00 | 3.0 | false | 9 | ||
56 | 8 | Columbia Shallows | Cozumel | Mexico | 3/4/16 | Royal Seas | ¤ 4,100.00 | 3.0 | false | 8 | ||
57 | 9 | Columbia Shallows | Cozumel | Mexico | 3/5/16 | Royal Seas | ¤ 4,200.00 | 3.0 | false | 7 | ||
58 | 10 | Columbia Shallows | Cozumel | Mexico | 2/2/17 | Royal Seas | ¤ 4,300.00 | 3.0 | false | 5 | ||
59 | 10 | Columbia Shallows | Cozumel | Mexico | 2/3/17 | Royal Seas | ¤ 4,400.00 | 4.0 | false | 10 | ||
60 | 5 | Columbia Shallows | Cozumel | Mexico | 2/7/16 | Scuba South Resort | ¤ 4,200.00 | 4.0 | false | 4 | ||
61 | 6 | Columbia Shallows | Cozumel | Mexico | 4/26/17 | Scuba South Resort | ¤ 4,100.00 | 4.0 | false | 7 | ||
62 | 7 | Columbia Shallows | Cozumel | Mexico | 8/23/16 | Scuba South Resort | ¤ 3,900.00 | 4.0 | false | 9 | ||
63 | 8 | Columbia Shallows | Cozumel | Mexico | 3/5/16 | Scuba South Resort | ¤ 3,300.00 | 5.0 | false | 9 | ||
64 | 3 | The Reef Club | Cozumel | Mexico | 1/5/17 | Scuba South Resort | ¤ 3,200.00 | 3.0 | false | 10 | ||
65 | 2 | The Reef Club | Cozumel | Mexico | 6/25/15 | Scuba South Resort | ¤ 3,400.00 | 4.0 | false | 11 | ||
66 | 1 | Blue Water Reef | Ixtapa | Mexico | 4/2/15 | Hyatt Ixtapa | ¤ 3,900.00 | 3.0 | false | 12 | ||
67 | 10 | Red Reef | La Bufadora | Mexico | 2/11/17 | 4 Seasons Inn | ¤ 4,280.00 | 3.0 | false | 13 | ||
68 | 5 | Orange Reef | La Paz | Mexico | 8/22/17 | Hotel La Paz | ¤ 5,000.00 | 4.0 | false | 7 | ||
69 | 4 | Cat Eye Reef | Mar de Cortez | Mexico | 9/25/16 | Sweet Seas Resort | ¤ 4,230.00 | 3.0 | false | 8 | ||
70 | 7 | Tiger Reef | San Carlos | Mexico | 3/28/17 | Pedro Hotel | ¤ 4,500.00 | 4.0 | false | 9 | ||
71 | 6 | Manacles Porthkerris | Cornwall | United Kingdom | 4/11/16 | King James Castle | ¤ 7,000.00 | 4.0 | false | 10 | ||
72 | 8 | Porthkerris | Cornwall | United Kingdom | 4/5/15 | King James Castle | ¤ 6,900.00 | 4.0 | false | 10 | ||
73 | 10 | East Shore | St. John | US Virgin Islands | 5/10/15 | Pirates Cove Inn | ¤ 5,000.00 | 3.0 | false | 9 | ||
74 | 8 | Twin Grand Rivers | Ketchikan | AK | USA | 5/13/17 | Timberwolf Lodge | ¤ 3,000.00 | 4.0 | false | 8 | |
75 | 6 | Frog Reef | Catalina Island | CA | USA | 8/21/17 | Marriott Catalina | ¤ 2,400.00 | 3.0 | true | 7 | |
76 | 6 | Frog Reef | Catalina Island | CA | USA | 8/23/15 | Marriott Catalina | ¤ 2,300.00 | 3.0 | true | 10 | |
77 | 4 | Frog Reef | Catalina Island | CA | USA | 3/9/16 | Marriott Catalina | ¤ 2,400.00 | 4.0 | false | 10 | |
78 | 4 | Frog Reef | Catalina Island | CA | USA | 1/8/17 | Hotel California | ¤ 2,500.00 | 3.0 | false | 10 | |
79 | 2 | Daves Reef | San Clemente | CA | USA | 5/11/15 | Galleon Resort | ¤ 2,600.00 | 3.0 | false | 11 | |
80 | 2 | Daves Reef | San Clemente | CA | USA | 5/10/15 | Galleon Resort | ¤ 2,800.00 | 2.0 | true | 11 | |
81 | 1 | Little Reef | Clearwater | FL | USA | 7/22/16 | Tropicana Inn | ¤ 2,900.00 | 3.0 | false | 7 | |
82 | 3 | Little Reef | Clearwater | FL | USA | 6/8/15 | Tropicana Inn | ¤ 3,000.00 | 1.0 | true | 8 | |
83 | 5 | Manatee Island | Crystal River | FL | USA | 10/18/17 | Westin Manatee | ¤ 2,500.00 | 4.0 | false | 9 | |
84 | 9 | Indian Reef | Key Largo | FL | USA | 3/5/15 | Key Largo Inn | ¤ 2,400.00 | 3.0 | false | 9 | |
85 | 7 | Indian Reef | Key Largo | FL | USA | 4/30/17 | Key Largo Inn | ¤ 2,200.00 | 2.0 | false | 10 | |
86 | 8 | Indian Reef | Key Largo | FL | USA | 7/16/17 | Best Western Key Largo | ¤ 2,300.00 | 3.0 | false | 12 | |
87 | 9 | Blue State Park | Key West | FL | USA | 11/18/16 | Westin Key West | ¤ 1,000.00 | 3.0 | false | 13 | |
88 | 10 | Blue State Park | Key West | FL | USA | 12/15/17 | Hyatt Sunset Harbor | ¤ 1,400.00 | 2.0 | false | 11 | |
89 | 5 | Dragon Park | Lake City | FL | USA | 1/12/16 | Sheraton 4 Seasons | ¤ 1,500.00 | 3.0 | false | 10 | |
90 | 4 | Dragon Park | Lake City | FL | USA | 2/23/16 | Spruce Inn | ¤ 1,600.00 | 3.0 | false | 8 | |
91 | 3 | Tree Island | Panama City | FL | USA | 8/19/17 | Iota Key Resort | ¤ 1,320.00 | 3.0 | false | 7 | |
92 | 3 | Tree Island | Panama City | FL | USA | 12/24/17 | Panama City Resort | ¤ 1,200.00 | 3.0 | false | 8 | |
93 | 2 | Salt Island | Ramrod Key | FL | USA | 7/3/17 | Lighthouse Inn | ¤ 1,400.00 | 2.0 | false | 8 | |
94 | 1 | Lobster Island | Tavernier | FL | USA | 10/7/16 | Pirates Ahoy Hotel | ¤ 1,500.00 | 1.0 | false | 9 | |
95 | 3 | Fish House | West Palm Beach | FL | USA | 4/21/15 | Motel 8 West Palm | ¤ 1,400.00 | 2.0 | false | 10 | |
96 | 5 | Fish House | West Palm Beach | FL | USA | 3/10/15 | Holiday Inn West | ¤ 1,500.00 | 3.0 | false | 12 | |
97 | 7 | Fish House | West Palm Beach | FL | USA | 3/24/15 | Holiday Inn West | ¤ 1,800.00 | 3.0 | false | 12 | |
98 | 9 | Fish House | West Palm Beach | FL | USA | 7/29/15 | Westin Beach House | ¤ 2,200.00 | 3.0 | false | 14 | |
99 | 10 | Molokini Crater | Molokai | HI | USA | 3/9/17 | Grand Beach Resort | ¤ 4,500.00 | 3.0 | false | 10 | |
100 | 5 | Molokini Crater | Molokai | HI | USA | 3/9/17 | Grand Beach Resort | ¤ 4,600.00 | 4.0 | false | 9 | |
101 | 3 | Molokini Crater | Molokai | HI | USA | 11/13/15 | Grand Beach Resort | ¤ 4,900.00 | 4.0 | false | 8 | |
102 | 4 | Molokini Crater | Molokai | HI | USA | 8/9/17 | Sand and Surf Resort | ¤ 5,200.00 | 4.0 | false | 7 | |
103 | 4 | Molokini Crater | Molokai | HI | USA | 8/10/17 | Sand and Surf Resort | ¤ 5,250.00 | 5.0 | false | 10 | |
104 | 5 | South Maui Island | Maui | HI | USA | 8/9/17 | Hyatt Maui | ¤ 5,260.00 | 4.0 | false | 9 | |
105 | 6 | Molokini Crater | Molokai | HI | USA | 8/7/17 | Sand and Surf Resort | ¤ 5,270.00 | 4.0 | false | 8 | |
106 | 4 | Spurgeon Lake | Grand Springs | IL | USA | 5/13/15 | Holiday Inn Mermet | ¤ 2,900.00 | 2.0 | true | 7 | |
107 | 4 | Spurgeon Lake | Grand Springs | IL | USA | 5/14/15 | Holiday Inn Mermet | ¤ 2,500.00 | 3.0 | true | 5 | |
108 | 4 | Spurgeon Lake | Grand Springs | IL | USA | 5/15/15 | Red Roof Inn | ¤ 2,600.00 | 3.0 | true | 10 | |
109 | 2 | Bass Lake | Logansport | IN | USA | 10/29/15 | Logan's Point Hotel | ¤ 2,800.00 | 3.0 | true | 12 | |
110 | 2 | Bass Lake | Logansport | IN | USA | 10/30/15 | Logan's Point Hotel | ¤ 2,900.00 | 4.0 | true | 13 | |
111 | 10 | Sawfish Lake | Rockport | MA | USA | 10/24/15 | Rock Lodge | ¤ 3,500.00 | 3.0 | true | 14 | |
112 | 7 | Mark Twain Lake | Bonne Terre | MO | USA | 7/25/15 | Lucky 13 Lodge | ¤ 2,890.00 | 4.0 | true | 8 | |
113 | 7 | Mark Twain Lake | Bonne Terre | MO | USA | 7/26/15 | Lucky 13 Lodge | ¤ 2,290.00 | 4.0 | true | 9 | |
114 | 7 | Table Rock Lake | Branson | MO | USA | 7/13/16 | Big Cedar Lodge | ¤ 2,690.00 | 3.0 | true | 8 | |
115 | 10 | Delaware Water Gap | Manasquan | NJ | USA | 8/11/16 | La Quinta Inn | ¤ 2,700.00 | 1.0 | true | 10 | |
116 | 10 | Delaware Water Gap | Manasquan | NJ | USA | 8/12/16 | La Quinta Inn | ¤ 2,750.00 | 2.0 | true | 12 | |
117 | 1 | Pontiac Reserve | Santa Rosa | NM | USA | 9/28/16 | Ramada Inn | ¤ 2,800.00 | 2.0 | false | 13 | |
118 | 2 | Gilboa Quarry | Ottawa | OH | USA | 6/19/16 | Marriott Ottawa | ¤ 2,850.00 | 3.0 | false | 11 | |
119 | 2 | Shawnee River | Portage | OH | USA | 6/23/17 | Marriott Portage | ¤ 3,150.00 | 3.0 | false | 10 | |
120 | 2 | Racoon Quarry | Bethlehem | PA | USA | 7/29/17 | Red Roof Inn | ¤ 3,170.00 | 3.0 | false | 8 | |
121 | 2 | Racoon Quarry | Bethlehem | PA | USA | 7/28/17 | Red Roof Inn | ¤ 3,250.00 | 3.0 | false | 7 | |
122 | 2 | Red River | Dingman's Ferry | PA | USA | 9/2/17 | Hotel 6 | ¤ 3,350.00 | 3.0 | true | 8 | |
123 | 2 | Green River | Dutch Springs | PA | USA | 7/11/17 | Super 8 | ¤ 3,220.00 | 3.0 | true | 8 | |
124 | 2 | Large Island | Lake Erie | PA | USA | 9/2/15 | Holiday Inn Lake Erie | ¤ 2,875.00 | 3.0 | false | 9 | |
125 | 8 | Outpost Island | Charleston | SC | USA | 11/4/15 | Fairfield Inn Charleston | ¤ 2,870.00 | 4.0 | false | 10 | |
126 | 9 | Turtle Island | Myrtle Beach | SC | USA | 9/16/17 | Super 8 | ¤ 2,200.00 | 4.0 | false | 12 | |
127 | 8 | Turtle Island | Myrtle Beach | SC | USA | 9/20/16 | Super 8 | ¤ 2,200.00 | 3.0 | false | 12 | |
128 | 9 | Snake Island | Tyler | TX | USA | 6/2/17 | Hotel 6 | ¤ 1,500.00 | 1.0 | false | 14 | |
129 | 4 | Devil's Lake | Baraboo | WI | USA | 5/8/15 | Holiday Inn Baraboo | ¤ 1,400.00 | 2.0 | true | 10 |
SELECT DISTINCTROW *
FROM DiveTrips;
SELECT DISTINCTROW *
FROM DiveTrips;
SELECT DISTINCTROW *
FROM DiveTrips;
SELECT DISTINCTROW *
FROM DiveMasters;
SELECT [DiveMasters].[LName], [DiveTrips].[Location], [DiveTrips].[City], [DiveTrips].[State], [DiveTrips].[Country], [DiveTrips].[StartDate], [DiveTrips].[Rating], [DiveTrips].[Participants], [DiveMasters].[DiveMasterID]
FROM DiveMasters INNER JOIN DiveTrips ON [DiveMasters].[DiveMasterID] =[DiveTrips].[DiveMasterID];
SELECT Countries.CountryName
FROM Countries
ORDER BY Countries.CountryName;
SELECT Divemasters.LName, Divemasters.PhoneNumber, Divemasters.Birthday
FROM Divemasters
ORDER BY Divemasters.LName;
SELECT Divemasters.LName
FROM Divemasters
ORDER BY Divemasters.LName;
SELECT DiveTrips.Location, DiveTrips.Country, DiveTrips.State, DiveTrips.City, DiveTrips.StartDate
FROM DiveTrips;
SELECT DiveTrips.ID, Divemasters.LName, DiveTrips.City, DiveTrips.Country, DiveTrips.StartDate, DiveTrips.Rating, DiveTrips.Participants
FROM Divemasters INNER JOIN DiveTrips ON Divemasters.DiveMasterID = DiveTrips.DiveMasterID;
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 Divemasters.LName, DiveTrips.Participants
FROM Divemasters INNER JOIN DiveTrips ON Divemasters.DiveMasterID = DiveTrips.DiveMasterID;
SELECT DiveTrips.Location, DiveTrips.City, DiveTrips.Country, DiveTrips.StartDate, DiveTrips.TripPrice
FROM DiveTrips;
SELECT DiveTrips.Location, DiveTrips.Country, DiveTrips.State, DiveTrips.City, DiveTrips.StartDate
FROM DiveTrips
WHERE (((DiveTrips.Country)="USA"));