Open the Order Totals By Month query in Design view. Change the first column so that instead of grouping by the order date, you group by the month. Use the DatePart function to extract the month from the date. Name the column MonthNumber. Run the query. The first line should read 5 (as the month, representing May), with a total of $1409.17. Save and close the query.\

Please help with step by step work in access.