Be Home Create External Data Database Tools Help Query Design Assignment 2- John Morris: Database- C:\Users\18325\Desktop\Assignment 2-John Morris.accdb (Access 2007-2015 file format) - Access Tell me what you want to do Union ew Run Select Make Append Update Crosstab Delete Table Pass-Through Insert Rows Ex Delete Rows LJ Data Definition Add Tables Builder Insert Columns Delete Columns Return: All [?] Property Sheet Table Names Totals Parameters Results Access Objects < Query Type Feedback X Query Setup Show/Hide Customer Feedback X Review Customer Life Time Sales X View orders by year, month, state X ch Customer Product bles Customer Employee W Customer ID Customer Name Feedback Orders Product Product Description Size State ueries Customer Feedback Review Customer Life Time Sal... View orders by year, month, st... Customer Phone Customer Address State Abbr Zip Code Customer Email 81 Orders Order ID Customer ID Product ID Quantity Employee ID Order Date Order Status Field: Customer ID Customer Name Table: Customer Total: Group By Customer Group By Sort: Show: Criteria: or Ready Type here to search TO -L 81 * Product ID Item Sizes Color Price Enter Parameter Value ORDER!Quantity ? X OK Cancel Lifetime Sales: Sum([ORDER]![Quantity]*[Product] [Price]) Expression Descending 13 John R Morris JR X X Add Tables Tables Links Queries All ING Search Customer Employee Feedback Orders Product Product Description Size State Add Selected Tables Num Lock SQL 0 W 79F Mostly cloudy O 10:36 PM 9/5/2022 E