Exp19_Access_Ch09_CapAssessment_National_Farm_and_Agriculture_Conference
lacey.xyY
Blake_Exp19_Access_Ch09_CapAssessment_National_Farm_and_Agriculture_Conference.accdb| PresenterID | ExhibitID | mSysRowId |
|---|---|---|
| 1 | 1 | 6ffJ5l/CK9ST6CG29YijzlOI6sdJQ3gTj3/qx0o0dVQ=-~iFK+TNYt8NGPy4SLQe71tw== |
| 1 | 4 | 6ffJ5l/CK9ST6CG29YijzlOI6sdJQ3gTj3/qx0o0dVQ=-~iFK+TNYt8NGPy4SLQe71tw== |
| 1 | 9 | 6ffJ5l/CK9ST6CG29YijzlOI6sdJQ3gTj3/qx0o0dVQ=-~iFK+TNYt8NGPy4SLQe71tw== |
| 1 | 10 | 6ffJ5l/CK9ST6CG29YijzlOI6sdJQ3gTj3/qx0o0dVQ=-~iFK+TNYt8NGPy4SLQe71tw== |
| 1 | 13 | 6ffJ5l/CK9ST6CG29YijzlOI6sdJQ3gTj3/qx0o0dVQ=-~iFK+TNYt8NGPy4SLQe71tw== |
| 1 | 14 | 6ffJ5l/CK9ST6CG29YijzlOI6sdJQ3gTj3/qx0o0dVQ=-~iFK+TNYt8NGPy4SLQe71tw== |
| 2 | 1 | 6ffJ5l/CK9ST6CG29YijzlOI6sdJQ3gTj3/qx0o0dVQ=-~iFK+TNYt8NGPy4SLQe71tw== |
| 3 | 2 | 6ffJ5l/CK9ST6CG29YijzlOI6sdJQ3gTj3/qx0o0dVQ=-~iFK+TNYt8NGPy4SLQe71tw== |
| 3 | 6 | 6ffJ5l/CK9ST6CG29YijzlOI6sdJQ3gTj3/qx0o0dVQ=-~iFK+TNYt8NGPy4SLQe71tw== |
| 3 | 9 | 6ffJ5l/CK9ST6CG29YijzlOI6sdJQ3gTj3/qx0o0dVQ=-~iFK+TNYt8NGPy4SLQe71tw== |
| 4 | 9 | 6ffJ5l/CK9ST6CG29YijzlOI6sdJQ3gTj3/qx0o0dVQ=-~iFK+TNYt8NGPy4SLQe71tw== |
| 4 | 12 | 6ffJ5l/CK9ST6CG29YijzlOI6sdJQ3gTj3/qx0o0dVQ=-~iFK+TNYt8NGPy4SLQe71tw== |
| 5 | 2 | 6ffJ5l/CK9ST6CG29YijzlOI6sdJQ3gTj3/qx0o0dVQ=-~iFK+TNYt8NGPy4SLQe71tw== |
| 5 | 7 | 6ffJ5l/CK9ST6CG29YijzlOI6sdJQ3gTj3/qx0o0dVQ=-~iFK+TNYt8NGPy4SLQe71tw== |
| 5 | 13 | 6ffJ5l/CK9ST6CG29YijzlOI6sdJQ3gTj3/qx0o0dVQ=-~iFK+TNYt8NGPy4SLQe71tw== |
| 6 | 6 | 6ffJ5l/CK9ST6CG29YijzlOI6sdJQ3gTj3/qx0o0dVQ=-~iFK+TNYt8NGPy4SLQe71tw== |
| 7 | 2 | 6ffJ5l/CK9ST6CG29YijzlOI6sdJQ3gTj3/qx0o0dVQ=-~iFK+TNYt8NGPy4SLQe71tw== |
| 7 | 3 | 6ffJ5l/CK9ST6CG29YijzlOI6sdJQ3gTj3/qx0o0dVQ=-~iFK+TNYt8NGPy4SLQe71tw== |
| 7 | 8 | 6ffJ5l/CK9ST6CG29YijzlOI6sdJQ3gTj3/qx0o0dVQ=-~iFK+TNYt8NGPy4SLQe71tw== |
| 7 | 12 | 6ffJ5l/CK9ST6CG29YijzlOI6sdJQ3gTj3/qx0o0dVQ=-~iFK+TNYt8NGPy4SLQe71tw== |
| 8 | 9 | 6ffJ5l/CK9ST6CG29YijzlOI6sdJQ3gTj3/qx0o0dVQ=-~iFK+TNYt8NGPy4SLQe71tw== |
| 8 | 10 | 6ffJ5l/CK9ST6CG29YijzlOI6sdJQ3gTj3/qx0o0dVQ=-~iFK+TNYt8NGPy4SLQe71tw== |
| 9 | 13 | 6ffJ5l/CK9ST6CG29YijzlOI6sdJQ3gTj3/qx0o0dVQ=-~iFK+TNYt8NGPy4SLQe71tw== |
| 10 | 5 | 6ffJ5l/CK9ST6CG29YijzlOI6sdJQ3gTj3/qx0o0dVQ=-~iFK+TNYt8NGPy4SLQe71tw== |
| 10 | 8 | 6ffJ5l/CK9ST6CG29YijzlOI6sdJQ3gTj3/qx0o0dVQ=-~iFK+TNYt8NGPy4SLQe71tw== |
| 10 | 11 | 6ffJ5l/CK9ST6CG29YijzlOI6sdJQ3gTj3/qx0o0dVQ=-~iFK+TNYt8NGPy4SLQe71tw== |
| 11 | 2 | 6ffJ5l/CK9ST6CG29YijzlOI6sdJQ3gTj3/qx0o0dVQ=-~iFK+TNYt8NGPy4SLQe71tw== |
| 12 | 6 | 6ffJ5l/CK9ST6CG29YijzlOI6sdJQ3gTj3/qx0o0dVQ=-~iFK+TNYt8NGPy4SLQe71tw== |
| 13 | 2 | 6ffJ5l/CK9ST6CG29YijzlOI6sdJQ3gTj3/qx0o0dVQ=-~iFK+TNYt8NGPy4SLQe71tw== |
| 13 | 7 | 6ffJ5l/CK9ST6CG29YijzlOI6sdJQ3gTj3/qx0o0dVQ=-~iFK+TNYt8NGPy4SLQe71tw== |
| 13 | 9 | 6ffJ5l/CK9ST6CG29YijzlOI6sdJQ3gTj3/qx0o0dVQ=-~iFK+TNYt8NGPy4SLQe71tw== |
| ExhibitID | ExhibitTitle | LocationID | Date | StartingTime | mSysRowId |
|---|---|---|---|---|---|
| 1 | Skills Competition I | 101 | 2020-10-01 | 1899-12-30 | W836ga5XnYplCOKjnnm7J2smt5lZvbalsb+7IJNo1hI=-~+Lyx5VA4G1ebA5MJGqsImg== |
| 2 | Rabbit Show | 103 | 2020-10-01 | 1899-12-30 | W836ga5XnYplCOKjnnm7J2smt5lZvbalsb+7IJNo1hI=-~+Lyx5VA4G1ebA5MJGqsImg== |
| 3 | Dairy Show | 104 | 2020-10-01 | 1899-12-30 | W836ga5XnYplCOKjnnm7J2smt5lZvbalsb+7IJNo1hI=-~+Lyx5VA4G1ebA5MJGqsImg== |
| 4 | Sheep and Goat Show | 101 | 2020-10-01 | 1899-12-30 | W836ga5XnYplCOKjnnm7J2smt5lZvbalsb+7IJNo1hI=-~+Lyx5VA4G1ebA5MJGqsImg== |
| 5 | Swine Show | 101 | 2020-10-02 | 1899-12-30 | W836ga5XnYplCOKjnnm7J2smt5lZvbalsb+7IJNo1hI=-~+Lyx5VA4G1ebA5MJGqsImg== |
| 6 | Vegetable Exhibit | 102 | 2020-10-02 | 1899-12-30 | W836ga5XnYplCOKjnnm7J2smt5lZvbalsb+7IJNo1hI=-~+Lyx5VA4G1ebA5MJGqsImg== |
| 7 | Breeding Techniques | 105 | 2020-10-02 | 1899-12-30 | W836ga5XnYplCOKjnnm7J2smt5lZvbalsb+7IJNo1hI=-~+Lyx5VA4G1ebA5MJGqsImg== |
| 8 | Virtual Garden Tour | 105 | 2020-10-02 | 1899-12-30 | W836ga5XnYplCOKjnnm7J2smt5lZvbalsb+7IJNo1hI=-~+Lyx5VA4G1ebA5MJGqsImg== |
| 9 | Horticulture | 104 | 2020-10-02 | 1899-12-30 | W836ga5XnYplCOKjnnm7J2smt5lZvbalsb+7IJNo1hI=-~+Lyx5VA4G1ebA5MJGqsImg== |
| 10 | Recruiting for Your Chapter | 102 | 2020-10-03 | 1899-12-30 | W836ga5XnYplCOKjnnm7J2smt5lZvbalsb+7IJNo1hI=-~+Lyx5VA4G1ebA5MJGqsImg== |
| 11 | Herb Exhibit | 103 | 2020-10-03 | 1899-12-30 | W836ga5XnYplCOKjnnm7J2smt5lZvbalsb+7IJNo1hI=-~+Lyx5VA4G1ebA5MJGqsImg== |
| 12 | Skills Competition II | 101 | 2020-10-03 | 1899-12-30 | W836ga5XnYplCOKjnnm7J2smt5lZvbalsb+7IJNo1hI=-~+Lyx5VA4G1ebA5MJGqsImg== |
| 13 | Basic Animal First Aid | 104 | 2020-10-03 | 1899-12-30 | W836ga5XnYplCOKjnnm7J2smt5lZvbalsb+7IJNo1hI=-~+Lyx5VA4G1ebA5MJGqsImg== |
| 14 | Volunteer Opportunities | 101 | 2020-10-03 | 1899-12-30 | W836ga5XnYplCOKjnnm7J2smt5lZvbalsb+7IJNo1hI=-~+Lyx5VA4G1ebA5MJGqsImg== |
| LocationID | Capacity | Outdoors | Refreshments | Notes | mSysRowId |
|---|---|---|---|---|---|
| 101 | 125 | true | false | Main stage | bLcOY1PhT2hCQWQbN7pDpKEb876HfVz0VQx8+zsDQpI=-~XT6jtlUlQZf1wAr9l3009Q== |
| 102 | 75 | true | true | bLcOY1PhT2hCQWQbN7pDpKEb876HfVz0VQx8+zsDQpI=-~XT6jtlUlQZf1wAr9l3009Q== | |
| 103 | 65 | true | true | bLcOY1PhT2hCQWQbN7pDpKEb876HfVz0VQx8+zsDQpI=-~XT6jtlUlQZf1wAr9l3009Q== | |
| 104 | 35 | true | false | Small display outside the main office | bLcOY1PhT2hCQWQbN7pDpKEb876HfVz0VQx8+zsDQpI=-~XT6jtlUlQZf1wAr9l3009Q== |
| 105 | 75 | false | true | bLcOY1PhT2hCQWQbN7pDpKEb876HfVz0VQx8+zsDQpI=-~XT6jtlUlQZf1wAr9l3009Q== | |
| 106 | 75 | true | true | bLcOY1PhT2hCQWQbN7pDpKEb876HfVz0VQx8+zsDQpI=-~XT6jtlUlQZf1wAr9l3009Q== | |
| 107 | 35 | true | true | bLcOY1PhT2hCQWQbN7pDpKEb876HfVz0VQx8+zsDQpI=-~XT6jtlUlQZf1wAr9l3009Q== |
| ID | mSysRowId |
|---|---|
| 1 | LqRzdDJMB9y2d/mlgcyLeP0RCx302oUZf9b0LdjiDhM=-~Sr301AAsgeli9Ky7XK5YPw== |
| PresenterID | FirstName | LastName | Address | City | State | ZipCode | mSysRowId |
|---|---|---|---|---|---|---|---|
| 1 | Brent | Garrett | 368 Graham Avenue | Graham | KY | 42344 | DeRRoBSGa5ypvOo6N+ajoZSdP2DvHOMPaViIb7AaoUo=-~EUcvvKb8bmPnK0Jq2A5Jdg== |
| 2 | Gloria | Sandoval | 139 Park Avenue | Benton | IL | 62812 | DeRRoBSGa5ypvOo6N+ajoZSdP2DvHOMPaViIb7AaoUo=-~EUcvvKb8bmPnK0Jq2A5Jdg== |
| 3 | Faye | Ramirez | 182 Route 20 | Monroe | LA | 71207 | DeRRoBSGa5ypvOo6N+ajoZSdP2DvHOMPaViIb7AaoUo=-~EUcvvKb8bmPnK0Jq2A5Jdg== |
| 4 | Olga | Taylor | 122 East 24th Street | Guys | TN | 38339 | DeRRoBSGa5ypvOo6N+ajoZSdP2DvHOMPaViIb7AaoUo=-~EUcvvKb8bmPnK0Jq2A5Jdg== |
| 5 | Emanuel | Chavez | 244 Curtis Place | Harrisburg | PA | 17128 | DeRRoBSGa5ypvOo6N+ajoZSdP2DvHOMPaViIb7AaoUo=-~EUcvvKb8bmPnK0Jq2A5Jdg== |
| 6 | Sheri | Williamson | 100 20th Avenue | Waynesburg | KY | 40489 | DeRRoBSGa5ypvOo6N+ajoZSdP2DvHOMPaViIb7AaoUo=-~EUcvvKb8bmPnK0Jq2A5Jdg== |
| 7 | Irma | Ferguson | 262 Graham Avenue | Stem | NC | 27581 | DeRRoBSGa5ypvOo6N+ajoZSdP2DvHOMPaViIb7AaoUo=-~EUcvvKb8bmPnK0Jq2A5Jdg== |
| 8 | Darin | Clayton | 355 Curtis Place | Fort Totten | ND | 58335 | DeRRoBSGa5ypvOo6N+ajoZSdP2DvHOMPaViIb7AaoUo=-~EUcvvKb8bmPnK0Jq2A5Jdg== |
| 9 | Andre | Gilbert | 372 East 21st Street | Bayamon | PR | 00958 | DeRRoBSGa5ypvOo6N+ajoZSdP2DvHOMPaViIb7AaoUo=-~EUcvvKb8bmPnK0Jq2A5Jdg== |
| 10 | Billie | Barnett | 360 Graham Avenue | Higden | AR | 72067 | DeRRoBSGa5ypvOo6N+ajoZSdP2DvHOMPaViIb7AaoUo=-~EUcvvKb8bmPnK0Jq2A5Jdg== |
| 11 | Rudolph | Cooper | 15 Ryle Avenue | Radersburg | MT | 59641 | DeRRoBSGa5ypvOo6N+ajoZSdP2DvHOMPaViIb7AaoUo=-~EUcvvKb8bmPnK0Jq2A5Jdg== |
| 12 | Joseph | Hamilton | 253 Main Street | Deer Grove | IL | 61243 | DeRRoBSGa5ypvOo6N+ajoZSdP2DvHOMPaViIb7AaoUo=-~EUcvvKb8bmPnK0Jq2A5Jdg== |
| 13 | Ginger | Silva | 33 Main Street | Willard | UT | 84340 | DeRRoBSGa5ypvOo6N+ajoZSdP2DvHOMPaViIb7AaoUo=-~EUcvvKb8bmPnK0Jq2A5Jdg== |
| 14 | Roger | Hines | 196 Curtis Place | La Mirada | CA | 90637 | DeRRoBSGa5ypvOo6N+ajoZSdP2DvHOMPaViIb7AaoUo=-~EUcvvKb8bmPnK0Jq2A5Jdg== |
| 15 | Jody | Nichols | 44 Montclair Avenue | Bloomington | IL | 61704 | DeRRoBSGa5ypvOo6N+ajoZSdP2DvHOMPaViIb7AaoUo=-~EUcvvKb8bmPnK0Jq2A5Jdg== |
| 16 | Gertrude | Fernandez | 166 Market Street | Peoria | IL | 61641 | DeRRoBSGa5ypvOo6N+ajoZSdP2DvHOMPaViIb7AaoUo=-~EUcvvKb8bmPnK0Jq2A5Jdg== |
| 17 | Florence | Pratt | 10000 SW 59 Court | Lake Norden | SD | 57248 | DeRRoBSGa5ypvOo6N+ajoZSdP2DvHOMPaViIb7AaoUo=-~EUcvvKb8bmPnK0Jq2A5Jdg== |
| ID | FirstName | LastName | Address | City | StateProvince | PostalCode | FeePaid | mSysRowId |
|---|---|---|---|---|---|---|---|---|
| 8 | Tatiana | Toribio | 124 West Windmore Dr | New Fairfield | CT | 6812 | true |
SELECT Presenters.FirstName, Presenters.LastName, Exhibits.ExhibitTitle, Exhibits.LocationID, Exhibits.Date, Exhibits.StartingTime
FROM Presenters INNER JOIN (Exhibits INNER JOIN ExhibitPresenter ON Exhibits.[ExhibitID] = ExhibitPresenter.ExhibitID) ON Presenters.[PresenterID] = ExhibitPresenter.PresenterID;
SELECT DISTINCTROW *
FROM Locations;
SELECT DISTINCTROW *
FROM Presenters;
SELECT Presenters.FirstName, Presenters.LastName, Exhibits.ExhibitTitle, Exhibits.LocationID, Exhibits.Date
FROM Presenters INNER JOIN (Exhibits INNER JOIN ExhibitPresenter ON Exhibits.[ExhibitID] = ExhibitPresenter.ExhibitID) ON Presenters.[PresenterID] = ExhibitPresenter.PresenterID;
