SWI 511

Create a presentation (six to ten slides) and other source materials that summarizes a special event, entertainment, or party of your choice. (eg. conference, symposium, new product launch, retirement party). Make up all the information required for this project, but be sure that the data is relevant to the special event you are planning. Be creative and professional with the details in this project. Be sure to apply all the necessary skills you have obtained throughout this course and your previous courses.

In preparation for the event, you start to plan and assemble documents that will be used in the presentation. 1. To start, you decide to sketch out your slide details by creating a Word outline. Below is a list of the titles for your slides. Add more details for each slide as it relates to your event. Save this file as My Event Word Outline.docx Title/Opening slide Purpose of the party or event Event Details Tentative Attendees Motivational closing slide 2. For the event details (agenda, location, time, etc.) you find that keeping the information organized in a Word table would be easy to follow and update. Save the document as My Event Details.docx 3. In order to track attendees to the event, you create a database to track the number of attendees to your event. Below are some items you decide to include. Save this database as My Event Database.accdb a. List of 25 people b. Contact information for attendees (name, company, address, email, cell) c. Business Category field (Lookup: Sole Proprietorship, Partnership, Corporation) d. Yes/No fields (check off some records with yes and some records with no): i. Attend ii. Paid Summer 2022 2 | P a g e e. Date payment received field f. You have been asked to show all the people who have paid for the event so far and create a simple query, Tentative Attendees, that shows this information. 4. The manager of the event, has also asked you to summarize the number of people who have paid for the event by business category and then create a chart that summarizes this information. You decide to copy the query, Tentative Attendees and use the Paste Link option in Excel to paste the query as a link in a blank worksheet in Excel. In the same worksheet, you then proceed to create a pivot table and pivot chart based on this data. Save this file as My Tentative Attendees.xlsx

With all of the source materials prepared, you are now ready to produce and finalize your PowerPoint presentation. 1. The text for each slide is already completed in the Word outline you created, so you first import your Word outline into PowerPoint. Save the presentation as My Event Presentation.pptx 2. Next, you decide to paste your Event Details table into the presentation as a Linked object so that if there are any changes in the agenda, it will automatically update the information in the presentation. 3. Add the pivot chart pasted as link into the presentation to ensure that if the database has any updates it is reflected across into the presentation. 4. Return to your Access database and update one of the records in your table with your name. In addition, update five (5) records in your table in your database and give them all the same business category of Corporation and ensure that there is a checkmark in the paid field. 5. Use the Update/Refresh All options for all items in your My Tentative Attendees.xlsx file so that the worksheet data, pivot table, pivot chart, are updated in the Excel file, all the way through to the linked chart in the PowerPoint slide. Note: You may have to click on the Edit Links option and select Update Values and/or adjust the Trust Center Settings by going File, Options, External Content, and clicking on the Enable Dynamic Data Exchange Server Launch option. Be sure to check this setting off after you have completed the assignment. 6. Format the presentation attractively. Add more slides if required. Use graphics, transitions, fonts, backgrounds, etc. that will enhance your presentatio