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

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 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 Coast Jewelers 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.43 Rating (159 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a b Suppliers by Supplier ID Supplier ... 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 (1 attachment)

773-B-A-G-F-A (8711).docx

120 KBs Word File

Students Have Also Explored These Related Accounting Questions!

CASESTUDY: Corwin Corporation By June 2003, Corwin Corporation had grown into a $950 million per year corpora- tion with an international reputation for manufacturing low-cost, high-quality rubber...

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

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

Snick's Board Shop is interested in more effectively managing their inventory. Casey and Caitlin would like you to put together a database of their current inventory. Create a new database file using...

Create action queries for Coast Jewelers (after backing up your file) a. Create and run an action query for Coast Jewelers that increases the sales markup 5 percent for all categories. Save this...

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

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

Directions: Using the information provided, complete the following. 1) Identify the resources, events, and agents involved in The Kayak Rolls expenditure cycle and the relationships between those...

Paws for Thought is a small pet food chain in Ontario that sells premium made - inCanada products that do not have fillers or artificial colours added. You, CPA, the manager, are approached by the...

I have problems understanding this case study for database. can someone help me solve this. Deliverables: 1. Create a list with the main business rules 2. Identify the main Entity types and their...

Please try to answer all if possible :-) Practice Database - March 2021 1. Create a database in your HOME FOLDER, C-Database Systems called Practice March21.accdb a. Remember to click on the yellow...

2 Use the following information to answer problems 2a through 2e. Consider two all-equity financed firms, A and B Number of shares Price per share 4 b. Firm A 1,000,000 $30 Firm A estimates that the...

Given that loga 3 = 0.4771 and loga 5 = 0.6990. Use the laws of logarithms to find loga 45 correct to 4 decimal laces

Find the infinite sum o f the series k = 1 1 k 2 + 1 - 1 ( k + 1 ) 2 + 1 Show all o f your work.

Discuss the three objectives for developing and implementing performance measurement system? Justify your answer and make sure your answer is not copied and paste. It needs to be checked in Turnitin...

What are the key performance indicators of warehouse performance measurement? and discuss the customer perspective of the measurement. The answer must be not plagiarized!!! Please check it in...

What criteria should consider while determining the warehouse location for material handling and storage? Make sure the answer is not plagiarized

Discuss the implications of delivery in full on time to warehouse management? what are its limitations? The answers must be not plagiarized. Please must check it in Turnitin system.

1. The following data give the scxores in the final exams on differential equations and quantum mechanics that were received by 10 students randomly selected from a freshmen engineering class. Do...

Describe how Excel can be used to calculate an allowance for uncollectible accounts using the percent of sales method.

Describe how Excel can be used to calculate an allowance for uncollectible accounts using the aging method.

Compare the percent of sales and aging methods of determining uncollectible accounts expense and the ending allowance for the uncollectible accounts balance.

2. How much life insurance do you need? Calculating needs - Part1 Nick and Megan Doherty are 52 years old and have one daughter, age 14. Nick is the primary earner, making $80,000 per year. Megan...

For questions 5 - 9 , refer to the following problem: In choosing between four new jobs, a business graduate considers the potential payoffs over the next three years. The following table contains...

FIGURE 6.14 One-fund theorem. When both borrowing and lending at the risk-free rate are allowed, there is a unique fund F of risky assets that is efficient. All points on the efficient frontier are...