6.37 Tech Tool: Database Software Software Videos: Database Tables Refer to the SAP Business One sales order form for an integrated enterprise system shown in Figure 6.7. Your assignment is to build the database tables and fields to link to a database form similar to the one shown in Figure 6.7.

Use Microsoft Access database software and the following figure of MS Access tables to build the tables and fields.
1. Build the CUSTOMER table and select the primary key.
2. Build the SALES ORDER table and select the primary key.
3. Build the SALES ORDER LINE table and select the composite primary key.
4. Build the ITEM table and select the primary key.
S. Build the table relationships.
6. Print the table relationships.
7. Enter the following customer data into the CUSTOMER table and print.
Customer No.: C40000 Company Name: Alpha Corporation Contact Person: Daniel Brown Customer No.: C42000 Company Name: Beta Company Contact Person: Adam Green 8. Enter the following item data into the ITEM table and print.
Item No.: A0OO0l Item Description: IBM lnforprint 1312 In Stock: 801 Item No.: A00006 Item Description: HP 600 Series Printer In Stock: 87 Item No.: A00007 Item Description: HP 10 Premium Toner Cartridges In Stock: 59

Customer Customer No Company Name Contact Person Street Address City State Zip Country Email Website Sales Order Sales Order Ne Status Customer PO No Currency Posting Date Delivery Date Document Date Sales Employee No Discount Freight Sales Order Line Sales Order No New No Line Item Quantity Line Item Price After Discount Line Item Tax Telephone Tax Customer No Item Res No Bers Description In Stock