|
In this exercise, we will create a database application that
can be used to process customers orders for a dry cleaning business. We will
create the database in Microsoft SQL Server. This database will have only one
table (for now).
|
Practical Learning: Creating the Database
|
|
- If you haven't done this yet, start Microsoft Access and create a Blank Database named GCS6
- To create a new table, on the main menu, click Insert . Table and, in
the New Table dialog box, double-click Design View
- In the first box under Field Name, type CleaningOrderID and press Enter
- Set its Data Type to AutoNumber
- Right-click it and click Primary Key
- Complete the table with the following fields:
| Field Name |
| CleaningOrderID |
| CustomerName |
| CustomerPhone |
| DateLeft |
| TimeLeft |
| DateExpected |
| TimeExpected |
| ShirtsUnitPrice |
| ShirtsQuantity |
| ShirtsSubTotal |
| PantsUnitPrice |
| PantsQuantity |
| Item1Name |
| Item1UnitPrice |
| Item1Quantity |
| Item1SubTotal |
| Item2Name |
| Item2UnitPrice |
| Item2Quantity |
| Item2SubTotal |
| Item3Name |
| Item3UnitPrice |
| Item3Quantity |
| Item3SubTotal |
| Item4Name |
| Item4UnitPrice |
| Item4Quantity |
| Item4SubTotal |
| CleaningTotal |
| TaxRate |
| TaxAmount |
| OrderTotal |
- Save the table as CleaningOrders and close it
|
|
