Mircosoft Access Computer Homework
Meow1992
ptcostumes3.accdb
| SeamstressID | FirstName | LastName | Street | City | StateOrProv | ZIPCode | HPhone | BusPhone | Cell |
| 201 | Mary | Smith | 25 Dundas Street | Buffalo | NY | 142806532 | 7165553258 | 7165559863 | 7165554258 |
| 205 | Ester | Jorgan | 33 Water Street | Buffalo | NY | 14280 | 7165553695 | 7165554863 | 7165553485 |
| CostumeID | Description | CustID | ContPrice | SignedContract | Deposit | SeamstressID | EstHrs_Research | EstHrs_Design | EstHrs_Prod | ActualHrs_Research | ActualHrs_Design | ActualHrs_Prod |
| 150 | Othello | 100 | ¤ 675.00 | true | ¤ 100.00 | 201 | 10 | 10 | 25 | 15 | 8 | 30 |
| 155 | Hamlet | 110 | ¤ 1,100.00 | true | ¤ 500.00 | 205 | 15 | 10 | 40 | 12 | 9 | 41 |
| CustID | FirstName | LastName | Street | City | StateOrProv | ZIPCode | Hhone | BusPhone | Cell |
| 100 | Desmond | Williams | 100 Oxford Street | Detroit | MI | 33102 | 3135554578 | 3135559865 | 3135551548 |
| 110 | Sarah | Emerson | 55-325 First Street | Detroit | MI | 331458569 | 3135554875 | 3135556985 | 3135554865 |
| CustID | CostumeID | Description | ShipStreet | ShipCity | ShipStateOrProv | ShipZIPCode | ShipPhone | ShipCarrier | ShipCharge |
| 100 | 150 | Othello | 155 King Street | Buffalo | NY | 142803652 | 7165552596 | Purolator Courier | ¤ 55.00 |
| 110 | 155 | Hamlet | 98 Queen Street | Buffalo | NY | 14280 | 7165553685 | USPS | ¤ 25.00 |
