Excel Case
xoon
confections.accdb| CID | Name | Street | City | State | Postal Code | Phone |
|---|---|---|---|---|---|---|
| C101 | Wilson, Rachel | 8502 Nighthawk Ln. | Derry | NH | 03038 | (603) 555-8966 |
| C102 | Kemper, Kevin | 25 Maple Ave. | Richmond | KY | 40475 | (859) 555-0882 |
| C103 | Lungren, Uwe | 5 East Main St. | Dolton | IL | 60419 | (708) 555-4312 |
| C104 | Adams, Bernard | 55 Miller Ave. | Urbandale | IA | 50323 | (515) 555-9333 |
| C105 | Glenn, David | 800 Oak St. | Cedar City | UT | 84720 | (435) 555-2950 |
| C106 | Hu, Huan | 414 Allen Blvd. | Great Falls | MT | 59403 | (406) 555-1180 |
| CID | OID |
|---|---|
| C101 | OR09114 |
| C101 | OR10311 |
| C102 | OR08892 |
| C102 | OR09916 |
| C102 | OR10899 |
| C103 | OR10115 |
| C104 | OR11058 |
| C105 | OR10211 |
| C106 | OR08715 |
| C106 | OR09917 |
| C106 | OR11560 |
| OID | Date |
|---|---|
| OR08715 | 6/12/13 |
| OR08892 | 6/12/13 |
| OR09114 | 6/13/13 |
| OR09916 | 6/11/13 |
| OR09917 | 6/15/13 |
| OR10115 | 6/19/13 |
| OR10211 | 6/20/13 |
| OR10311 | 6/21/13 |
| OR10899 | 6/23/13 |
| OR11058 | 6/23/13 |
| OR11560 | 6/24/13 |
| OID | PID |
|---|---|
| OR08715 | P053 |
| OR08715 | P100 |
| OR08715 | P150 |
| OR08715 | P151 |
| OR08715 | P152 |
| OR08715 | P153 |
| OR08715 | P402 |
| OR08715 | P411 |
| OR08715 | P501 |
| OR08892 | P202 |
| OR08892 | P303 |
| OR08892 | P500 |
| OR09114 | P051 |
| OR09114 | P202 |
| OR09114 | P304 |
| OR09114 | P401 |
| OR09916 | P001 |
| OR09916 | P200 |
| OR09916 | P202 |
| OR09916 | P409 |
| OR09916 | P500 |
| OR09916 | P502 |
| OR09917 | P100 |
| OR09917 | P105 |
| OR09917 | P150 |
| OR09917 | P151 |
| OR09917 | P152 |
| OR09917 | P153 |
| OR09917 | P400 |
| OR09917 | P408 |
| OR09917 | P411 |
| OR09917 | P503 |
| OR10115 | P001 |
| OR10115 | P052 |
| OR10115 | P201 |
| OR10115 | P404 |
| OR10211 | P406 |
| OR10211 | P410 |
| OR10311 | P001 |
| OR10311 | P050 |
| OR10311 | P300 |
| OR10311 | P301 |
| OR10311 | P502 |
| OR10899 | P001 |
| OR10899 | P202 |
| OR10899 | P301 |
| OR10899 | P403 |
| OR10899 | P500 |
| OR11058 | P405 |
| OR11058 | P407 |
| OR11058 | P411 |
| OR11560 | P101 |
| OR11560 | P102 |
| OR11560 | P103 |
| OR11560 | P150 |
| OR11560 | P151 |
| OR11560 | P152 |
| OR11560 | P153 |
| OR11560 | P402 |
| OR11560 | P410 |
| OR11560 | P411 |
| OR11560 | P501 |
| PID | Product | Price |
|---|---|---|
| P001 | Fudge medley wire heart box | 40.0 |
| P050 | 24 piece assorted box | 45.0 |
| P051 | 3lb milk, dark & white pecan turtles | 65.0 |
| P052 | Assorted nuts | 65.0 |
| P053 | 12 piece french cream truffle box | 30.0 |
| P100 | 12 piece assorted box | 30.0 |
| P101 | Old fashioned milk honeycomb | 33.0 |
| P102 | Fudge medley large heart box | 40.0 |
| P103 | Dark chocolate dipped apricots | 37.0 |
| P105 | Divinity walnut | 23.0 |
| P150 | Old fashioned milk & dark honeycomb | 33.0 |
| P151 | Fudge medley star | 40.0 |
| P152 | Fudge medley mesh box | 34.0 |
| P153 | Dark chocolate ginger slices | 37.0 |
| P200 | 2lb milk pecan turtles | 50.0 |
| P201 | Truffle temptation tree | 170.0 |
| P202 | Truffle basket | 35.0 |
| P300 | 24 piece french cream truffle box | 40.0 |
| P301 | Fudge gold chest | 36.0 |
| P303 | Fudge medley silver chest | 33.0 |
| P304 | Milk heart with truffles | 30.0 |
| P400 | 24 piece pinecone ballotin | 38.0 |
| P401 | 16 piece pinetone ballotin | 30.0 |
| P402 | Fudge medley gold basket | 40.0 |
| P403 | Fudge medley silver basket | 40.0 |
| P404 | Milk heart with small truffles | 35.0 |
| P405 | Milk heart with large truffles | 45.0 |
| P406 | Dark chocolate glaze orange slices | 37.0 |
| P407 | Dark chocolate orange peel | 40.0 |
| P408 | Dark chocolate pineapple rings | 37.0 |
| P409 | 1lb chocolate village | 35.0 |
| P410 | 1.5lb chocolate village | 45.0 |
| P411 | Milk chocolate tubes and swirls | 35.0 |
| P500 | Teapot of milk turtles | 28.0 |
| P501 | 12 piece triangle truffle box | 35.0 |
| P502 | Fudge tube | 23.0 |
| P503 | Assorted chocolate fruit | 50.0 |
