Exp19_Access_Ch4_Cap – Farm Conference 1.0

PresenterID ExhibitID mSysRowId

1 1 U0dbaRm0m52RH4mM0cGBsIYNhj4SGZMfqVnMxL9cJdc=-~5Juxi8ZYygxEadr0BfOHfQ==

1 4 U0dbaRm0m52RH4mM0cGBsIYNhj4SGZMfqVnMxL9cJdc=-~5Juxi8ZYygxEadr0BfOHfQ==

1 9 U0dbaRm0m52RH4mM0cGBsIYNhj4SGZMfqVnMxL9cJdc=-~5Juxi8ZYygxEadr0BfOHfQ==

1 10 U0dbaRm0m52RH4mM0cGBsIYNhj4SGZMfqVnMxL9cJdc=-~5Juxi8ZYygxEadr0BfOHfQ==

1 13 U0dbaRm0m52RH4mM0cGBsIYNhj4SGZMfqVnMxL9cJdc=-~5Juxi8ZYygxEadr0BfOHfQ==

1 14 U0dbaRm0m52RH4mM0cGBsIYNhj4SGZMfqVnMxL9cJdc=-~5Juxi8ZYygxEadr0BfOHfQ==

2 1 U0dbaRm0m52RH4mM0cGBsIYNhj4SGZMfqVnMxL9cJdc=-~5Juxi8ZYygxEadr0BfOHfQ==

3 2 U0dbaRm0m52RH4mM0cGBsIYNhj4SGZMfqVnMxL9cJdc=-~5Juxi8ZYygxEadr0BfOHfQ==

3 6 U0dbaRm0m52RH4mM0cGBsIYNhj4SGZMfqVnMxL9cJdc=-~5Juxi8ZYygxEadr0BfOHfQ==

3 9 U0dbaRm0m52RH4mM0cGBsIYNhj4SGZMfqVnMxL9cJdc=-~5Juxi8ZYygxEadr0BfOHfQ==

4 9 U0dbaRm0m52RH4mM0cGBsIYNhj4SGZMfqVnMxL9cJdc=-~5Juxi8ZYygxEadr0BfOHfQ==

4 12 U0dbaRm0m52RH4mM0cGBsIYNhj4SGZMfqVnMxL9cJdc=-~5Juxi8ZYygxEadr0BfOHfQ==

5 2 U0dbaRm0m52RH4mM0cGBsIYNhj4SGZMfqVnMxL9cJdc=-~5Juxi8ZYygxEadr0BfOHfQ==

5 7 U0dbaRm0m52RH4mM0cGBsIYNhj4SGZMfqVnMxL9cJdc=-~5Juxi8ZYygxEadr0BfOHfQ==

5 13 U0dbaRm0m52RH4mM0cGBsIYNhj4SGZMfqVnMxL9cJdc=-~5Juxi8ZYygxEadr0BfOHfQ==

6 6 U0dbaRm0m52RH4mM0cGBsIYNhj4SGZMfqVnMxL9cJdc=-~5Juxi8ZYygxEadr0BfOHfQ==

7 2 U0dbaRm0m52RH4mM0cGBsIYNhj4SGZMfqVnMxL9cJdc=-~5Juxi8ZYygxEadr0BfOHfQ==

7 3 U0dbaRm0m52RH4mM0cGBsIYNhj4SGZMfqVnMxL9cJdc=-~5Juxi8ZYygxEadr0BfOHfQ==

7 8 U0dbaRm0m52RH4mM0cGBsIYNhj4SGZMfqVnMxL9cJdc=-~5Juxi8ZYygxEadr0BfOHfQ==

7 12 U0dbaRm0m52RH4mM0cGBsIYNhj4SGZMfqVnMxL9cJdc=-~5Juxi8ZYygxEadr0BfOHfQ==

8 9 U0dbaRm0m52RH4mM0cGBsIYNhj4SGZMfqVnMxL9cJdc=-~5Juxi8ZYygxEadr0BfOHfQ==

8 10 U0dbaRm0m52RH4mM0cGBsIYNhj4SGZMfqVnMxL9cJdc=-~5Juxi8ZYygxEadr0BfOHfQ==

9 13 U0dbaRm0m52RH4mM0cGBsIYNhj4SGZMfqVnMxL9cJdc=-~5Juxi8ZYygxEadr0BfOHfQ==

10 5 U0dbaRm0m52RH4mM0cGBsIYNhj4SGZMfqVnMxL9cJdc=-~5Juxi8ZYygxEadr0BfOHfQ==

10 8 U0dbaRm0m52RH4mM0cGBsIYNhj4SGZMfqVnMxL9cJdc=-~5Juxi8ZYygxEadr0BfOHfQ==

10 11 U0dbaRm0m52RH4mM0cGBsIYNhj4SGZMfqVnMxL9cJdc=-~5Juxi8ZYygxEadr0BfOHfQ==

11 2 U0dbaRm0m52RH4mM0cGBsIYNhj4SGZMfqVnMxL9cJdc=-~5Juxi8ZYygxEadr0BfOHfQ==

12 6 U0dbaRm0m52RH4mM0cGBsIYNhj4SGZMfqVnMxL9cJdc=-~5Juxi8ZYygxEadr0BfOHfQ==

13 2 U0dbaRm0m52RH4mM0cGBsIYNhj4SGZMfqVnMxL9cJdc=-~5Juxi8ZYygxEadr0BfOHfQ==

