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

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 Expert Approved Answer
Step: 1 Unlock

1 There are three tables Vendor Pur... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Word file Icon

405-B-A-I-S (6371).docx

120 KBs Word File

Students Have Also Explored These Related Accounting Questions!