6.43 Tech Tool: Database Software Software Videos: Database Queries Your assignment is to build queries to retrieve vendor and item information using Microsoft Access database software. These are typical queries that would be used when completing a purchase order form as shown in Figure 6.16.

1. Download the data file for this exercise.

2. Build a query to retrieve vendor name and contact person when the vendor number is entered. For this query, use a search criteria of Vendor No. = V20000.