Question: 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

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 locate field names.) The report should have no grouping, be sorted by supplier ID in ascending order, and be formatted in a tabular layout with portrait orientation. Save the report as Suppliers by Supplier ID. Make sure all field information is visible.
b. Create and print a report for What SUP that lists the supplier name, contact name, contact title, and phone number from the supplier table. (Use the supplier table to locate field names.) The report should have no grouping, be sorted by supplier name in ascending order, and be formatted in a tabular layout with portrait orientation. Save the report as Suppliers by Supplier Name. Make sure all field information is visible.

Step by Step Solution

★★★★★

3.48 Rating (165 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a b Suppliers by Supplier ID ... 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_605d88e15ea7b_680040.pdf

180 KBs PDF File

1512_605d88e15ea7b_680040.docx

120 KBs Word File

Students Have Also Explored These Related Using Microsoft Excel Questions!

Create new reports for Coast Jewelers a. Create and print a report for Coast Jewelers that lists the supplier ID, supplier name, and city from the supplier table. (Use the supplier table to locate...

Create new forms for What SUP (use the Ch9-02 file) a. Create and print a form for What SUP that lists all fields from the supplier table in a columnar format. Once again, use the supplier table to...

The Wine Depot is interested in more effectively managing their inventory. Barbara would like you to put together a database of their current wine inventory. Create a new database file using the...

One of the first processes performed in developing a new database and an associated application is to identify the entities involved in the current business operations and system (if a current system...

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

MS Access Assignment 1. This project requires the use of MS Access and Excel. If you are using a Mac or Apple computer, Microsoft does NOT have a version of Access for the Apple platform. There are 2...

CSCI2153 ERD Entity Relationship Diagram Lab#3-Visio Entity Identification Process One of the first processes performed in developing a new database and an associated application is to identify the...

I am having trouble with this lab and I am only getting 10 tables, not 13. Please help! CSCI2153 ERD Entity Relationship Diagram Using Visio Entity Identification Process One of the first processes...

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

Microsoft Access Chapter 1 - Lab Test A Due by the end of Lab Class Feb 2nd Creating an Electronic Accessories Database Purpose: To demonstrate the ability to create a database, create queries, a...

Suppose the company paid dividend of $10.2. That is, D0 is $10.2. What is the amount of dividend in Year 2? That is, what is D2? Assume that the dividends are expected to grow by 3% each year?

The nominal resistance of a wire is 0.20 ohm. A testing of the wire randomly chosen from a large collection of such wires yields the following resistance data. Obtain a 95% confidence interval for...

Consider the following regression equation: ln Y n i = 4.62 + 0.5X1i + 0.7X2i a. Predict the value of Y when X1 = 8.5 and X2 = 5.2. b. Interpret the meaning of the regression coefficients b0, b1, and...

Suppose that the laboratory referred to in Exercise 8.7 decided not to run one group and compare it against , but instead to run two groups (one with and one without lesions). They still expect the...

Why is it important to back up your QuickBooks Accountant file?

When creating a new employee during the payroll setup process, what information is provided in the Payroll and Compensation Info tab?

Describe the process for telling QuickBooks Accountant you want to manage payroll manually.

Find NPV & ANPV at cost of capital 7.2%, which would you recommend? The ANPV for project N is $. (Round to the nearest cent.) Which project would you recommend? (Select from the drop-down menu.) The...

Consider the following two mutually exclusive projects: Year Cash Flow (A) Cash Flow (B) 0 --$418,000 -$36,500 1 47,500 19,700 2 58.500 14,000 3 75,500 15.100 4 533,000 11,900 The required return on...

Suppose that Acme Inc. is issuing 10-year bonds that are not callable. The required rate of return that the firm must pay to bondholders is 10%. They are also considering some callable bonds, which...