6.41 Tech Tool: Database Software Software Videos: Database Tables Refer to the SAP Business One purchase order form for an integrated enterprise system shown in Figure 6.16. Your assignment is to build the database tables and fields to link to a database form similar to the one shown in Figure 6.16. Use Microsoft Access database software and the following figure of MS Access tables to build the required tables and fields. 1. Download the data file for this exercise. 2. Build the VENDOR table and select the primary key. 3. Build the PURCHASE ORDER table and select the primary key. 4. Build the PURCHASE ORDER LINE table and select the composite primary key. 5. Build the table relationships. 6. Print the table relationships. 7. Enter the following vendor data into the VENDOR table and print. Vendor No.: V20000 Vendor Name: LaserCom Contact Person: Mary Brown Vendor No.: V21000 Vendor Name: SportMax Contact Person: Tina Sharp Vendor No.: V22000 Vendor Name: Soccer World Contact Person: Tomas Angel

Customer Customer No Company Name Contact Person Street Address City State Zip Country Email Website Sales Order Sales Order No Status Customer PC No Currency Posting Date Delivery Date Document Date Sales Employee No Discount Freight Sales Order Line Sales Order No Iters No Line Item Quantity Line Item Price After Discount Line Item Tax Telephone Customer No Vendor Vendor No Vendor Name Contact Name Street Address City State Zip County Website Purchase Order Purchase No Status Posting Date Delivery Date Document Date Reference Number Discount Freight Tax Vendar No Buyer Purchase Order Line Purchase No Item No Qty Price After Discount Item Hem No Item Description In Stock