Question: Create new queries for What SUP (use the Ch9-02 file) a. Create and print a query for What SUP that lists the supplier name, contact

Create new queries for What SUP (use the Ch9-02 file)
a. Create and print a query for What SUP that lists the supplier name, contact name, and phone number of every supplier. Save the query as Supplier Query 1.
b. Create and print another query for What SUP that lists the supplier name, address, city, and state of every supplier. Save the query as Supplier Query 2.

Step by Step Solution

★★★★★

3.35 Rating (167 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a b Academy Naish Bark Infinity Ron Hou... View full answer

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 (2 attachments)

1512_605d88e15e966_680038.pdf

180 KBs PDF File

1512_605d88e15e966_680038.docx

120 KBs Word File

Students Have Also Explored These Related Using Microsoft Excel Questions!

Create and edit tables for What SUP (use the Ch9-02 file) a. Create a new table for What SUP that includes fields BuyerID, BuyerName, and BuyerPhone. The first field (BuyerID) is a Number data type;...

Create new reports for What SUP (use the Ch9-02 file) a. Create and print a report for What SUP that lists the supplier ID, supplier name, and city from the supplier table. (Use the supplier table to...

Create new queries for Coast Jewelers a. Create and print a query for Coast Jewelers that lists the supplier name, contact name, and phone number of every supplier. Save the query as Supplier Query...

please help, show all steps via Access WIMINTA Drugo resultave View CS ** AA EE TUOVA 2.4 2232-2- Normal ASSIGNMENTAL International Food International Foodies is grow foods from the world. Younded...

Create select queries for What SUP. (Use the Ch11-02 student file, or use the file you used in answering the previous question.) a. Create and print a select query that lists the product name,...

Create action queries for What SUP. (Use the Ch11-02 student file, or use the file you used in answering the previous question.) a. Create and run an update query that increases the unit price for...

PLEASE BE QUICK AS YOU CAN Consider the Bakery Database described in class and answer the following questions based on this database. How many fields are shown as a result of the 5Price...

Course Project Case Study A grocery chain, CariMart, has decided to streamline their processes by introducing a new supply chain management information system (SCMIS) using a Just-In-Time strategy....

please help me complete the Flowchart assignment, I attach a file about standard flowchart symbols for you. Acct53014 Flowchart Assignment First review all the flowchart videos on Blackboard and...

Andrea Risso is a junior analyst with AquistareFianco, an independent equity research firm. Risso's supervisor asks her to update, as of January 1, 2015, a quarterly research report ffor Centralino...

When estimating fixed and variable costs, it is possible to have an equation with a negative intercept. Does this mean that at zero production the company has negative fixed costs?

The framework used by manay publicly traded companies to demonstrate compliance with internal control expectations resulting from SEC technology - related financial reporting requirements is Question...

Lets extend Aronsons study (discussed in Section 8.5) to include women (who, unfortunately, often dont have as strong an investment in their skills in mathematics). For women we expect means of 8.5...

Restore the file Boston Catering. Do not use the file created in Exercise 1. Add the following transactions and then print a standard balance sheet as of 7/31/10. a. On 7/13/10, the company purchased...

Describe some of the investing activities you recorded for Wild Water in January.

A company made an initial public offering (IPO) by selling new shares for new investment funding The par value of the share is $4.00 and 450,000 units of share were sold The selling price of the IPO...

A company is analyzing the makeup of its employees according to their education level and gender using the contingency table below. What is the expected value in the shaded cell? Male Female Row...

Question 5 One really important concept to understand in finance is the difference between simple and compounded interest. This simply concept has many ramifications for how we value different...