The data for the tables are stored in an Access database called and the name of the database should be changed to E_ . Build the relationships for the four tables per the model shown in Figure 1 below. Part 1. Create a data input form for customers that will update the customer table so new information can easily be added to the database. Use the Form Wizard and choose the Columnar format. Your form should look similar to the one shown in Figure 2. Use the form to add the following customer to the database: CustomerID: Use your student number for the identification number of the customer Area: NO Distribution Channel: 12. Part 2. Create a form to display each muesli and related sales data on a subform. The form should look like Figure 3. Then use the form to add a new sale for the 1kg Original Muesli. In the subform add the following data for the sale: SaleID: 211 Sales Organization: Use the first two letters of your last name Customer ID: Use your student number Price: $5.47 Quantity: 9,248. (a) Create a select query called which displays each customer’s ID, area, and distribution channel. in numerical order by Customer ID (nt: You only need to use one table. Change setting in “Sort” row of query design grid). (b) Create a select query called that displays their Customer ID and area. in alphabetical order by Area. (nt: Only one table needed.) (c) Create a parameter query called which will display Customer ID, Sale ID, Material Description, Quantity, and Price. The query should ask the user to: which prompts the user to enter a Customer ID number. (nt: Use only one table and use the following code ( ) in the “Criteria” row of the query design grid: .) (d) Create a parameter query called that asks a user to provide the Muesli ID and then displays 1) the muesli description, 2) the minimum price, 3) the average price, and 4) the maximum price of a specific muesli sold. (Include both Muesli and Sale tables in the query, and follow th
e instructions for parameter query 3(c). above but alter it for the new information. (nt: use the summation symbol to display the “Total:” row in the query grid (e) Create a query called that displays data from all tables in the following order: SaleID, Sold-to-Party, Area, Channel Description, Sales Organization, Material Description, Price and Qty. Your data should be sorted so that the largest sales quantity is shown first. Display only data for Raisin Muesli with sales quantities exceeding 4,000. The output should show the largest sales quantity first. (nt: use the “criteria” row and the LIKE operator (for example: like “*Raisin*”) in the Muesli description field, and the appropriate equality/inequality operator to generate the correct data.) (f) Create a crosstab query called , which produces a table such as the one shown below in Figure 4. The format should look like the query below but your numbers will be different. (nt: use the crosstab function in the Query Wizard and Q5 above as your input to create this query. You need to copy Q5 and delete the restrictions so that all the sales data shows up for all of the cereals. Name your new query Q6. Base the crosstab query on Q6.). Your totals will be different from those below. Create a report based on the Muesli Table. The report should look like the one below in Figure 5. Create a query to base a new report on called which will display Customer ID, Sale ID, Material Description, Price, and Quantity. Use the expression builder to create a column in the query that calculates the Sale Total (multiply Price * Quantity). based on the you just createdas shown in Figures 6a and 6b below. Change the title to: Sales by Customer. Your data will be different than below, but your format should match that of the report below. Add the label: Prepared by Your Name. Use the format given Customer ID should be sorted in ascending order sum the Quantity and Sale Total of Quantity and Sale Total