Question: Edit select queries for Coast Jewelers. a. Edit Query 1 by adding the field Postal Code and deleting the field Stateor Province. Save this query

Edit select queries for Coast Jewelers.
a. Edit Query 1 by adding the field Postal Code and deleting the field Stateor Province. Save this query as Ch 11 Assignment 3a before you print it.
b. Edit Query2 to include the field Category Name and to include only the category Rings, sorted by product name in ascending order. Save this query as Ch 11 Assignment 3b before you print it.

Step by Step Solution

★★★★★

3.49 Rating (162 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a b Supplier Name Address Johnson Wholesale Jewelry Supply 10... 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 (8734).docx

120 KBs Word File

Students Have Also Explored These Related Accounting Questions!

Create additional select queries for Coast Jewelers using computed fields. a. Create and print a select query for Coast Jewelers that lists the product name and sales price for all watches, sorted in...

Create additional select queries for Coast Jewelers using statistics a. Create and print a select query for Coast Jewelers that calculates the total sales value of all rings in inventory. Save this...

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

Edit select queries for What SUP. (Use the Ch11-02 student file, or use the file you used in answering the previous question.) a. Edit Query1 by adding the field PostalCode from the Supplier Tableand...

could someone please help me these access assignment Accounting Information Systems Access Assignment S&S Revenue Database Introduction to Microsoft Access: Microsoft Access is representative of...

I am terrible at access and not sure on how to write the formulas. I have done what is in yellow. Can someone help this is due Friday at 10am Central Time. Attached is the rubric and all of the...

My name is Salam Abdulhussein and I need this to be done as soon as possible. Please follow the steps one by one and make sure everything is correct Global Bike, Inc. ERP for Sales / Collection USING...

Feclia wants to create special queries, forms, and reports in the database to help her manage club accounting.To help Felicia finish her work with the database, complete the following steps: 1.Open...

Multiply Choice 1. The concept of duality means that an REA diagram must consist of a. Two eventsone of them economic and the other support. b. Two agentsone of them internal and the other external....

A cut slope is to be made in a saturated clay. Given: The un-drained shear strength, cu = 26 kN/m2 (( = 0 condition), and ( = 18.5 kN/m3. The slope makes an angle, ( = 55 with the horizontal....

Given these one - and two - year discount factors, calculate the two - year annuity factor.

Suppose in Problem 54 that job satisfaction was related solely to years on the job, with the following data resulting. (a) Estimate the regression parameters and . (b) What is the qualitative...

In the last chapter you created some queries for the Snicks Board Shop. Now Caitlin would like you to help her create some forms to view information from the database. Make the following changes for...

Roseys Roses. Now the company would like you to help it create some forms to illustrate information from the database. Make the following changes using the ch11-06_student_name file you created in...

Why create a report from a query? Why not just print your query results?

Global Technology's capital structure is as follows: \ table [ [ Debt , 5 0 8 ] , [ Preferred stock, 3 5 ] , [ Common equity, 1 5 ] ] The aftertax cost of debt is 8 . 5 0 percent; the cost of...

Queen B Corp. has a current annual cash dividend policy of $3.00. The price of the stock is set to yield 10% return. What is the price of this stock today if the dividend will be paid for 10 year and...

Excess reserves of commercial banks which are deposited with Federal Reserve Banks are referred to as: (A) discount funds (B) certificates of deposit (C) excess equity funds (D) federal funds