6.39 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 6.7.

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. = A0OO0l.