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.
5. 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.: A00001
Item Description: IBM Inforprint 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
FIGURE 6.7
SAP Business One Interface
Can you name some of the database tables that are used to build the sales order form?
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.