13 7 U0dbaRm0m52RH4mM0cGBsIYNhj4SGZMfqVnMxL9cJdc=-~5Juxi8ZYygxEadr0BfOHfQ==

13 9 U0dbaRm0m52RH4mM0cGBsIYNhj4SGZMfqVnMxL9cJdc=-~5Juxi8ZYygxEadr0BfOHfQ==

ExhibitID ExhibitTitle LocationID Date StartingTime mSysRowId

1 Skills Competition I 101 9/1/21 12/30/99 Tuy/xrNajBSmNZ2+0nmBMVbGObSoojFl4RuL54qL8hQ=-~t/EHIHe/prykBXLF1wIAkw==

2 Rabbit Show 103 9/1/21 12/30/99 Tuy/xrNajBSmNZ2+0nmBMVbGObSoojFl4RuL54qL8hQ=-~t/EHIHe/prykBXLF1wIAkw==

3 Dairy Show 104 9/1/21 12/30/99 Tuy/xrNajBSmNZ2+0nmBMVbGObSoojFl4RuL54qL8hQ=-~t/EHIHe/prykBXLF1wIAkw==

4 Sheep and Goat Show 101 9/1/21 12/30/99 Tuy/xrNajBSmNZ2+0nmBMVbGObSoojFl4RuL54qL8hQ=-~t/EHIHe/prykBXLF1wIAkw==

5 Swine Show 101 9/2/21 12/30/99 Tuy/xrNajBSmNZ2+0nmBMVbGObSoojFl4RuL54qL8hQ=-~t/EHIHe/prykBXLF1wIAkw==

6 Vegetable Exhibit 102 9/2/21 12/30/99 Tuy/xrNajBSmNZ2+0nmBMVbGObSoojFl4RuL54qL8hQ=-~t/EHIHe/prykBXLF1wIAkw==

7 Breeding Techniques 105 9/2/21 12/30/99 Tuy/xrNajBSmNZ2+0nmBMVbGObSoojFl4RuL54qL8hQ=-~t/EHIHe/prykBXLF1wIAkw==

8 Virtual Garden Tour 105 9/2/21 12/30/99 Tuy/xrNajBSmNZ2+0nmBMVbGObSoojFl4RuL54qL8hQ=-~t/EHIHe/prykBXLF1wIAkw==

9 Horticulture 104 9/2/21 12/30/99 Tuy/xrNajBSmNZ2+0nmBMVbGObSoojFl4RuL54qL8hQ=-~t/EHIHe/prykBXLF1wIAkw==

10 Recruiting for Your Chapter 102 9/3/21 12/30/99 Tuy/xrNajBSmNZ2+0nmBMVbGObSoojFl4RuL54qL8hQ=-~t/EHIHe/prykBXLF1wIAkw==

11 Herb Exhibit 103 9/3/21 12/30/99 Tuy/xrNajBSmNZ2+0nmBMVbGObSoojFl4RuL54qL8hQ=-~t/EHIHe/prykBXLF1wIAkw==

12 Skills Competition II 101 9/3/21 12/30/99 Tuy/xrNajBSmNZ2+0nmBMVbGObSoojFl4RuL54qL8hQ=-~t/EHIHe/prykBXLF1wIAkw==

13 Basic Animal First Aid 104 9/3/21 12/30/99 Tuy/xrNajBSmNZ2+0nmBMVbGObSoojFl4RuL54qL8hQ=-~t/EHIHe/prykBXLF1wIAkw==

14 Volunteer Opportunities 101 9/3/21 12/30/99 Tuy/xrNajBSmNZ2+0nmBMVbGObSoojFl4RuL54qL8hQ=-~t/EHIHe/prykBXLF1wIAkw==

LocationID Capacity Outdoors Refreshments Notes mSysRowId

101 150 true false Main stage 68t6jt6e0YrIfXEoKouYgAkcxxto1Pmt2+xrSB41DAY=-~5xkJl7ZLEVyE2Nked1YCxg==

102 100 true true 68t6jt6e0YrIfXEoKouYgAkcxxto1Pmt2+xrSB41DAY=-~5xkJl7ZLEVyE2Nked1YCxg==

103 50 true true 68t6jt6e0YrIfXEoKouYgAkcxxto1Pmt2+xrSB41DAY=-~5xkJl7ZLEVyE2Nked1YCxg==

104 25 true false Small display outside the main office 68t6jt6e0YrIfXEoKouYgAkcxxto1Pmt2+xrSB41DAY=-~5xkJl7ZLEVyE2Nked1YCxg==

105 75 false false 68t6jt6e0YrIfXEoKouYgAkcxxto1Pmt2+xrSB41DAY=-~5xkJl7ZLEVyE2Nked1YCxg==

106 75 true true 68t6jt6e0YrIfXEoKouYgAkcxxto1Pmt2+xrSB41DAY=-~5xkJl7ZLEVyE2Nked1YCxg==

107 50 true true 68t6jt6e0YrIfXEoKouYgAkcxxto1Pmt2+xrSB41DAY=-~5xkJl7ZLEVyE2Nked1YCxg==

ID mSysRowId

1 nxmGiQNtvG3nK02ZK7zMw0zuWxqH1Pr8MEl7UsZ//9M=-~ndgdZa1yFfxTvoW2BsnklQ==

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];