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

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. Your assignment is to build the database tables and fields to link to a database form similar to the one shown in Figure.

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

SAP Business One Purchase Order