Question: Only need help with steps 1 1 and on . Only showing the previous steps in the photo linked to show context. 1 1 Add

Only need help with steps 11 and on. Only showing the previous steps in the photo linked to show context.
11
Add a criterion in Design view, to include only products with 8 as the CategoryID.
12
Sort the query results in ascending order by ProductName. Run, save, and close the query.
13
You want to create a query that displays actual category names rather than the CategoryIDs. You are interested to know which meat and poultry products are imported. You will copy the Seafood Products query and modify it to delete a field, then add an additional table and field.
Copy the Seafood Products query and paste it using Seafood Or Meat/Poultry as the query name.
14
Open the Seafood Or Meat/Poultry query in Design view and delete the CategoryID column.
15
Add the Categories table to the top pane of the query design window. Add the CategoryName field to the last column of the design grid and set the criterion as "Seafood" Or "Meat/Poultry". Run, save, and close the query.
16
You will create a query that identifies suppliers and their associated products. Because there is a relationship between the two tables, you can now pull data from each of them together as usable information.
Create a query in Design view that includes the Suppliers and Products tables. The query should list the company name, contact name, phone (in that order), then the product name and the product cost (in that order).
17
Sort the query by company name in ascending order, then by product cost in descending order. Run, close, and save the query as Company by Product List.
18
You determine that the data in the Company by Product List query could be summarized with a Total row. You will group the records by company name, and then count the number of products you buy from each of them.
Copy the Company by Product List query and paste it using Summary of Company by Product as the query name.
19
Open the Summary of Company by Product query in Design view and delete the ContactName,Phone, and ProductCost columns.
20
Click Totals in the Show/Hide group on the Query Tools Design tab. Click in the Total row of the ProductName field, click the arrow, and then select Count. The records will be grouped by the companys name and the products for each company will be summarized.
21
Modify the field name of the ProductName column as Product Count: ProductName to make the field name more identifiable. Click Run in the Results group (20 records display in the Datasheet). The results display the product count for each company that supplies your organization. Save and close the query.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!