Question: I am taking a Microsoft Access class and I am on this assignment. I am on this EX_16_CH05_GRADER_ML1_HW - Hotel Chain and I am stuck
I am taking a Microsoft Access class and I am on this assignment. I am on this EX_16_CH05_GRADER_ML1_HW - Hotel Chain and I am stuck at Steps 7 through 10.
| 7 | The built-in functions in Access are powerful. The date functions allow you to use existing data to extract information out of the field. This query lets you see the average number in a party per month without you having to figure out the actual month name. Letting Access do the work will make sure the data is accurate. Delete the ServiceDate field from the Average By Month query. Add a new column using the Expression Builder. Create a formula to extract the name of the month from the ServiceDate field using a combination of the DatePart and MonthName functions. Name the column Month, and move the Month field to the left of the NumInParty field. Run the query. Save and close the query. | 20 |
| 8 | Create a copy of the Average By Month query. Name the new query Average By Month and Year. | 2 |
| 9 | Adding another group provides even better information to know the average number for each party for the year and month. Add a second grouping field between the Month and NumInParty fields. The field should display the four-digit year in the ServiceDate field. Name the new field Year. Sort by Year in ascending order. Run the query. Save and close the query. | 16 |
| 10 | Save the database. Close the database, and then exit Access. Submit the database as directed. | 0 |
Can anyone help me please.
DSmall
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
