Access Case Problem 3

gijack25
Center.accdb
Home>Computer Science homework help>Access Case Problem 3
AuctionID DonationID AuctionDate MinPrice ItemSold
200 5129 8/12/17 ¤ 300.00 false
205 5132 8/12/17 ¤ 200.00 false
210 5146 9/9/17 ¤ 150.00 false
215 5152 9/9/17 ¤ 125.00 false
220 5178 10/14/17 ¤ 350.00 false
225 5187 10/14/17 ¤ 200.00 false
230 5205 10/14/17 ¤ 175.00 false
235 5217 10/14/17 ¤ 150.00 false
240 5238 10/14/17 ¤ 225.00 false
245 5241 10/14/17 ¤ 400.00 false
250 5244 11/11/17 ¤ 50.00 false
255 5260 11/11/17 ¤ 100.00 false
DonationID PatronID DonationDate Description DonationValue CashDonation AuctionItem
5100 3022 7/5/17 Cash donation ¤ 50.00 true false
5105 3035 7/8/17 Cash donation ¤ 25.00 true false
5110 3044 7/13/17 Cash donation ¤ 25.00 true false
5115 3001 7/13/17 Clothing ¤ 125.00 false false
5120 3006 7/15/17 Shoes ¤ 100.00 false false
5123 3041 7/17/17 Cash donation ¤ 75.00 true false
5126 3014 8/3/17 Pots and pans ¤ 50.00 false false
5129 3003 8/5/17 Grandfather clock ¤ 500.00 false true
5132 3028 8/7/17 Dining room furniture ¤ 250.00 false true
5135 3033 8/11/17 Towels ¤ 50.00 false false
5138 3025 8/14/17 Hats and gloves ¤ 60.00 false false
5140 3027 8/17/17 Cash donation ¤ 25.00 true false
5143 3031 8/18/17 Girls clothes ¤ 125.00 false false
5146 3030 8/21/17 New television ¤ 250.00 false true
5149 3008 8/21/17 Toys ¤ 150.00 false false
5152 3011 8/28/17 Jewelry ¤ 200.00 false true
5155 3038 8/29/17 Cash donation ¤ 25.00 true false
5160 3016 8/30/17 Cash donation ¤ 75.00 true false
5163 3024 9/5/17 Cash donation ¤ 100.00 true false
5166 3019 9/6/17 Boys clothes ¤ 150.00 false false
5169 3001 9/8/17 Cash donation ¤ 100.00 true false
5172 3016 9/8/17 Cash donation ¤ 150.00 true false
5175 3019 9/9/17 Cash donation ¤ 200.00 true false
5178 3028 9/11/17 Stamp collection ¤ 500.00 false true
5181 3035 9/11/17 Cash donation ¤ 50.00 true false
5184 3008 9/15/17 Cash donation ¤ 250.00 true false
5187 3006 9/16/17 Living room furniture ¤ 300.00 true true
5190 3027 9/18/17 Light fixtures ¤ 125.00 false false
5194 3031 9/21/17 Cash donation ¤ 25.00 true false
5198 3011 9/22/17 Cash donation ¤ 125.00 true false
5202 3003 9/25/17 Cash donation ¤ 50.00 true false
5205 3025 9/25/17 New stereo system ¤ 250.00 false true
5208 3024 9/26/17 Cash donation ¤ 100.00 true false
5211 3033 9/28/17 Cash donation ¤ 200.00 true false
5214 3030 9/29/17 Cash donation ¤ 100.00 true false
5217 3038 9/30/17 Woodworking tool ¤ 250.00 false true
5220 3014 10/2/17 Car cleaning kit ¤ 65.00 false false
5223 3022 10/4/17 Cash donation ¤ 75.00 true false
5226 3044 10/5/17 Cash donation ¤ 200.00 true false
5229 3041 10/5/17 Cash donation ¤ 50.00 true false
5232 3011 10/6/17 Pet supplies ¤ 100.00 false false
5235 3031 10/9/17 Towels ¤ 50.00 false false
5238 3038 10/12/17 Antique clock ¤ 275.00 false true
5241 3001 10/14/17 New computer ¤ 500.00 false true
5244 3016 10/16/17 New bicycle ¤ 100.00 false true
5247 3044 10/19/17 Cash donation ¤ 100.00 true false
5250 3014 10/21/17 Cash donation ¤ 50.00 true false
5255 3031 10/25/17 Cash donation ¤ 25.00 true false
5260 3035 10/27/17 Restaurant gift card ¤ 100.00 false true
5265 3022 11/3/17 Shelving ¤ 125.00 false false
PatronID Title FirstName LastName Phone Email
3001 Stud Student First Student Last 404-987-1234 student@example.com
3003 Ms. Sarah Johanson 404-987-3985 johan19@example.com
3006 Dr. Elbert Schneider 678-492-9101 countrydoc@example.com
3008 Mrs. June Franklin 404-987-0915 junebug@example.net
3011 Mr. Henry Shelton 678-492-0091 hshelton42@example.com
3014 Mr. Ben Jackson 706-917-4019 bennie@example.net
3016 Mr. Edward Jones 404-972-1102 edwardo@example.net
3019 Mrs. Jane Michaels 706-489-3310 jjmichaels@example.com
3022 Dr. Taylor Williams 404-812-9301 thefootdoc@example.net
3024 Ms. Catherine McGill 706-421-4491 mcgill12@example.com
3025 Mr. David Thomas 706-921-8830 funnyman@example.net
3027 Mrs. Kathy Johnston 404-489-4108 johnstonk123@example.com
3028 Mrs. Sue Jackson 678-321-2019 susieq@example.net
3030 Mr. David Hampton 404-824-3381 thehamptons@example.net
3031 Ms. Elinor Zak 404-435-9120 elinorzak@example.net
3033 Mrs. Lauren Shelbert 404-421-0021 bertie32@example.com
3035 Mr. Bill Thomas 678-876-9419 thombo42@example.com
3038 Ms. Gail Fordham 404-349-9310 thefordhams@example.net
3041 Mr. Frank Miller 404-824-3431 frankmiller12@example.net
3044 Mr. Victor Washburn 706-982-0184 thewashburns@example.net
SELECT DISTINCTROW * FROM Patron;
SELECT DISTINCTROW * FROM Patron;
SELECT Patron.PatronID, Patron.FirstName, Patron.LastName, Patron.Phone, Patron.Email FROM Patron;