Microsoft assignments

Marquee Challenge Challenge 1 Creating Queries and a Report for a Catering Events Database 1. Dana Hirsch, manager, has provided you with a copy of the database file used to

track catering events at the bistro. Dana has been filtering records in the datasheet to obtain the lists needed for managing the events but is finding this process too time consuming. Dana has asked you to figure out how to create queries that can provide the information more efficiently. Begin with 3-WBSpecialEvents-MC-1-HOA open and enable the content, if necessary.

2. Create the following queries: a. A WestviewEvents query that displays all events booked in the Westview room.

In the query results datasheet, Dana would like the first and last names, the event type, the date the event is booked, the room booked for the event, the number of guests, and the special menu details.

b. A JuneEvents query that displays all of the events booked in June 2021. In the query results datasheet, show the first and last names, the event type, the date the event is booked, and the room in which the event will be held. (You will need to set the criteria to display events booked between June 1, 2018, and June 30, 2021.)

c. An EventRevenue query that displays all records. In the query results datasheet, show the last name, the event type, the date the event is booked, the number of guests, and per person charge. Calculate in the query the estimated revenue by multiplying the guests by the per person charge. You determine an appropriate column label and format for the calculated column. In the query results datasheet, add a total at the bottom of the calculated column.

3. Create a report based on the EventRevenue query as shown in Figure 3.1 on the next page. The company logo is stored in the file named TWBLogo-Small (located in the Paradigm Documents subfolder within the Documents folder). Use your best judgment to determine the report formatting elements. The theme used is the default Office theme with individual formatting applied to headings. Apply the Dark Blue background color to the column headings and then apply bold formatting and White font color to the column heading text. Totals can be inserted at the bottom of columns by right-clicking the column heading for which a total is desired and then using options at the shortcut menu. Apply the same formatting to the total in the Total Revenue column that you applied to the column headings. Save the report using the default name.

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

Figure 3.1 Challenge 1

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