CategoryID CategoryName Description Picture mSysRowId
1 Beverages Soft drinks, coffees, teas, beers, and ales
U7NeqrK9FkShfcjzJ1FtRrUrZDvkgZxwdTmzmyh6TEc=-~gUQMqra4XRi1sH8FgALf7A==
2 Condiments Sweet and savory sauces, relishes, spreads, and seasonings
U7NeqrK9FkShfcjzJ1FtRrUrZDvkgZxwdTmzmyh6TEc=-~gUQMqra4XRi1sH8FgALf7A==
3 Confections Desserts, candies, and sweet breads
U7NeqrK9FkShfcjzJ1FtRrUrZDvkgZxwdTmzmyh6TEc=-~gUQMqra4XRi1sH8FgALf7A==
4 Dairy Products Cheeses
U7NeqrK9FkShfcjzJ1FtRrUrZDvkgZxwdTmzmyh6TEc=-~gUQMqra4XRi1sH8FgALf7A==
5 Grains/Cereals Breads, crackers, pasta, and cereal
U7NeqrK9FkShfcjzJ1FtRrUrZDvkgZxwdTmzmyh6TEc=-~gUQMqra4XRi1sH8FgALf7A==
6 Meat/Poultry Prepared meats
U7NeqrK9FkShfcjzJ1FtRrUrZDvkgZxwdTmzmyh6TEc=-~gUQMqra4XRi1sH8FgALf7A==
7 Produce Dried fruit and bean curd
U7NeqrK9FkShfcjzJ1FtRrUrZDvkgZxwdTmzmyh6TEc=-~gUQMqra4XRi1sH8FgALf7A==
8 Seafood Seaweed and fish
U7NeqrK9FkShfcjzJ1FtRrUrZDvkgZxwdTmzmyh6TEc=-~gUQMqra4XRi1sH8FgALf7A==
CustomerID CompanyName ContactName Address City PostalCode Country Phone
BONAP Bon app’ Laurence Lebihan 12, rue des Bouchers Marseille 13008 France 91.24.45.40
CHOPS Chop-suey Chinese Yang Wang Hauptstr. 29 Bern 3012 Switzerland 0452-076545
KOENE Königlich Essen Philip Cramer Maubelstr. 90 Brandenburg 14776 Germany 0555-09876
LILAS LILA-Supermercado Carlos González Carrera 52 con Ave. Bolívar #65-98 Llano Largo Barquisimeto 3508 Venezuela (9) 331-6954
RICSU Richter Supermarkt Michael Holz Grenzacherweg 237 Genève 1203 Switzerland 0897-034214
SAVEA Save-a-lot Markets Jose Pavarotti 187 Suffolk Ln. Boise 83720 USA (208) 555-8097
SPLIR Split Rail Beer & Ale Art Braunschweiger P.O. Box 555 Lander 82520 USA (307) 555-4680
WHITC White Clover Markets Karl Jablonski 305 – 14th Ave. S.
Suite 3B Seattle 98128 USA (206) 555-4112
WILMK Wilman Kala Matti Karttunen Keskuskatu 45 Helsinki 21240 Finland 90-224 8858
EmployeeID LastName FirstName Title HireDate Address City PostalCode mSysRowId
1 Davolio Nancy Sales Representative 5/1/12 507 – 20th Ave. E.
Apt. 2A Seattle 98122 qUHwlGqe+lJMauy85HeUeVAhTa9N8P7/m8kr1sWpbEI=-~/hkJMFV/jrN2O0wg1pGCTA==
2 Fuller Andrew Vice President, Sales 8/14/12 908 W. Capital Way Tacoma 98401 qUHwlGqe+lJMauy85HeUeVAhTa9N8P7/m8kr1sWpbEI=-~/hkJMFV/jrN2O0wg1pGCTA==
3 Lorah Ron Sales Representative 4/1/09 722 Moss Bay Blvd. Kirkland 98033 qUHwlGqe+lJMauy85HeUeVAhTa9N8P7/m8kr1sWpbEI=-~/hkJMFV/jrN2O0wg1pGCTA==
4 Peacock Margaret Sales Representative 5/3/08 4110 Old Redmond Rd. Redmond 98052 qUHwlGqe+lJMauy85HeUeVAhTa9N8P7/m8kr1sWpbEI=-~/hkJMFV/jrN2O0wg1pGCTA==
5 Buchanan Steven Sales Manager 10/17/05 14 Garrett Hill London SW1 8JR qUHwlGqe+lJMauy85HeUeVAhTa9N8P7/m8kr1sWpbEI=-~/hkJMFV/jrN2O0wg1pGCTA==
6 Suyama Michael Sales Representative 10/17/06 Coventry House
Miner Rd. London EC2 7JR qUHwlGqe+lJMauy85HeUeVAhTa9N8P7/m8kr1sWpbEI=-~/hkJMFV/jrN2O0wg1pGCTA==
7 King Robert Sales Representative 1/2/05 E
Grader – Instructions Access 2019 Project
Exp19_Access_Ch06_Capstone – Northwind Traders Sales Analysis 1.0
Project Description:
Northwind Traders is a small international gourmet foods wholesaler. You will update the company’s database by increasing the price of all of the meat and poultry products. You will make a table for archiving older order information. You will also summarize quantities sold by category and identify customers who have no orders.
Steps to Perform:
Step
Instructions
Points Possible
1
Start Access. Open the downloaded Access file named Exp19_Access_Ch6_Cap_Northwind. Grader has automatically added your last name to the beginning of the filename. Save the file to the location where you are storing your files.
0
2
Using a select query, you will identify all of the products with a category of meat or poultry, and then use an update query to increase the prices of the products.
Create a select query that includes the CategoryID from the Categories table and the UnitPrice and ProductName fields from the Products table (in that order). Run the query and note the CategoryID for Meat/Poultry.
8
3
Add the appropriate CategoryID criterion to limit the query output to only Meat/Poultry. Convert the query to an update query. Update the UnitPrice for Meat/Poultry only by increasing it by 6 percent.
8
4
View the query in Datasheet view prior to running it to make sure you are updating the correct (four) records. Return to Design view and run the query. Save the query as Update Meat/Poultry Prices. Close the query.
10
5
You will identify orders shipped during the first half of the year and create a new table in which to store them. You will then delete the orders from the current orders table.
Create a select query that identifies all of the orders shipped Between 1/1/2020 and 3/31/2020. Include all fields from the Orders table.
9
6
Convert the select query to a make table query. Name the new table Orders Archive. Run the query. Save the query as Make Orders Archive Table. Close the query.
6
7
Make a copy of the Make Orders Archive Table query and save it as Append Orders Archive Table. Open the Append Orders Archive Table query in Design view. Convert the make table query to an append query. The query will append to the Orders Archive table.
7
8
Modify the criteria to append orders shipped Between 4/1/2020 and 6/30/2020. Run the query, save it, and then close it.
6
9
Open the Orders Archive table in Design view and set OrderID as the primary key field. Switch to Datasheet view, then save and close the table.
4
10
Make a copy of the Append Orders Archive Table query and save it as Delete Archived Orders. Open the Delete Archived Orders query in Design view. Convert the append query to a delete query.
6
11
Modify the criteria to delete all archived orders from the Orders table (six records). Run, save, and then close the query.
7/26/2021 Integrated Report
https://openvellum.ecollege.com/course.html?courseId=16793454&OpenVellumHMAC=93f6c628f05cb91c374e67e6356a864d#10203 1/4
Score Card Detail
Total Score: 50%
Earned Points: 50pts
Possible Points: 100pts
Step Instruction Earned Possible
1 0 0
2 0 8
0 2.5
0 2.5
0 3
3 0 8
0 6
Start Access. Open the downloaded Access file named
Exp19_Access_Ch6_Cap_Northwind. Grader has automatically added
your last name to the beginning of the filename. Save the file to the
location where you are storing your files.
Using a select query, you will identify all of the products with a category of
meat or poultry, and then use an update query to increase the prices of
the products.
Create a select query that includes the CategoryID from the Categories
table and the UnitPrice and ProductName fields from the Products table
(in that order). Run the query and note the CategoryID for Meat/Poultry.
Query (Update Meat/Poultry Prices) was not detected in the submission.
Engine reported the failure as ‘The field ‘UnitPrice’ from ‘Products’ table
was not added in the query.’
Query (Update Meat/Poultry Prices) was not detected in the submission.
Engine reported the failure as ‘The field ‘CategoryID’ from ‘Categories’
table was not added in the query.’
Query (Update Meat/Poultry Prices) was not detected in the submission.
Engine reported the failure as ‘The query ‘Update Meat/Poultry Prices’
was not added in the database.’
Add the appropriate CategoryID criterion to limit the query output to only
Meat/Poultry. Convert the query to an update query. Update the UnitPrice
for Meat/Poultry only by increasing it by 6 percent.
Query (Update Meat/Poultry Prices) was not detected in the submission.
Engine reported the failure as ‘The UnitPrice field in query ‘Update
Meat/Poultry Prices’ was not updated by increasing it by 6 percent.’
7/26/2021 Integrated Report
https://openvellum.ecollege.com/course.html?courseId=16793454&OpenVellumHMAC=93f6c628f05cb91c374e67e6356a864d#10203 2/4
0 2
4 0 10
0 2
0 8
5 9 9
6 4 6
0 2
4 4
7 0 7
0 2
Query (Update Meat/Poultry Prices) was not detected in the submission.
Engine reported the failure as ‘The criteria for ‘CategoryID’ field in query
‘Update Meat/Poultry Prices’ was not to ‘6’.’
View the query in Datasheet view prior to running it to make sure you are
updating the correct (four) records. Return to Design view and run the
query. Save the query as Update Meat/Poultry Prices. Close the query.
Query (Update Meat/Poultry Prices) was not detected in the submission.
Engine reported the failure as ‘The name of the query was not to ‘Update
Meat/Poultry Prices’.’
The UnitPrice was not updated to increase it by 6 percent for the
Meat/Poultry records in the table ‘Products’.
You will identify orders shipped during the first half of the year and create
a new table in which to store them. You will then delete the orders from
the current orders table.
Create a selec
Why Choose Us
- 100% non-plagiarized Papers
- 24/7 /365 Service Available
- Affordable Prices
- Any Paper, Urgency, and Subject
- Will complete your papers in 6 hours
- On-time Delivery
- Money-back and Privacy guarantees
- Unlimited Amendments upon request
- Satisfaction guarantee
How it Works
- Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
- Fill in your paper’s requirements in the "PAPER DETAILS" section.
- Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
- Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
- From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.