Question: The following figure shows a Microsoft Access query design screen for a vendor query. Use information provided on this figure to answer the following questions:
The following figure shows a Microsoft Access query design screen for a vendor query. Use information provided on this figure to answer the following questions:
1. How many tables are used in this query?
2. What fields will be displayed when the query is run?
3. What is the search criterion?

Vendor Purchase Order Purchase Order Line Y VENDOR NO Y PO NO 9 PO NO 9 TEM NO VENDOR NAME PO DATE PO SUBTOTAL PO TAX PO SHIPPING STREET ADDRESS LINE ITEM TOTAL QIY ORDERED QTY RECEIVED QTY BILLED CITY STATE ZIP PO APPROVED COUNTRY PO MISC LINE ITEM UNIT PRICE VENDOR NO LINE ITEM TAX LINE ITEM DISCOUNT Field: VENDOR NO Table: Vendor VENDOR NAME Vendor PO NO ITEM NO PO SUBTOTAL Purchase Order Purchase Order Line Purchase Order Sort Show: Criteria: "OnlineOffice
Step by Step Solution
3.52 Rating (166 Votes )
There are 3 Steps involved in it
1 There are three tables Vendor Pur... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
405-B-A-I-S (6371).docx
120 KBs Word File
