Chapter 4. Exercise 2
Prev     Next

Chapter 4. Exercise 2

  1. Open the AA Enterprises database

  2. Edit the CUSTOMERS table and change the field size of PostalCode to 4

  3. Change the TelNo and FaxNo fields to Text

  4. Add a field called Date and set it to display in the following format : MM/DD/YYYY

  5. Save the table

  6. Create a new table called ORDERS with the following fields

    Fieldname Type Width
    OrderID Number  
    CustomerID Number  
    Date Date  
    Amount Number  

  7. Make OrderID the primary key

  8. Save the table as ORDERS

  9. Create a relationship between the CUSTOMERS and ORDERS tables on the CUSTOMERID field

  10. Close the database

Prev  Up  Next
Chapter 3. Exercise 1  Home  Chapter 5. Exercise 3