|
| |
These are the names of the fields you are to create in the Georgetown Cleaning
Services
Database and the Table: tblCleaningOrders N=Number, C = Currency type
This list is also available by right clicking on the "appropriate
fields" text in the homework
| Field Name |
Data Type |
Caption |
| OrderID (Primary Key) |
AutoNumber |
Order ID |
| Pants |
Number |
|
| PantsPrice |
Currency |
|
| MenSuits2Piece |
Number |
Men Suits (2pc) |
| MenSuits2PiecePrice |
Currency |
|
| MenSuits3Piece |
n |
Men Suits (3pc) |
| MenSuits3PiecePrice |
Currency |
|
| Sweater |
n |
|
| SweaterPrice |
Currency |
|
| WomenSuit |
n |
Women Suit |
| WomenSuitPrice |
c |
|
| Dresses |
n |
|
| DressesPrice |
c |
|
| ShirtRegular |
n |
Shirt (R) |
| ShirtRegularPrice |
c |
|
| ShirtSilk |
n |
Shirt Silk |
| ShirtSilkPrice |
c |
|
| ShirtWool |
n |
Shirt Wool |
| ShirtWoolPrice |
c |
|
| SkirtBelt |
n |
Skirt Belt |
| SkirtBeltPrice |
c |
|
| SkirtHook |
n |
Skirt Hook |
| SkirtHookPrice |
c |
|
| Belt |
n |
|
| BeltPrice |
c |
| Tie |
n |
|
| TiePrice |
c |
| Coat |
n |
|
| CoatPrice |
c |
| Blouse |
n |
|
| BlousePrice |
c |
| RainCoat |
n |
Rain Coat |
| RainCoatPrice |
c |
|
| Notes |
m |
|
|
