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

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.

Figure

SAP Business One Purchase Order