Microsoft assignments

Marquee Challenge Challenge 1 Updating a Catering Events Table 1. Begin with 1-WBSpecialEvents-MC-1-HOA open and enable the content, if

necessary. 2. Open the CateringContracts table. 3. Dana Hirsch, manager, has given you information related to five new catering

events that were recently booked at the bistro. Dana would like you to add to the table the information shown in Figure 1.1. Dana advises that deposits have been received for all of these events. The columns in the table that have check boxes displayed are defined as Yes/No fields. In these columns, click to insert a check mark in the box indicating “Yes”; otherwise leave the check box empty to indicate “No.”

4. Jack Torrance has called and canceled his business meeting on May 13. Delete the record.

5. Dana would like the charge for the Pavelich wedding updated to $33.50 per person. 6. Dana would like a printout of the table with the records sorted in ascending order

by customers’ last names and the ID and ContactPhone fields hidden. 7. Make sure the data is entirely visible in all columns and that the printout is only one

page. 8. Close the CateringContracts table, saving layout changes.

Figure 1.1 Challenge 1

Name Phone Event Date Room Guests Charge Special Menu

Cora Spriet 905 555 1623 Wedding 8/7/2021 Westview 150 26.95 Yes

Sean Vezina 716 555 3846 Business Meeting 8/12/2021 Starlake 24 23.75 No

William Graham 716 555 8694 25th Wedding Anniversary

8/21/2021 Sunset 80 24.95 No

Helen Kosjovic 716 555 3441 Engagement Brunch

8/22/2021 Sunset 56 22.95 No

Pieter Borman 716 555 6994 Business Meeting 8/25/2021 Starlake 41 24.95 Yes

Marquee Series © Paradigm Publishing, LLC Access 365, 2019 Edition: Section 1, Challenge 1 Hands On Activity