Your query should NOT display Wedding in any field Be sure that the records

Your query should not display wedding in any field be

This preview shows page 4 - 6 out of 8 pages.

Your query should NOT display “Wedding” in any field Be sure that the records appear alphabetically by LastName Save this query with a meaningful name (e.g. NOT Query1) Revenue, cost, and profit for each member’s transactions (10 points) Create a query to only display the following information for each transaction: MemberID, TransactionID, Revenue, Cost, and Profit. You may include other fields in your query if you need them, but ONLY display these fields. Be sure to think about/include the following: Format the Revenue, Cost, and Profit fields as Currency. Sort the query by MemberID in ascending order. If you create new fields to perform calculations (e.g. Profit), name that field appropriately (i.e. do not leave it as Expr1 or Expr2). When calculating Revenue for each transaction, be sure to account for any discount received. For example, if the service normally sells for $20/person and the member received a 20% discount on that transaction, the member only paid $16/person for that service. ONLY include tables in the query if you use fields from that table. For example, if you do not use any location information in your query, do not include this table in your query. Save this query with a meaningful name (e.g. NOT Query1) Average revenue, cost, and profit for each member (10 points) Use the query you created above (Revenue, cost, and profit for each member’s transactions) to calculate the average revenue, cost, and profit generated by each member. Create a new query to display the following information: MemberID, Revenue, Cost, and Profit for EACH member for members generating average profit greater than $500. Be sure to think about/include the following: Calculate the average revenue, average cost, and average profit for each member (remember each member often has multiple transactions, so you will need to find the average revenue for all transactions for each member). Only include members in your query that have generated average profit greater than $500. You should have one record for each MemberID in your query. Format the Revenue, Cost, and Profit fields as Currency. Rename the fields for average revenue, average cost, and average profit appropriately (i.e. do not use the default name given by Access). Display records in descending order by average profit. ONLY include tables in the query if you use fields from that table. For example, if you do not use any location information in your query, do not include this table in your query. Save this query with a meaningful name (e.g. NOT Query1).
Image of page 4