Hi, Anyone has solutions for Y not flowers project requirment 4? I know here missed data and backgroud.

Requirement 34: Construct the reports requested below using the Query Design tool in Access. Sur ce port is changing throughout constructions pour nos do petorvence remember Homework 5 and 6 asked you to perform imitar queries. A) Total Soles: Provide a report for Total Sales at Y Not Flowers B) Gross Prontal: Provide report of Total Sales by Y Not Flowers store. Each store should show up in your report only one time. Your report should begin with the store that has the highest sales at the top and conclude with the least sales at the bottom c) Gross Pront #2: Provide a report of COGS by Y Not Flowers store (using standard costs). Each store should show up in your report only one time. Your report should begin with the location that has the highest COGS at the top and conclude with the least COGS at the bottom D) Depreciation: Provide a report of quarterly depreciation for each of the Y Not Flowers store locations. This report should be sorted by store number from lowest number to highest number. E) AVR #1: Provide a report of Sales by Customer. This report should be sorted by customer number from the lowest number to the highest number. F) A/R #2: Provide a report of Cash Receipts by Customer. This report should be sorted by customer number from the lowest number to the highest number. G) BONUS #1: The two queries provided above are the building blocks of a Customer's A/R balance. Compile a Query that displays Customer A/R balances as of 2/28/22 sorted from the highest balance to the lowest balance. This one is a little trickler than the others, which is why it is a bonus question. H) A/P #1: Provide a report of Purchases by Grower. This report should be sorted by customer number from the lowest number to the highest number. 1 A/P #2: Provide a report of Cash Disbursements by Grower. This report should be sorted by customer number from the lowest number to the highest number. 3) BONUS #2: The two queries provided above are the building blocks of a Customer's A/R balance. Compile a Query that displays Grower A/P balances as of 2/28/22 sorted from highest balance to the lowest balance. This one is a little trickier than the others, which is why it is a bonus question. K) CREATE-YOUR-OWNI Sy's fish is looking for a way to boost overall sales. Management is requesting a report that could help them achieve that goal. Construct a query that provides a report that would inform management's strategi decision making around boosting sales. Make sure your query includes all of the commands we've discussed in class thus far (Select, From, GroupBy, Orderby, Where/Having) Requirement 34: Construct the reports requested below using the Query Design tool in Access. Sur ce port is changing throughout constructions pour nos do petorvence remember Homework 5 and 6 asked you to perform imitar queries. A) Total Soles: Provide a report for Total Sales at Y Not Flowers B) Gross Prontal: Provide report of Total Sales by Y Not Flowers store. Each store should show up in your report only one time. Your report should begin with the store that has the highest sales at the top and conclude with the least sales at the bottom c) Gross Pront #2: Provide a report of COGS by Y Not Flowers store (using standard costs). Each store should show up in your report only one time. Your report should begin with the location that has the highest COGS at the top and conclude with the least COGS at the bottom D) Depreciation: Provide a report of quarterly depreciation for each of the Y Not Flowers store locations. This report should be sorted by store number from lowest number to highest number. E) AVR #1: Provide a report of Sales by Customer. This report should be sorted by customer number from the lowest number to the highest number. F) A/R #2: Provide a report of Cash Receipts by Customer. This report should be sorted by customer number from the lowest number to the highest number. G) BONUS #1: The two queries provided above are the building blocks of a Customer's A/R balance. Compile a Query that displays Customer A/R balances as of 2/28/22 sorted from the highest balance to the lowest balance. This one is a little trickler than the others, which is why it is a bonus question. H) A/P #1: Provide a report of Purchases by Grower. This report should be sorted by customer number from the lowest number to the highest number. 1 A/P #2: Provide a report of Cash Disbursements by Grower. This report should be sorted by customer number from the lowest number to the highest number. 3) BONUS #2: The two queries provided above are the building blocks of a Customer's A/R balance. Compile a Query that displays Grower A/P balances as of 2/28/22 sorted from highest balance to the lowest balance. This one is a little trickier than the others, which is why it is a bonus question. K) CREATE-YOUR-OWNI Sy's fish is looking for a way to boost overall sales. Management is requesting a report that could help them achieve that goal. Construct a query that provides a report that would inform management's strategi decision making around boosting sales. Make sure your query includes all of the commands we've discussed in class thus far (Select, From, GroupBy, Orderby, Where/Having)