Question: Lab Exercise Queries and ReportsIn this exercise, you will create reports and perform queries of the data. This assignment uses theMy _ Deli Access database.
Lab Exercise Queries and ReportsIn this exercise, you will create reports and perform queries of the data. This assignment uses theMyDeli Access database. After each step, you will paste the screen shots of your results in a Word file CREATE QUERY: In the Create tab, click on Query Wizard and choose Simple Query Wizard. Click thedrop down to change to the Orders table. Move to the right side OrderID CustomerID and MenuIDto add to the selected fields. Change to the Customers table and add Customername andCustomerEmail to the selected fields. Change to the Menu table, add MenuDescription to theselected fields. Click Next, then finish the query. Paste a screen shot of your results.On the Home tab, click the View button on the far left and choose Design View. Here you can specifydetails and criteria for your query. Under the CustomerName field, type Luke Skywalker on the Criterialine. Click the icon on the toolbar to rerun your query. Paste a screen shot of your results Modify the query you created above. Create screen shots that show the following scenarios. I want to see all orders for both Luke Skywalker and Han Solo this is technically an ORoperation Click the icon to run. I want to see all of Lukes orders as well as all sub sandwich orders another OR operation. Protip utilizing wild cards: you can place a at the end of any criteria to catch all items that startwith a certain set of letters for example sub Paste a screen shot of the query results. We are having a special on baked goods and want to reach out to all customers who purchasedbaked goods in the past. However, we want to be able to see which state they are in as we havedelivery coupons for NY residents only. In the Design View, click on the blank column at the endof your fields. Use the drop down to select the State they live in You may have to temporarilyexpand the size of the column to see the full field name. Complete the query for all people whopurchased baked goods in the past and paste your results in the Word document CREATE A REPORT: Our manager likes to keep tabs on all of our customers. This is in an effort toreach out to frequent customers and customers who have only made minimal purchases. We will createa nice report for viewing. On the Create tab, click on Report Wizard and select the Orders table. Select all fields exceptOrderID Change to the Customers table and add Customername and Customeremail to the selectedfields. Click Next We want to view our data by Customers. We do not want to add any grouping level nor dowe want any additional sorting. On the next screen, choose Stepped Layout. Change the title on the report to Orders Report and then click Finish to preview the report. You may notice that some of your fields may run off of your page. If this is the case, close thereport preview and open the report in Design View. Adjust the size and positioning of youritems in the header, detail and footer sections. You can use the page navigation buttons at thebottom to move to the second page. Notice how this is a good way of seeing all orders in a neatformat. You can perform this type of report on any set of tables or queries. Paste in a screenshot.Submit a Word file that contains all of your screen shots. Please label all of your screen shotsso I know which question you are completing.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
