Cindi asks you to update some information in the vendor database and


Cindi asks you to update some information in the Vendor database and also to retrieve specific information from the database. Complete the following: 1. Open the Vendor database you created and worked with in Tutorials 1 and 2, and then click the Enable Content button next to the security warning, if necessary. 2. Open the Supplier table in Datasheet view, and then change the following field values for the record with the Supplier ID GRE364: Address to 1550 W Main St, Contact Phone to 401-625-2745, Contact First Name to Andrew, and Contact Last Name to Kline. Close the table. 3. Create a query based on the Supplier table. Include the following fields in the query, in the order shown: Company, Category, Contact First, Contact Last, Phone, and Initial Contact. Sort the query in ascending order based on the Category field values. Save the query as Contact List, and then run the query. 4. Use the Contact List query datasheet to update the Supplier table by changing the Phone field value for Aresco Surgical, Inc. to 203-335-0054. 5. Change the size of the font in the Contact List query datasheet to 12 points. Resize columns, as necessary, so that all field values and column headings are visible. 6. Change the alternate row color in the Contact List query datasheet to the Theme Color named Green, Accent 6, Lighter 60%, and then save and close the query. 7. Create a query based on the Supplier and Product tables. Select the Company, Category, and State fields from the Supplier table, and the Product Name, Price, Units, and Weight fields from the Product table. Sort the query results in descending order based on price. Select only those records with a State field value of CT, but do not display the State field values in the query results. Save the query as CT Suppliers, run the query, and then close it. 8. Create a query that lists all products that cost more than $200 and are sterile. Display the following fields from the Product table in the query results: Product ID, Product Name, Price, Units, and Temp Control. (Hint: The Sterile field is a Yes/No field that should not appear in the query results.) Save the query as High Price And Sterile, run the query, and then close it. 9. Create a query that lists information about suppliers who sell equipment or products that require temperature control. Include the Company, Category, Contact First, and Contact Last fields from the Supplier table; and the Product Name, Price, Temp Control, and Sterile fields from the Product table. Save the query as Equipment Or Temp Control, run the query, and then close it. 10. Create a query that lists only those products that cost $1000 or more, along with a 5% discount amount based on the price of the product. Include the Company field from the Supplier table and the following fields from the Product table in the query: Product ID, Product Name, and Price. Save the query as High Price With Discount. Display the discount in a calculated field named Discount Amt that determines a 5% discount based on the Price field values. Set the Caption property Discount Amt for the calculated field. Display the query results in descending order by Price. Save and run the query. 11. Modify the format of the Discount Amt field in the High Price With Discount query so that it uses the Standard format and two decimal places. Run the query, resize all columns in the datasheet to their best fit, and then save and close the query. 12. Create a query that calculates the lowest, highest, and average prices for all products using the field names Lowest Price, Highest Price, and Average Price, respectively. Set the Caption property for each field to include a space between the two words in the field name. Run the query, resize all columns in the datasheet to their best fit, save the query as Price Statistics, and then close it. 13. In the Navigation Pane, copy the Price Statistics query, and then rename the copied query as Price Statistics By Supplier. 14. Modify the Price Statistics By Supplier query so that the records are grouped by the Company field in the Supplier table. The Company field should appear first in the query datasheet. Save and run the query, and then close it. 15. Compact and repair the Vendor database, and then close it.  



Calculate the price
Make an order in advance and get the best price
Pages (550 words)
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Australia Assessments
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Customer 456821, September 1st, 2022
Healthcare & Medical
Great work.
Customer 452441, May 11th, 2022
Great job
Customer 463961, May 13th, 2023
Critical Reading and Writing
Excellent responses. Be keen on Grammar.
Customer 460653, April 4th, 2022
Be keen on instructions.
Customer 460653, April 6th, 2022
Project Management
I gave a lower rating on the service because, a notification from the support team went out but it did not come to my email address. Had I not looked earlier on the website, then I would have been penalized for not turning in my paper on time. On my profile, I have a phone# and I also have an email address. Please set up a system to text or email new messages or notifications from the writer or support team. This will ensure that the order is processed in a timely manner. With the new and upcoming technology, this seems like it should be an easy fix to have a tool built in the website to email or text notifications of changes to orders. This is no reflection to the support team. I see this as a system issue and not a support team issue.
Customer 463323, September 26th, 2022
Great job
Customer 452947, January 22nd, 2020
good job
Customer 456821, April 4th, 2022
Business Studies
Great job!
Customer 462533, April 10th, 2022
the first time around paper was very poor and plagiarized according to grammaly with the help of online support it was reassigned and improved greatly
Customer 453819, February 20th, 2020
English 101
Always use Grammarly before submitting your papers.
Customer 462495, April 6th, 2022
Excellent work
Customer 456821, February 26th, 2022
Customer reviews in total
Current satisfaction rate
3 pages
Average paper length
Customers referred by a friend
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat