IFMG 101
abdon_
exploring_a04_grader_a1.accdb| PresenterID | ExhibitID | mSysRowId |
|---|---|---|
| 1 | 1 | XUcz8xTXi2zT8QyfwJwM3iwfe6qSDg/4TDs7xtmBVvU=-~8w2mnwYXxiGgSbJGQLmUfg== |
| 1 | 4 | XUcz8xTXi2zT8QyfwJwM3iwfe6qSDg/4TDs7xtmBVvU=-~8w2mnwYXxiGgSbJGQLmUfg== |
| 1 | 9 | XUcz8xTXi2zT8QyfwJwM3iwfe6qSDg/4TDs7xtmBVvU=-~8w2mnwYXxiGgSbJGQLmUfg== |
| 1 | 10 | XUcz8xTXi2zT8QyfwJwM3iwfe6qSDg/4TDs7xtmBVvU=-~8w2mnwYXxiGgSbJGQLmUfg== |
| 1 | 13 | XUcz8xTXi2zT8QyfwJwM3iwfe6qSDg/4TDs7xtmBVvU=-~8w2mnwYXxiGgSbJGQLmUfg== |
| 1 | 14 | XUcz8xTXi2zT8QyfwJwM3iwfe6qSDg/4TDs7xtmBVvU=-~8w2mnwYXxiGgSbJGQLmUfg== |
| 2 | 1 | YB/p50Ef2xrINN1B5rmDL0+t3fNBada9v6ved5+xmQo=-~5BQpuCrBNJKk+ztoZGxpow== |
| 3 | 2 | 9Tb4VMJjLt5TnTD9cdpKjDbSqMJ8NpJ5L8yV07avmGc=-~NHsH74Yr/zbMD3/pUb/j1A== |
| 3 | 6 | 9Tb4VMJjLt5TnTD9cdpKjDbSqMJ8NpJ5L8yV07avmGc=-~NHsH74Yr/zbMD3/pUb/j1A== |
| 3 | 9 | 9Tb4VMJjLt5TnTD9cdpKjDbSqMJ8NpJ5L8yV07avmGc=-~NHsH74Yr/zbMD3/pUb/j1A== |
| 4 | 9 | +MJqssDL5VaRY87MkIM1bVEGerVsEruq6gIT2aLZg+g=-~n9GLOt5tSC2XOt8ZOUCvQQ== |
| 4 | 12 | +MJqssDL5VaRY87MkIM1bVEGerVsEruq6gIT2aLZg+g=-~n9GLOt5tSC2XOt8ZOUCvQQ== |
| 5 | 2 | nk5UcF7CBYd0c5xZ7bdCszyd3aB8LyzyeN/Bqaj5iiA=-~bNyVl/WOxyD2RfHTziGVsA== |
| 5 | 7 | nk5UcF7CBYd0c5xZ7bdCszyd3aB8LyzyeN/Bqaj5iiA=-~bNyVl/WOxyD2RfHTziGVsA== |
| 5 | 13 | nk5UcF7CBYd0c5xZ7bdCszyd3aB8LyzyeN/Bqaj5iiA=-~bNyVl/WOxyD2RfHTziGVsA== |
| 6 | 6 | luSoTM2E0ANFhqI9aZ3g3nOhg/mtsrx59rwhxHtdeF0=-~9VzqSncPv7TMg2AG5RtFMQ== |
| 7 | 2 | V0Oc6ItuX8FU/K7m0yEIl6cX9gB4m02zoxbSH0cWQt8=-~4ZH2kZLBB4ChVZEF5qY2yA== |
| 7 | 3 | V0Oc6ItuX8FU/K7m0yEIl6cX9gB4m02zoxbSH0cWQt8=-~4ZH2kZLBB4ChVZEF5qY2yA== |
| 7 | 8 | V0Oc6ItuX8FU/K7m0yEIl6cX9gB4m02zoxbSH0cWQt8=-~4ZH2kZLBB4ChVZEF5qY2yA== |
| 7 | 12 | V0Oc6ItuX8FU/K7m0yEIl6cX9gB4m02zoxbSH0cWQt8=-~4ZH2kZLBB4ChVZEF5qY2yA== |
| 8 | 9 | EscaxGBehjgvLHDqj9Stzaro4P5nYkSD7SR3sfl1Hdc=-~MiDy39eLo2Ls5h8L54q2Xg== |
| 8 | 10 | EscaxGBehjgvLHDqj9Stzaro4P5nYkSD7SR3sfl1Hdc=-~MiDy39eLo2Ls5h8L54q2Xg== |
| 9 | 13 | raAlKe08+HjHqhdhiVC5mInc2ODqMO64K8vFF+PxwLo=-~+Jh4qL9AAiPEMQV2L57i8g== |
| 10 | 5 | srcjdSitunsikHJ9YYhc2X9djNFwrqMQjKpd32WZiwY=-~6JTh0mWEKr9Ywbxgb+NOGg== |
| 10 | 8 | srcjdSitunsikHJ9YYhc2X9djNFwrqMQjKpd32WZiwY=-~6JTh0mWEKr9Ywbxgb+NOGg== |
| 10 | 11 | srcjdSitunsikHJ9YYhc2X9djNFwrqMQjKpd32WZiwY=-~6JTh0mWEKr9Ywbxgb+NOGg== |
| 11 | 2 | voiQe+7aQ1uighLXxbThX0m+BZW+lrd4kZni1cyy+us=-~uINxey7s5e3qoUf74Qky0w== |
| 12 | 6 | 7WPZo4EvUaOV1u16wib/nAD8s83EDdHky0tXfr0LoMQ=-~LA6W9MHXo3RMcrlNwKzwgQ== |
| 13 | 2 | b9vmQufWV2+C42dL4Def44bh0UcYc1XdCKa6+Od6sqg=-~qYRj5j059aFExJZNEE36ZQ== |
| 13 | 7 | b9vmQufWV2+C42dL4Def44bh0UcYc1XdCKa6+Od6sqg=-~qYRj5j059aFExJZNEE36ZQ== |
| 13 | 9 | b9vmQufWV2+C42dL4Def44bh0UcYc1XdCKa6+Od6sqg=-~qYRj5j059aFExJZNEE36ZQ== |
| ExhibitID | ExhibitTitle | LocationID | Date | StartingTime | mSysRowId |
|---|---|---|---|---|---|
| 1 | Skills Competition I | 101 | 9/1/14 | 12/30/99 | F1tPUa+w/n8JclDoj3HTsr/gSaw94eLgXv1kvHtHERA=-~XM63V5qcC2Rc7cYk8y/fLA== |
| 2 | Rabbit Show | 103 | 9/1/14 | 12/30/99 | FccgviBeaII7lPjy66Ic6fV3VNZEZ6sArjUIr4210TA=-~IA1iFhx+nvEkD76OmsxCmg== |
| 3 | Dairy Show | 104 | 9/1/14 | 12/30/99 | D6Z0hHdjB7LRv+RkFGADiUUvnRxZ5ce7v1/UXQw559Q=-~gK8+hxJIJZvNkyNFQ8TZnw== |
| 4 | Sheep and Goat Show | 101 | 9/1/14 | 12/30/99 | Qp2tmZcvjTuTwPzw2f005HeyRgEAflvNC7BY7JgpumM=-~+eyzQzgUhODFr6/wc0VxWg== |
| 5 | Swine Show | 101 | 9/2/14 | 12/30/99 | tcixfKFHx0+icxAm9dZyW5cE7Muy4SYsE0rc5aTNpuk=-~xL06dS/MxGJsxM1U0h7+Yg== |
| 6 | Vegetable Exhibit | 102 | 9/2/14 | 12/30/99 | HAsX52YhD3tF84pCJtUWiofxA+N6tz8eHrfIR++DUOA=-~F3UNCRb7X8A7LthIHAetuw== |
| 7 | Breeding Techniques | 105 | 9/2/14 | 12/30/99 | l/VEIL2T+9PT/Ye0z/zkX62mHZfLOsp9hGSYRg+XBYk=-~zPrghbi49iVjhPgFdhwL/w== |
| 8 | Virtual Garden Tour | 105 | 9/2/14 | 12/30/99 | 1bW3aADoyU8TaSZXk8ctGJnN6yZts0a2s729EHGcgWM=-~+SGUxnHZlUZlDc43nptBcA== |
| 9 | Horticulture | 104 | 9/2/14 | 12/30/99 | mGFMX/6VVrf0VmXDCDWf54pz+HXDLJBxMT2EPyKX4Ao=-~xmDkQZyd0KZ+xfV/bV3NlA== |
| 10 | Recruiting for Your Chapter | 102 | 9/3/14 | 12/30/99 | O//BylzqnVk7jtPkPswboXO2su6TKBDrQRsPsIzE+mw=-~cxvr1Z1gTXHGHj0NuJ9Pcw== |
| 11 | Herb Exhibit | 103 | 9/3/14 | 12/30/99 | PxfsSM9ygFrG7YQ3asZfHB++OMKJwX3CgnzYiaLUmFE=-~z2qmP08ODZdNX0/6QD6m5w== |
| 12 | Skills Competition II | 101 | 9/3/14 | 12/30/99 | iJY0JDp1NebcUWsPKBCtPVTlGz/JXq9F5CGK/Xc6180=-~Eub1wAYQEPQhF9PGsKo0Qg== |
| 13 | Basic Animal First Aid | 104 | 9/3/14 | 12/30/99 | 5GYMqJVLHLEAGlU58vRVimneS6Evrd3am7mKWjwd200=-~/Ztks6dwLbibtiPXUxLkAA== |
| 14 | Volunteer Opportunities | 101 | 9/3/14 | 12/30/99 | 8hHySiLO+0xlOmMsPgHbvTj/4np5HS2RODK/X5Md87g=-~FdHFJ4P3xnim50d4YSBSlQ== |
| LocationID | Capacity | Outdoors | Refreshments | Notes | mSysRowId |
|---|---|---|---|---|---|
| 101 | 150 | true | false | Main stage | 8rw0PbJv6fpm63eryOFXbofXYXXmkiRHHPgtGm4/GAU=-~xlCzkc5NOj1DYdlyJXYPDQ== |
| 102 | 100 | true | true | X//Ttnipva0o6SGa3FeoQtp14day5cvQCJrdeOOmg4g=-~Qz2rUlV0WgG66JvDxmEcsA== | |
| 103 | 50 | true | true | QmtqzZPnYNL54ZjONgxN3TYCn19yVE8XG6hNJhS2lWc=-~nl1j90hv9qNMJv2rcnYMHA== | |
| 104 | 25 | true | false | Small display outside the main office | 8MDFIcinQwnX/LEx1ued6fNN6TvuKLmVswbMCR639PY=-~mvQMZNUpuQg3dUA2nbuuRw== |
| 105 | 75 | false | false | VKfCnoOR9VvT+zUwsSgfBQsbeaDRrz5z5410tdzeuog=-~TXpWiPXAzJtq8Kum/hEhCA== | |
| 106 | 75 | true | true | tHKi8pfyR+0SRZjKTOpwt2HXcK9KFBc9sj9UBlfvErc=-~YsDkq/XqaCJljMhIpWNueQ== | |
| 107 | 50 | true | true | Hia1mfMPFA2faIFVyarC4b4N7brZdswKToC/X9j/L94=-~hkLFwCPzkBXbwPhvo8t3wg== |
| ID | mSysRowId |
|---|---|
| 1 | r0rXeJ91MAy6C4T2Y2oQsqJp66XWouiWGDeqWoZ9Lc4=-~/LCy4vbYelH2Zt99EMfl9Q== |
| 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 | Au8q6exZ81lCRSIBUHxNE+E5RIvo3dhUGsD11L2KTYY=-~DfNCf9sYx3OzfbIZ+CbtJA== |
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 DISTINCTROW *
FROM Locations;
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];
