Home

Georgetown Cleaning Services

 

Introduction

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 Practical Learning: Creating the Database 

  1. If you haven't done this yet, start Microsoft Access and create a Blank Database named GCS6
  2. To create a new table, on the main menu, click Insert . Table and, in the New Table dialog box, double-click Design View
  3. In the first box under Field Name, type CleaningOrderID and press Enter
  4. Set its Data Type to AutoNumber
  5. Right-click it and click Primary Key
  6. 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
  7. Save the table as CleaningOrders and close it

 
 

Home Copyright © 2005-2016, FunctionX Next