Exp19_Access_Ch4_Cap_Farm.accdb
lacey.xyY
Blake_Exp19_Access_Ch4_Cap_Farm.accdb| PresenterID | ExhibitID | mSysRowId |
|---|---|---|
| 1 | 1 | NqtW9nCzYNt3Edmsr78hwGTT2ZyJUDkgXdV7Y2dQhrk=-~n9Ws2HmIy3jt14fIqLn6JA== |
| 1 | 4 | NqtW9nCzYNt3Edmsr78hwGTT2ZyJUDkgXdV7Y2dQhrk=-~n9Ws2HmIy3jt14fIqLn6JA== |
| 1 | 9 | NqtW9nCzYNt3Edmsr78hwGTT2ZyJUDkgXdV7Y2dQhrk=-~n9Ws2HmIy3jt14fIqLn6JA== |
| 1 | 10 | NqtW9nCzYNt3Edmsr78hwGTT2ZyJUDkgXdV7Y2dQhrk=-~n9Ws2HmIy3jt14fIqLn6JA== |
| 1 | 13 | NqtW9nCzYNt3Edmsr78hwGTT2ZyJUDkgXdV7Y2dQhrk=-~n9Ws2HmIy3jt14fIqLn6JA== |
| 1 | 14 | NqtW9nCzYNt3Edmsr78hwGTT2ZyJUDkgXdV7Y2dQhrk=-~n9Ws2HmIy3jt14fIqLn6JA== |
| 2 | 1 | NqtW9nCzYNt3Edmsr78hwGTT2ZyJUDkgXdV7Y2dQhrk=-~n9Ws2HmIy3jt14fIqLn6JA== |
| 3 | 2 | NqtW9nCzYNt3Edmsr78hwGTT2ZyJUDkgXdV7Y2dQhrk=-~n9Ws2HmIy3jt14fIqLn6JA== |
| 3 | 6 | NqtW9nCzYNt3Edmsr78hwGTT2ZyJUDkgXdV7Y2dQhrk=-~n9Ws2HmIy3jt14fIqLn6JA== |
| 3 | 9 | NqtW9nCzYNt3Edmsr78hwGTT2ZyJUDkgXdV7Y2dQhrk=-~n9Ws2HmIy3jt14fIqLn6JA== |
| 4 | 9 | NqtW9nCzYNt3Edmsr78hwGTT2ZyJUDkgXdV7Y2dQhrk=-~n9Ws2HmIy3jt14fIqLn6JA== |
| 4 | 12 | NqtW9nCzYNt3Edmsr78hwGTT2ZyJUDkgXdV7Y2dQhrk=-~n9Ws2HmIy3jt14fIqLn6JA== |
| 5 | 2 | NqtW9nCzYNt3Edmsr78hwGTT2ZyJUDkgXdV7Y2dQhrk=-~n9Ws2HmIy3jt14fIqLn6JA== |
| 5 | 7 | NqtW9nCzYNt3Edmsr78hwGTT2ZyJUDkgXdV7Y2dQhrk=-~n9Ws2HmIy3jt14fIqLn6JA== |
| 5 | 13 | NqtW9nCzYNt3Edmsr78hwGTT2ZyJUDkgXdV7Y2dQhrk=-~n9Ws2HmIy3jt14fIqLn6JA== |
| 6 | 6 | NqtW9nCzYNt3Edmsr78hwGTT2ZyJUDkgXdV7Y2dQhrk=-~n9Ws2HmIy3jt14fIqLn6JA== |
| 7 | 2 | NqtW9nCzYNt3Edmsr78hwGTT2ZyJUDkgXdV7Y2dQhrk=-~n9Ws2HmIy3jt14fIqLn6JA== |
| 7 | 3 | NqtW9nCzYNt3Edmsr78hwGTT2ZyJUDkgXdV7Y2dQhrk=-~n9Ws2HmIy3jt14fIqLn6JA== |
| 7 | 8 | NqtW9nCzYNt3Edmsr78hwGTT2ZyJUDkgXdV7Y2dQhrk=-~n9Ws2HmIy3jt14fIqLn6JA== |
| 7 | 12 | NqtW9nCzYNt3Edmsr78hwGTT2ZyJUDkgXdV7Y2dQhrk=-~n9Ws2HmIy3jt14fIqLn6JA== |
| 8 | 9 | NqtW9nCzYNt3Edmsr78hwGTT2ZyJUDkgXdV7Y2dQhrk=-~n9Ws2HmIy3jt14fIqLn6JA== |
| 8 | 10 | NqtW9nCzYNt3Edmsr78hwGTT2ZyJUDkgXdV7Y2dQhrk=-~n9Ws2HmIy3jt14fIqLn6JA== |
| 9 | 13 | NqtW9nCzYNt3Edmsr78hwGTT2ZyJUDkgXdV7Y2dQhrk=-~n9Ws2HmIy3jt14fIqLn6JA== |
| 10 | 5 | NqtW9nCzYNt3Edmsr78hwGTT2ZyJUDkgXdV7Y2dQhrk=-~n9Ws2HmIy3jt14fIqLn6JA== |
| 10 | 8 | NqtW9nCzYNt3Edmsr78hwGTT2ZyJUDkgXdV7Y2dQhrk=-~n9Ws2HmIy3jt14fIqLn6JA== |
| 10 | 11 | NqtW9nCzYNt3Edmsr78hwGTT2ZyJUDkgXdV7Y2dQhrk=-~n9Ws2HmIy3jt14fIqLn6JA== |
| 11 | 2 | NqtW9nCzYNt3Edmsr78hwGTT2ZyJUDkgXdV7Y2dQhrk=-~n9Ws2HmIy3jt14fIqLn6JA== |
| 12 | 6 | NqtW9nCzYNt3Edmsr78hwGTT2ZyJUDkgXdV7Y2dQhrk=-~n9Ws2HmIy3jt14fIqLn6JA== |
| 13 | 2 | NqtW9nCzYNt3Edmsr78hwGTT2ZyJUDkgXdV7Y2dQhrk=-~n9Ws2HmIy3jt14fIqLn6JA== |
| 13 | 7 | NqtW9nCzYNt3Edmsr78hwGTT2ZyJUDkgXdV7Y2dQhrk=-~n9Ws2HmIy3jt14fIqLn6JA== |
| 13 | 9 | NqtW9nCzYNt3Edmsr78hwGTT2ZyJUDkgXdV7Y2dQhrk=-~n9Ws2HmIy3jt14fIqLn6JA== |
| ExhibitID | ExhibitTitle | LocationID | Date | StartingTime | mSysRowId |
|---|---|---|---|---|---|
| 1 | Skills Competition I | 101 | 2021-09-01 | 1899-12-30 | rcu4uQD8WD2WVePLUyySJsr3EuPJbLfZRVNEZU/pU6M=-~Z0UYCpwQ/hk80HkI3RCk9A== |
| 2 | Rabbit Show | 103 | 2021-09-01 | 1899-12-30 | rcu4uQD8WD2WVePLUyySJsr3EuPJbLfZRVNEZU/pU6M=-~Z0UYCpwQ/hk80HkI3RCk9A== |
| 3 | Dairy Show | 104 | 2021-09-01 | 1899-12-30 | rcu4uQD8WD2WVePLUyySJsr3EuPJbLfZRVNEZU/pU6M=-~Z0UYCpwQ/hk80HkI3RCk9A== |
| 4 | Sheep and Goat Show | 101 | 2021-09-01 | 1899-12-30 | rcu4uQD8WD2WVePLUyySJsr3EuPJbLfZRVNEZU/pU6M=-~Z0UYCpwQ/hk80HkI3RCk9A== |
| 5 | Swine Show | 101 | 2021-09-02 | 1899-12-30 | rcu4uQD8WD2WVePLUyySJsr3EuPJbLfZRVNEZU/pU6M=-~Z0UYCpwQ/hk80HkI3RCk9A== |
| 6 | Vegetable Exhibit | 102 | 2021-09-02 | 1899-12-30 | rcu4uQD8WD2WVePLUyySJsr3EuPJbLfZRVNEZU/pU6M=-~Z0UYCpwQ/hk80HkI3RCk9A== |
| 7 | Breeding Techniques | 105 | 2021-09-02 | 1899-12-30 | rcu4uQD8WD2WVePLUyySJsr3EuPJbLfZRVNEZU/pU6M=-~Z0UYCpwQ/hk80HkI3RCk9A== |
| 8 | Virtual Garden Tour | 105 | 2021-09-02 | 1899-12-30 | rcu4uQD8WD2WVePLUyySJsr3EuPJbLfZRVNEZU/pU6M=-~Z0UYCpwQ/hk80HkI3RCk9A== |
| 9 | Horticulture | 104 | 2021-09-02 | 1899-12-30 | rcu4uQD8WD2WVePLUyySJsr3EuPJbLfZRVNEZU/pU6M=-~Z0UYCpwQ/hk80HkI3RCk9A== |
| 10 | Recruiting for Your Chapter | 102 | 2021-09-03 | 1899-12-30 | rcu4uQD8WD2WVePLUyySJsr3EuPJbLfZRVNEZU/pU6M=-~Z0UYCpwQ/hk80HkI3RCk9A== |
| 11 | Herb Exhibit | 103 | 2021-09-03 | 1899-12-30 | rcu4uQD8WD2WVePLUyySJsr3EuPJbLfZRVNEZU/pU6M=-~Z0UYCpwQ/hk80HkI3RCk9A== |
| 12 | Skills Competition II | 101 | 2021-09-03 | 1899-12-30 | rcu4uQD8WD2WVePLUyySJsr3EuPJbLfZRVNEZU/pU6M=-~Z0UYCpwQ/hk80HkI3RCk9A== |
| 13 | Basic Animal First Aid | 104 | 2021-09-03 | 1899-12-30 | rcu4uQD8WD2WVePLUyySJsr3EuPJbLfZRVNEZU/pU6M=-~Z0UYCpwQ/hk80HkI3RCk9A== |
| 14 | Volunteer Opportunities | 101 | 2021-09-03 | 1899-12-30 | rcu4uQD8WD2WVePLUyySJsr3EuPJbLfZRVNEZU/pU6M=-~Z0UYCpwQ/hk80HkI3RCk9A== |
| LocationID | Capacity | Outdoors | Refreshments | Notes | mSysRowId |
|---|---|---|---|---|---|
| 101 | 150 | true | false | Main stage | 0nae9a3EQXH7ADhpuXAGOhl8/0mT4XSEjb5PwhzLSKY=-~b2QvrrYL9y11IfOujDenVA== |
| 102 | 100 | true | true | 0nae9a3EQXH7ADhpuXAGOhl8/0mT4XSEjb5PwhzLSKY=-~b2QvrrYL9y11IfOujDenVA== | |
| 103 | 50 | true | true | 0nae9a3EQXH7ADhpuXAGOhl8/0mT4XSEjb5PwhzLSKY=-~b2QvrrYL9y11IfOujDenVA== | |
| 104 | 25 | true | false | Small display outside the main office | 0nae9a3EQXH7ADhpuXAGOhl8/0mT4XSEjb5PwhzLSKY=-~b2QvrrYL9y11IfOujDenVA== |
| 105 | 75 | false | false | 0nae9a3EQXH7ADhpuXAGOhl8/0mT4XSEjb5PwhzLSKY=-~b2QvrrYL9y11IfOujDenVA== | |
| 106 | 75 | true | true | 0nae9a3EQXH7ADhpuXAGOhl8/0mT4XSEjb5PwhzLSKY=-~b2QvrrYL9y11IfOujDenVA== | |
| 107 | 50 | true | true | 0nae9a3EQXH7ADhpuXAGOhl8/0mT4XSEjb5PwhzLSKY=-~b2QvrrYL9y11IfOujDenVA== |
| ID | mSysRowId |
|---|---|
| 1 | Jf1WhcjmWgO4Bx8PIGVVOyZriLUeZ2+cr02YCqtDKEc=-~1xw6z3JnNKeHw+VnauBdgw== |
| PresenterID | FirstName | LastName | Address | City | State | ZipCode |
|---|---|---|---|---|---|---|
| 1 | Shannon | Beck | 368 Graham Avenue | Graham | KY | 42344 |
| 2 | Sheila | Gibson | 139 Park Avenue | Benton | IL | 62812 |
| 3 | Alexander | Jackson | 182 Route 20 | Monroe | LA | 71207 |
| 4 | Leroy | Chavez | 122 East 24th Street | Guys | TN | 38339 |
| 5 | Andrea | Rose | 244 Curtis Place | Harrisburg | PA | 17128 |
| 6 | Jennifer | George | 100 20th Avenue | Waynesburg | KY | 40489 |
| 7 | Robert | Matthews | 262 Graham Avenue | Stem | NC | 27581 |
| 8 | Kyle | Shelton | 355 Curtis Place | Fort Totten | ND | 58335 |
| 9 | Eric | Ross | 372 East 21st Street | Bayamon | PR | 00958 |
| 10 | Ida | Walton | 360 Graham Avenue | Higden | AR | 72067 |
| 11 | Phillip | Perkins | 15 Ryle Avenue | Radersburg | MT | 59641 |
| 12 | Harold | Rogers | 253 Main Street | Deer Grove | IL | 61243 |
| 13 | Janice | Harvey | 33 Main Street | Willard | UT | 84340 |
| 14 | Connie | Hoffman | 196 Curtis Place | La Mirada | CA | 90637 |
| 15 | Dana | Taylor | 44 Montclair Avenue | Bloomington | IL | 61704 |
| 16 | Marvin | Rodriguez | 166 Market Street | Peoria | IL | 61641 |
| 17 | Chetan | Rana | 10000 SW 59 Court | Lake Norden | SD | 57248 |
| ID | FirstName | LastName | Address | City | StateProvince | PostalCode | FeePaid | mSysRowId |
|---|---|---|---|---|---|---|---|---|
| 8 | Tatiana | Toribio | 124 West Windmore Dr | New Fairfield | CT | 6812 | true |
SELECT Rooms.RoomID
FROM Rooms
ORDER BY [RoomID];
PARAMETERS __SpeakerID Value;
SELECT DISTINCTROW *
FROM [SELECT [Speaker - Session Query].SpeakerID, [Speaker - Session Query].SessionID, [Speaker - Session Query].SessionTitle, [Speaker - Session Query].RoomID, [Speaker - Session Query].Date, [Speaker - Session Query].StartingTime FROM [Speaker - Session Query]]. AS [Speakers Form]
WHERE ([__SpeakerID] = SpeakerID);
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];
