Tech Tool:Database SoftwareSoftware Videos:Database QueriesYour assignment is to build que...

Tech Tool:Database Software

Software Videos:Database Queries

Your assignment is to build queries to retrieve customer and item information using Microsoft Access database software. These are typical queries that would be used when completing a sales order form as shown in Figure.

1. Download the data file for this exercise.

---

2. Build a query to retrieve the company name and contact person when the customer number is entered. For this query, use a search criteria of Customer No. = C40000.

---

3. Build a query to retrieve item description and in stock information when the item number is entered. For this query, use a search criteria of Item No. = A00001.

Figure

SAP Business One Interface

Can you name some of the database tables that are used to build the sales order form?