Question: I need help specifically with steps 7,8, and 9 but would prefer for the entire problem to be worked to double-check the answers. Project Description:
I need help specifically with steps 7,8, and 9 but would prefer for the entire problem to be worked to double-check the answers.
Project Description:
You are the general manager of a large hotel chain. Your establishment provides a variety of guest services ranging from rooms and conferences to weddings. The data entry accuracy of your staff could bear some improvement, so you have decided to move to Microsoft Access and implement several data validation techniques. You also will take advantage of Access's Expression Builder to help analyze data.
Steps to Perform:
| Step | Instructions | Points Possible |
| 1 | Start Access. Open the file named CAccess_Ch05_ML1_Hotel. Grader has automatically added your last name to the beginning of the filename. | 0 |
| 2 | The first thing that you would like to ensure is that members phone numbers are entered into the database accurately in the common format for phone numbers. To do this you will add an input mask that will show the user the desired format as they are entering phone numbers. Open the Members table in Design view. Add a phone number input mask to the Phone field. Accept all defaults. Save and close the table. | 10 |
| 3 | Next you would like to ensure that the City and Address fields must be filled out for each location in the Location table. Open the Location table in Design view. Change the Required property for the City and Address fields to Yes. | 20 |
| 4 | Youd like to next make it easier for users to add information on the last time a location was renovated. You will convert the LastRenovation field in the Location table to a lookup field, using the Renovation table as the source for the values in the lookup field. Convert the LastRenovation field to a Lookup Wizard. Look the values up in the Renovation table. Save and close the Location table. | 15 |
| 5 | The hotel can only host parties of no more than 70 people at a time. You would like to ensure that parties of more than 70 people are not permitted in the Order table. To do this you will add a data validation rule to the NumInParty field of the Orders table. Open the Orders table in Design view. Add a validation rule that requires the value of the NumInParty field to be less than or equal to 70. Set validation text to Party sizes cannot exceed 70. (include the period). Save and close the Orders table. | 15 |
| 6 | It would be useful for you to know what the average party size is month over month. Youll find this information by creating a query and extracting the month from the ServiceDate field via the DatePart function then using the MonthName function to display the month name rather than the month number. Create a copy of the Average By Day query. Name the new query Average By Month. Open the query in Design view. | 2 |
| 7 | 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 | Now that you know what the average party size is month over month, you would like to include the year as well. Youll add this information to a new query by extracting the year from the ServiceDate field via the Year function. Create a copy of the Average By Month query. Name the new query Average By Month and Year. | 2 |
| 9 | 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 |
| Total Points | 100 |
Home Tell me what you want to do File N D C Refresh AL X Delete More All Ac... Click to Add- Location nnnn ovation Create External Data Database Tools Help Table Fields Table X CH 21 Accending Selection Fher Il Descending Advanced For De Rome Sot Yoga Sort Location Members Service Location City Address LastRenovation I Washington Airport More than 10 Years 2 Pittsburgh Downtown Last Years 3 wbbade Downtown Between 5 and 10 years 4 Greensboro Manhattan Between 5 and 10 years 5 Orlando Loop More than 10 years 6 Bakersfield Point Last Years 7 Memphis Downtown More than 10 years 8 Indianapolis Airport Last Years Henderson Lake Last Years 10 Chandler Convention Center More than 10 Years 11 North Hemps Convention Center Last Years 12 Scottsdale Downtown Between 5 and 10 Years 13 San Antonio Downtown Last Years 14 Minneapolis Airport Between 5 and 10 Years 15 Tampa Downtown More than 10 years 16 Miami Strip More than 10 years 17 Tulsa Downtown Last Years 18 Plano Downtown More than 10 Years 19 Anaheim Downtowe Between 5 and 10 Years 20 San Jose Airport Between 5 and 10 Years X Cut Now face Calibri Y recunding Al Descending In Copy Selection Advanced Yh So View 8 1 A2 X Delete More V All Ac... MemNumber. LastName . FirstName. Join Date. Address City - State - 2 Phone - Click to Add 57 Melvin Hammond 2/16/2019 1886 Landings Court Waleska GA 101 99-631-738 Salade Joseph 2/27/2019 2011 Freehole Drive La Russell MO 64848 87521283 5908 Esther Newton 4/30/2019 2260 Baidaria Cirde Mason TX 76856 976-442-6929 5016 10/22/20582361 Lucy Road Port Lyden NY 13413 327.275-5053 5880 Saly Porter 4/28/2019 799 Black Pine Place Escalon CA 95320 330 345-3754 Gre Rivera 1/8/2019 823 Coldus Road Vantage WA 98950 958-764-4500 6025 Bertha Herrera 2/16/2019 90 Baranof Place Irvine CA 92603 600 206-8799 6083 Rachael Parker 1/18/2019 1467 Mayfair Grcle Babcock W 54413 300-309-3117 6511 Angle Hudson W8/2019 974 Copperbush Highway Norfolk VA 23519 322-596-6989 6786 Viola Larson 11/10/2018 2005 Egloff Terrace Russian Mission A 99657 822-629-419 6904 Douglas Owen 10/20/2018 194 Heisler Drive Wellesley Island NY 13540 711-939-2655 7025 Bob 1/12/2019 1110 Brookwood Road Greentop MO 67546 95-01-2213 7125 Arnold Edwards 10/10/2018 955 Penstemon Road Devine TX 78016 822-935-3509 7188 Atene Watkins 10/8/2018 1826 Gavin Drive Flint MI 48502 999-691-9407 7219 Leah Scott 2/23/2019 2376 Stemp Terrace Hazelwood MO 63042 224-635-1786 7345 Jamie 2/19/2019 2148 Seashore Road Lincoln KS 67455 711-860-6645 7439 Milton Lamb 2/24/2019 1115 Lake Sperard Road Park City MT 59063 569-925-5554 7831 Lynne Matthews 4/29/2019 648 Brownie Road Corpus Chris TX TAGS 300-333-003 8070 Opal 1/8/2019 1351 Academy Street Corpus Christi TX 78411 351-747-5267 8092 thel Gonzales 10/20/2018 760 Redoubt Avenue Merone 92359 22417766 8125 Kent 10/10/2018 262 Malcolm Boulevard Panguitch UT 34759 424-922-4380 8152 Trevor Simmons 11/10/2018 1338 Cortina Place Kendall IN 46755 300239-5809 3164 Mamie Cain 12/2019 734 Dure Boulevard Tidioute PA 16351 424-916-4105 8264 Eunice Roy 1/7/2019 580 Thornton Highway Bakersfield CA 93383 569-769-5113 8513 Gladys Henry 10/21/2018 1186 Sutwik Drive Pittsburgh PA 15212 555-533-7244 Phil 2/19/2039 251 tide Circle Mountain Chy GA 30562 30-05-464 9172 John Myers 2/14/2019 53 Fast Street West Palm Beach FL 33414 838-910-4653 9432 Maxine Ingram 10/22/2018 1460 Lake Shore Place Houston TX 77030 975-710-8611 9600 Matthew Norris 10/22/2018 908 Rudakol Avenue Duluth MN 55801 424-650-48 5600 Brad Mathis 1/9/2019 1082 Hawkeye way Livermore KY 42352 8079-3851 15 Search Hand N New Copy Formater 8 21 Ascending Selection The leading Advanced Pomove Sort 7 toggle Total Speling More View Find Refresh X Dulete- All Ac... UUUU 2 213 Orders we Orderib. Mer Number ServiceDate. Services. NuminParty Location. Click to Add 220 5129 12/29/2019 3 25 5 230 5129 12/29/2019 1 50 16 5129 12/29/2019 . 10 232 5129 12/29/2019 5 57 14 5129 12/29/2019 18 234 5129 12/29/2019 53 17 5195 12/31/2019 56 7 5195 12/31/2019 12 5196 12/31/2019 2 256 5196 12/31/2019 3 64 5196 12/31/2019 5196 12/31/2019 5 17 9600 1/3/2020 2 57 5 9600 1/3/2020 3 71 7 9600 1/3/2020 5 71 17 286 9600 1/3/2020 2 67 10 287 9000 1/1/2020 12 9600 1/3/2020 42 5 307 3771 1/7/2020 5 36 14 101 377: 1/7/2020 6 3 3771 1/7/2020 62 310 3771 1/1/2020 2 53 3 3771 1/7/2020 37 8 312 3771 1/7/2020 3 33 3 379 8164 1/12/2020 2 42 2 8164 1/12/2020 3 8164 1/12/2020 3 17 3164 1/12/2020 51 14 383 8164 1/12/2020 2 384 8164 1/12/2020 44 16 2009 8513 2/5/2020 60 17 1010 851) 3/5/2020 60 14 1011 8513 3/5/2020 2 46 12 2012 8513 3/5/2020 70 10 1013 8513 3/5/2020 27 2 300 F 25 20 Home Create External Data Database Tools Help Table Fields Table Tell me what you want to do xan Y 21 Ascending Selection The Descending Advanced Refren Do Remove Sort Yes AL X Delete Son All Ac... mex Away Day R Orderio . MemNumber - ServiceDate. ServiceID. NuminParty Location. Click to Add 1013 8513 3/5/2020 27 2 1014 8513 WS/2020 5 1099 2439 3/30/2020 68 17 1100 7439 3/10/2020 30 16 3103 7430 1/30/2020 41 38 1102 1/10/2020 5 50 12 1103 7439 3/30/2020 14 1104 7419 1/30/2020 64 3 1117 8070 3/11/2020 8000 3/11/2020 1 14 1119 8070 1/11/2020 2 54 6 1120 8070 3/11/2020 6 63 16 1121 8000 1/11/2020 73 7 1122 8070 3/11/2020 48 15 4298 3/16/2020 54 5 1190 4290 1/16/2020 7 1191 4258 3/16/2020 1 1192 4290 3/16/2020 47 10 3193 429 1/16/2020 40 30 1194 4298 3/16/2020 65 5 1591 7125 4/1/2020 5 1592 7125 4/1/2020 1503 7125 4/1/2020 5 28 12 1594 7125 4/1/2020 26 16 1595 7125 4/1/2020 44 11 1596 7125 4/1/2020 63 19 4/1/2020 1652 4/1/2020 75 1 3814 4/1/2020 48 16 3654 3814 4/1/2020 2 14 1655 4/1/2020 1 57 14 1656 3814 4/1/2020 6 66 1795 3291 4/3/2020 57 30 1796 3291 4/3/2020 40 1797 3291 4/1/2020 69 10 2 All Ac... Record motion Sam Orderio . MemumberServiceDate. ServiceID NuminParty Location. Click to Add- 1797 3291 4/1/2020 69 1798 3291 4/3/2020 1 11 1799 3291 4/3/2020 19 1800 3291 4/1/2020 19 226) 3416 4/9/2020 72 2264 3416 4/9/2020 37 2265 3410 4/9/2020 72 2 2266 3416 4/9/2020 66 6 2267 3416 4/9/2020 45 34 2268 3416 4/9/2020 16 2407 4010 4/11/2020 2 4 2408 1000 4/11/2020 2 53 2409 4030 4/11/2020 33 19 2410 4030 4/11/2020 1 38 3 2411 2010 4/11/2020 2412 4030 4/11/2020 1 57 5 2629 9800 4/14/2020 3 45 1 2650 9.00 4/14/2020 26 19 4/14/2020 60 1 2632 9600 4/14/2020 1 22 18 4/14/2020 71 2634 9600 4/14/2020 6 51 2641 4736 4/34/2020 74 2642 4736 4/14/2020 68 8 2643 4736 4/14/2020 30 2641 4736 4/14/2020 . 75 1 2645 4736 4/14/2020 1 55 10 2646 4736 4/34/2020 5 10 2773 4/15/2020 49 2714 6786 4/15/2020 45 9 6786 4/19/2020 51 12 2776 6786 4/15/2020 5 53 7 2777 4/15/2020 1 18 2778 6736 4/19/2020 1 5 2797 4/16/2020 56 36 2775 All Ac... Location motion 3562 Sort motion Service vagy Orderi MemNumber - ServiceDate Service - NuminParts Location. Click to Add 0797 3562 4/16/2020 56 16 2795 3562 4/16/2020 3 28 19 2790 3562 4/16/2020 1 45 19 2800 3562 4/16/2020 5 74 2001 4/16/2020 5 26 12 2802 3562 4/16/2020 3 38 12 2007 7 4/19/2020 3008 7188 4/19/2020 26 11 2009 718 4/19/2020 73 1010 7 4/19/2020 9 3011 7188 4/19/2020 1 52 13 3012 7188 4/19/2020 3 14 1295 5144 4/24/2020 66 11 5344 4/24/2020 59 1 3297 5344 4/24/2020 25 4/24/2020 2 3: * 5344 4/24/2020 2 75 18 3300 5144 4/24/2020 4 55 16 3421 7345 4/26/2030 2 4 17 3422 7345 4/26/2020 32 142) 7345 4/20/2020 5 3424 7345 4/26/2020 34 9 3425 7345 4/26/2020 7 1426 7345 4/26/2020 2 4: 17 3775 6083 5/1/2020 42 12 3776 5083 5/1/2020 60 9 1777 6050 5/1/2020 . 32 . 3778 6083 5/1/2020 3 53 3779 5/1/2020 66 20 5/1/2020 2 50 4 3787 9172 5/1/2020 2 32 7 3788 9172 5/1/2020 2 28 1 3789 9172 5/1/2020 1 36 17 3790 9172 5/1/2020 1 69 17 3793 9172 5/1/2020 10 Record 10228 Sew * All Ac... - + mex Orders x Service Day Orderi. MemNumber - ServiceDate. Service. NuminPart) - Location - Click to Add. 1791 972 5/1/2020 SE 10 9172 5/1/2020 75 7 3985 7219 5/4/2020 12 3986 7219 5/4/2020 4 37 1 3987 7219 5/4/2020 3 45 14 1988 7219 5/9/2020 6 20 1 3983 7210 5/4/2020 22 3990 7219 5/4/2020 3 29 10 4385 2007 5/2020 5 51 1 4286 5/8/2020 1 35 15 4787 4007 5/8/2020 1 42 13 435 4007 502020 5 45 2 4189 4007 5/8/2020 3 65 S 4007 5/8/2020 2 60 9 5/17/2020 3 54 2 4934 5/17/2020 4 17 4935 5899 5/17/2020 60 20 49.36 5/17/2020 5 58 13 4937 5899 5/17/2020 4 75 15 49 5/17/2020 5 51 13 5023 3370 5/17/2020 5 45 14 5039 5/17/2020 69 3 5033 3370 5/17/2020 3 31 19 5032 3370 5/17/2020 6 39 2 5033 3370 5/17/2020 4 30 12 5034 5/17/2020 55 15 5317 5378 5/21/2020 4 25 7 53 5178 5/21/2020 25 14 5319 SU 5/21/2020 1 73 11 5320 5378 5/21/2020 3 43 3 5178 5/21/2020 15 5322 5378 5/21/2020 13 8092 5/21/2020 39 8 512 2002 5/21/2020 3 59 12 8092 5/21/2020 25 11 Search 310 3370 Home Q View Find > S All Ac... innnn 8135 Create Baternal Data Database Tools Help Table Fields Table Tell me what you want to do Y 21 Ascending Selections The Descending Advanced Save Refresh Format Pomove Son Y AL More Son dhe Ondex Orderi. Member ServiceDate. Service. NuminParty Location. Click to Add . 5343 8092 5/21/2020 46 5344 8092 5/21/2020 63 19 5145 8092 5/21/2020 71 5.345 8092 5/21/2020 50 7 6127 5980 5/30/2020 50 6128 5980 5/30/2020 612) 5380 5/30/2020 19 6130 5980 5/30/2020 35 14 6131 5980 5/30/2020 6132 5980 5/30/2020 26 4427 6/3/2020 74 8125 6/3/2020 12 5429 8125 6/3/2020 1 6430 8125 6/2/2020 5 59 8125 6/3/2020 49 7 6432 8125 6/3/2020 55 18 7099 5908 6/12/2020 1 68 20 7100 5908 6/12/2020 6 14 7101 5908 6/12/2020 36 12 7102 5908 6/12/2020 50 17 7103 5908 6/12/2020 13 7104 5908 6/12/2020 71 15 7117 5970 6/12/2020 2 2 7118 5976 6/12/2020 74 7119 5976 6/12/2020 2 13 7120 5970 6/12/2020 70 7121 5976 6/12/2020 4 7122 5976 6/12/2020 49 7993 6005 6/22/2020 21 31 7994 6005 6/22/2020 47 11 7995 5005 6/22/2020 57 7 7996 6005 6/22/2020 65 6025 6/22/2020 44 2 7994 6005 6/22/2020 29 13 170 6511 6/30/2020 57 15 30 num Q Find View Spelling M 3 12 All Ac... R be Xan Y Fh Descending Advanced Save formatie Do Re Son Y Clipboard Sort Recorde Order A Day Orderlo. MemNumber ServiceDate. Service - NuminPart) - Location. Click to Add. 7121 5976 6/12/2020 7122 5976 6/12/2020 6005 6/22/2020 11 7994 6025 6/22/2020 47 11 7995 6095 6/22/2020 57 7 2996 6005 6/22/2020 3 65 7997 6025 6/22/2020 4 2 7998 6005 6/22/2020 13 8707 6511 6/30/2020 57 15 3701 6511 6/30/2020 1 8709 6511 6/30/2020 53 6 8710 6511 6/30/2020 5 17 8711 6511 6/30/2020 8712 6511 6/30/2020 68 8797 3214 7/1/2020 40 8796 1234 7/1/2020 8999 3234 7/1/2020 51 3800 3234 7/1/2020 40 8801 3234 7/1/2020 68 8802 3234 7/1/2020 46 6 7/2/2020 29 2 7/2/2020 2 30 18 8152 7/2/2020 5 18 3800 7/2/2020 7 8152 7/2/2020 74 11 7/2/2020 9 1941 9432 7/2/2020 33 8942 9432 7/2/2020 5 2 3943 9432 7/2/2020 41 5 7/2/2020 3 39 5 8945 9432 7/2/2020 5 3905 9432 7/2/2020 3 53 1 200320 Home Tell me what you want to do New Paresh sp X Delete- Create External Data Database Tools Help Table Field Table XH 21 Aunding Selection Coy Fher 1 Descending Advanced Formater Domove Sort Clipboard Sort Orders La Renovated Click to Add- Between Sand 10 Yeart Last Years More than 10 years expel Cor All Ac... Tables ) N View Home Create External Data Database Tools Help Table Fields Table xan 21 Ascending Selection The Descending Advanced For Sort Tell me what you want to do New Save Sing Refresh More Q? All Ac. Service 175 UU ServiceName . Per PersonCharge Click to Add Room 2 Conference Room 13 Suite 4 Banquet S Wedding 25 Event 22 Fle Home More All Ac... Tables 512 Create External Data Database Tools Help Tell me what you want to do 21 Ascending Selection Sar Fher 11 Descending Advanced format AB Remove Sort Yleihe pboard Location Member des Renovation Service Average By Day ServiceDate. Argumi Party 12/29/2015 49.8 12/31/2019 49.5 1/3/2020 1/7/2020 48.3 1/12/2020 47.5 3/5/2020 49.5 3/10/2020 520 3/11/2020 59.8 3/16/2020 4/1/2020 47.5 4/3/2020 515 4/9/2020 53.5 4/11/2020 422 4/14/2020 525 4/15/2020 53.2 4/16/2020 45 4/19/2020 49.0 4/24/2020 520 4/26/2020 40 5/1/2020 501 5/4/2020 195 5/8/2020 502 5/17/2020 518 5/21/2020 48.0 5/30/2020 40 6/3/2020 59.3 6/12/2020 6/22/2020 6/30/2020 562 7/1/2020 452 7/2/2020 438 Home Tell me what you want to do File N D C Refresh AL X Delete More All Ac... Click to Add- Location nnnn ovation Create External Data Database Tools Help Table Fields Table X CH 21 Accending Selection Fher Il Descending Advanced For De Rome Sot Yoga Sort Location Members Service Location City Address LastRenovation I Washington Airport More than 10 Years 2 Pittsburgh Downtown Last Years 3 wbbade Downtown Between 5 and 10 years 4 Greensboro Manhattan Between 5 and 10 years 5 Orlando Loop More than 10 years 6 Bakersfield Point Last Years 7 Memphis Downtown More than 10 years 8 Indianapolis Airport Last Years Henderson Lake Last Years 10 Chandler Convention Center More than 10 Years 11 North Hemps Convention Center Last Years 12 Scottsdale Downtown Between 5 and 10 Years 13 San Antonio Downtown Last Years 14 Minneapolis Airport Between 5 and 10 Years 15 Tampa Downtown More than 10 years 16 Miami Strip More than 10 years 17 Tulsa Downtown Last Years 18 Plano Downtown More than 10 Years 19 Anaheim Downtowe Between 5 and 10 Years 20 San Jose Airport Between 5 and 10 Years X Cut Now face Calibri Y recunding Al Descending In Copy Selection Advanced Yh So View 8 1 A2 X Delete More V All Ac... MemNumber. LastName . FirstName. Join Date. Address City - State - 2 Phone - Click to Add 57 Melvin Hammond 2/16/2019 1886 Landings Court Waleska GA 101 99-631-738 Salade Joseph 2/27/2019 2011 Freehole Drive La Russell MO 64848 87521283 5908 Esther Newton 4/30/2019 2260 Baidaria Cirde Mason TX 76856 976-442-6929 5016 10/22/20582361 Lucy Road Port Lyden NY 13413 327.275-5053 5880 Saly Porter 4/28/2019 799 Black Pine Place Escalon CA 95320 330 345-3754 Gre Rivera 1/8/2019 823 Coldus Road Vantage WA 98950 958-764-4500 6025 Bertha Herrera 2/16/2019 90 Baranof Place Irvine CA 92603 600 206-8799 6083 Rachael Parker 1/18/2019 1467 Mayfair Grcle Babcock W 54413 300-309-3117 6511 Angle Hudson W8/2019 974 Copperbush Highway Norfolk VA 23519 322-596-6989 6786 Viola Larson 11/10/2018 2005 Egloff Terrace Russian Mission A 99657 822-629-419 6904 Douglas Owen 10/20/2018 194 Heisler Drive Wellesley Island NY 13540 711-939-2655 7025 Bob 1/12/2019 1110 Brookwood Road Greentop MO 67546 95-01-2213 7125 Arnold Edwards 10/10/2018 955 Penstemon Road Devine TX 78016 822-935-3509 7188 Atene Watkins 10/8/2018 1826 Gavin Drive Flint MI 48502 999-691-9407 7219 Leah Scott 2/23/2019 2376 Stemp Terrace Hazelwood MO 63042 224-635-1786 7345 Jamie 2/19/2019 2148 Seashore Road Lincoln KS 67455 711-860-6645 7439 Milton Lamb 2/24/2019 1115 Lake Sperard Road Park City MT 59063 569-925-5554 7831 Lynne Matthews 4/29/2019 648 Brownie Road Corpus Chris TX TAGS 300-333-003 8070 Opal 1/8/2019 1351 Academy Street Corpus Christi TX 78411 351-747-5267 8092 thel Gonzales 10/20/2018 760 Redoubt Avenue Merone 92359 22417766 8125 Kent 10/10/2018 262 Malcolm Boulevard Panguitch UT 34759 424-922-4380 8152 Trevor Simmons 11/10/2018 1338 Cortina Place Kendall IN 46755 300239-5809 3164 Mamie Cain 12/2019 734 Dure Boulevard Tidioute PA 16351 424-916-4105 8264 Eunice Roy 1/7/2019 580 Thornton Highway Bakersfield CA 93383 569-769-5113 8513 Gladys Henry 10/21/2018 1186 Sutwik Drive Pittsburgh PA 15212 555-533-7244 Phil 2/19/2039 251 tide Circle Mountain Chy GA 30562 30-05-464 9172 John Myers 2/14/2019 53 Fast Street West Palm Beach FL 33414 838-910-4653 9432 Maxine Ingram 10/22/2018 1460 Lake Shore Place Houston TX 77030 975-710-8611 9600 Matthew Norris 10/22/2018 908 Rudakol Avenue Duluth MN 55801 424-650-48 5600 Brad Mathis 1/9/2019 1082 Hawkeye way Livermore KY 42352 8079-3851 15 Search Hand N New Copy Formater 8 21 Ascending Selection The leading Advanced Pomove Sort 7 toggle Total Speling More View Find Refresh X Dulete- All Ac... UUUU 2 213 Orders we Orderib. Mer Number ServiceDate. Services. NuminParty Location. Click to Add 220 5129 12/29/2019 3 25 5 230 5129 12/29/2019 1 50 16 5129 12/29/2019 . 10 232 5129 12/29/2019 5 57 14 5129 12/29/2019 18 234 5129 12/29/2019 53 17 5195 12/31/2019 56 7 5195 12/31/2019 12 5196 12/31/2019 2 256 5196 12/31/2019 3 64 5196 12/31/2019 5196 12/31/2019 5 17 9600 1/3/2020 2 57 5 9600 1/3/2020 3 71 7 9600 1/3/2020 5 71 17 286 9600 1/3/2020 2 67 10 287 9000 1/1/2020 12 9600 1/3/2020 42 5 307 3771 1/7/2020 5 36 14 101 377: 1/7/2020 6 3 3771 1/7/2020 62 310 3771 1/1/2020 2 53 3 3771 1/7/2020 37 8 312 3771 1/7/2020 3 33 3 379 8164 1/12/2020 2 42 2 8164 1/12/2020 3 8164 1/12/2020 3 17 3164 1/12/2020 51 14 383 8164 1/12/2020 2 384 8164 1/12/2020 44 16 2009 8513 2/5/2020 60 17 1010 851) 3/5/2020 60 14 1011 8513 3/5/2020 2 46 12 2012 8513 3/5/2020 70 10 1013 8513 3/5/2020 27 2 300 F 25 20 Home Create External Data Database Tools Help Table Fields Table Tell me what you want to do xan Y 21 Ascending Selection The Descending Advanced Refren Do Remove Sort Yes AL X Delete Son All Ac... mex Away Day R Orderio . MemNumber - ServiceDate. ServiceID. NuminParty Location. Click to Add 1013 8513 3/5/2020 27 2 1014 8513 WS/2020 5 1099 2439 3/30/2020 68 17 1100 7439 3/10/2020 30 16 3103 7430 1/30/2020 41 38 1102 1/10/2020 5 50 12 1103 7439 3/30/2020 14 1104 7419 1/30/2020 64 3 1117 8070 3/11/2020 8000 3/11/2020 1 14 1119 8070 1/11/2020 2 54 6 1120 8070 3/11/2020 6 63 16 1121 8000 1/11/2020 73 7 1122 8070 3/11/2020 48 15 4298 3/16/2020 54 5 1190 4290 1/16/2020 7 1191 4258 3/16/2020 1 1192 4290 3/16/2020 47 10 3193 429 1/16/2020 40 30 1194 4298 3/16/2020 65 5 1591 7125 4/1/2020 5 1592 7125 4/1/2020 1503 7125 4/1/2020 5 28 12 1594 7125 4/1/2020 26 16 1595 7125 4/1/2020 44 11 1596 7125 4/1/2020 63 19 4/1/2020 1652 4/1/2020 75 1 3814 4/1/2020 48 16 3654 3814 4/1/2020 2 14 1655 4/1/2020 1 57 14 1656 3814 4/1/2020 6 66 1795 3291 4/3/2020 57 30 1796 3291 4/3/2020 40 1797 3291 4/1/2020 69 10 2 All Ac... Record motion Sam Orderio . MemumberServiceDate. ServiceID NuminParty Location. Click to Add- 1797 3291 4/1/2020 69 1798 3291 4/3/2020 1 11 1799 3291 4/3/2020 19 1800 3291 4/1/2020 19 226) 3416 4/9/2020 72 2264 3416 4/9/2020 37 2265 3410 4/9/2020 72 2 2266 3416 4/9/2020 66 6 2267 3416 4/9/2020 45 34 2268 3416 4/9/2020 16 2407 4010 4/11/2020 2 4 2408 1000 4/11/2020 2 53 2409 4030 4/11/2020 33 19 2410 4030 4/11/2020 1 38 3 2411 2010 4/11/2020 2412 4030 4/11/2020 1 57 5 2629 9800 4/14/2020 3 45 1 2650 9.00 4/14/2020 26 19 4/14/2020 60 1 2632 9600 4/14/2020 1 22 18 4/14/2020 71 2634 9600 4/14/2020 6 51 2641 4736 4/34/2020 74 2642 4736 4/14/2020 68 8 2643 4736 4/14/2020 30 2641 4736 4/14/2020 . 75 1 2645 4736 4/14/2020 1 55 10 2646 4736 4/34/2020 5 10 2773 4/15/2020 49 2714 6786 4/15/2020 45 9 6786 4/19/2020 51 12 2776 6786 4/15/2020 5 53 7 2777 4/15/2020 1 18 2778 6736 4/19/2020 1 5 2797 4/16/2020 56 36 2775 All Ac... Location motion 3562 Sort motion Service vagy Orderi MemNumber - ServiceDate Service - NuminParts Location. Click to Add 0797 3562 4/16/2020 56 16 2795 3562 4/16/2020 3 28 19 2790 3562 4/16/2020 1 45 19 2800 3562 4/16/2020 5 74 2001 4/16/2020 5 26 12 2802 3562 4/16/2020 3 38 12 2007 7 4/19/2020 3008 7188 4/19/2020 26 11 2009 718 4/19/2020 73 1010 7 4/19/2020 9 3011 7188 4/19/2020 1 52 13 3012 7188 4/19/2020 3 14 1295 5144 4/24/2020 66 11 5344 4/24/2020 59 1 3297 5344 4/24/2020 25 4/24/2020 2 3: * 5344 4/24/2020 2 75 18 3300 5144 4/24/2020 4 55 16 3421 7345 4/26/2030 2 4 17 3422 7345 4/26/2020 32 142) 7345 4/20/2020 5 3424 7345 4/26/2020 34 9 3425 7345 4/26/2020 7 1426 7345 4/26/2020 2 4: 17 3775 6083 5/1/2020 42 12 3776 5083 5/1/2020 60 9 1777 6050 5/1/2020 . 32 . 3778 6083 5/1/2020 3 53 3779 5/1/2020 66 20 5/1/2020 2 50 4 3787 9172 5/1/2020 2 32 7 3788 9172 5/1/2020 2 28 1 3789 9172 5/1/2020 1 36 17 3790 9172 5/1/2020 1 69 17 3793 9172 5/1/2020 10 Record 10228 Sew * All Ac... - + mex Orders x Service Day Orderi. MemNumber - ServiceDate. Service. NuminPart) - Location - Click to Add. 1791 972 5/1/2020 SE 10 9172 5/1/2020 75 7 3985 7219 5/4/2020 12 3986 7219 5/4/2020 4 37 1 3987 7219 5/4/2020 3 45 14 1988 7219 5/9/2020 6 20 1 3983 7210 5/4/2020 22 3990 7219 5/4/2020 3 29 10 4385 2007 5/2020 5 51 1 4286 5/8/2020 1 35 15 4787 4007 5/8/2020 1 42 13 435 4007 502020 5 45 2 4189 4007 5/8/2020 3 65 S 4007 5/8/2020 2 60 9 5/17/2020 3 54 2 4934 5/17/2020 4 17 4935 5899 5/17/2020 60 20 49.36 5/17/2020 5 58 13 4937 5899 5/17/2020 4 75 15 49 5/17/2020 5 51 13 5023 3370 5/17/2020 5 45 14 5039 5/17/2020 69 3 5033 3370 5/17/2020 3 31 19 5032 3370 5/17/2020 6 39 2 5033 3370 5/17/2020 4 30 12 5034 5/17/2020 55 15 5317 5378 5/21/2020 4 25 7 53 5178 5/21/2020 25 14 5319 SU 5/21/2020 1 73 11 5320 5378 5/21/2020 3 43 3 5178 5/21/2020 15 5322 5378 5/21/2020 13 8092 5/21/2020 39 8 512 2002 5/21/2020 3 59 12 8092 5/21/2020 25 11 Search 310 3370 Home Q View Find > S All Ac... innnn 8135 Create Baternal Data Database Tools Help Table Fields Table Tell me what you want to do Y 21 Ascending Selections The Descending Advanced Save Refresh Format Pomove Son Y AL More Son dhe Ondex Orderi. Member ServiceDate. Service. NuminParty Location. Click to Add . 5343 8092 5/21/2020 46 5344 8092 5/21/2020 63 19 5145 8092 5/21/2020 71 5.345 8092 5/21/2020 50 7 6127 5980 5/30/2020 50 6128 5980 5/30/2020 612) 5380 5/30/2020 19 6130 5980 5/30/2020 35 14 6131 5980 5/30/2020 6132 5980 5/30/2020 26 4427 6/3/2020 74 8125 6/3/2020 12 5429 8125 6/3/2020 1 6430 8125 6/2/2020 5 59 8125 6/3/2020 49 7 6432 8125 6/3/2020 55 18 7099 5908 6/12/2020 1 68 20 7100 5908 6/12/2020 6 14 7101 5908 6/12/2020 36 12 7102 5908 6/12/2020 50 17 7103 5908 6/12/2020 13 7104 5908 6/12/2020 71 15 7117 5970 6/12/2020 2 2 7118 5976 6/12/2020 74 7119 5976 6/12/2020 2 13 7120 5970 6/12/2020 70 7121 5976 6/12/2020 4 7122 5976 6/12/2020 49 7993 6005 6/22/2020 21 31 7994 6005 6/22/2020 47 11 7995 5005 6/22/2020 57 7 7996 6005 6/22/2020 65 6025 6/22/2020 44 2 7994 6005 6/22/2020 29 13 170 6511 6/30/2020 57 15 30 num Q Find View Spelling M 3 12 All Ac... R be Xan Y Fh Descending Advanced Save formatie Do Re Son Y Clipboard Sort Recorde Order A Day Orderlo. MemNumber ServiceDate. Service - NuminPart) - Location. Click to Add. 7121 5976 6/12/2020 7122 5976 6/12/2020 6005 6/22/2020 11 7994 6025 6/22/2020 47 11 7995 6095 6/22/2020 57 7 2996 6005 6/22/2020 3 65 7997 6025 6/22/2020 4 2 7998 6005 6/22/2020 13 8707 6511 6/30/2020 57 15 3701 6511 6/30/2020 1 8709 6511 6/30/2020 53 6 8710 6511 6/30/2020 5 17 8711 6511 6/30/2020 8712 6511 6/30/2020 68 8797 3214 7/1/2020 40 8796 1234 7/1/2020 8999 3234 7/1/2020 51 3800 3234 7/1/2020 40 8801 3234 7/1/2020 68 8802 3234 7/1/2020 46 6 7/2/2020 29 2 7/2/2020 2 30 18 8152 7/2/2020 5 18 3800 7/2/2020 7 8152 7/2/2020 74 11 7/2/2020 9 1941 9432 7/2/2020 33 8942 9432 7/2/2020 5 2 3943 9432 7/2/2020 41 5 7/2/2020 3 39 5 8945 9432 7/2/2020 5 3905 9432 7/2/2020 3 53 1 200320 Home Tell me what you want to do New Paresh sp X Delete- Create External Data Database Tools Help Table Field Table XH 21 Aunding Selection Coy Fher 1 Descending Advanced Formater Domove Sort Clipboard Sort Orders La Renovated Click to Add- Between Sand 10 Yeart Last Years More than 10 years expel Cor All Ac... Tables ) N View Home Create External Data Database Tools Help Table Fields Table xan 21 Ascending Selection The Descending Advanced For Sort Tell me what you want to do New Save Sing Refresh More Q? All Ac. Service 175 UU ServiceName . Per PersonCharge Click to Add Room 2 Conference Room 13 Suite 4 Banquet S Wedding 25 Event 22 Fle Home More All Ac... Tables 512 Create External Data Database Tools Help Tell me what you want to do 21 Ascending Selection Sar Fher 11 Descending Advanced format AB Remove Sort Yleihe pboard Location Member des Renovation Service Average By Day ServiceDate. Argumi Party 12/29/2015 49.8 12/31/2019 49.5 1/3/2020 1/7/2020 48.3 1/12/2020 47.5 3/5/2020 49.5 3/10/2020 520 3/11/2020 59.8 3/16/2020 4/1/2020 47.5 4/3/2020 515 4/9/2020 53.5 4/11/2020 422 4/14/2020 525 4/15/2020 53.2 4/16/2020 45 4/19/2020 49.0 4/24/2020 520 4/26/2020 40 5/1/2020 501 5/4/2020 195 5/8/2020 502 5/17/2020 518 5/21/2020 48.0 5/30/2020 40 6/3/2020 59.3 6/12/2020 6/22/2020 6/30/2020 562 7/1/2020 452 7/2/2020 438
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help