Tech Tool: Database SoftwareSoftware Videos: Database TablesRefer to the SAP Business One...

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

FIGURE 6.16

SAP Business One Purchase Order