show all the steps.

Please create three queries, and three reports on four items in the template, do this three times. example of one All issues by specific color or brand or type-your choice then the veneer or strings problems then the remarks. Submit the Access three files X SumOflnventoryCostByVendor X All Access Objects Tables B Product Vendor 3 Vendor Productinventory Queries InventoryCost SumfinventoryCostByCategory SumOfInventoryCostByVendor SumOflnventoryCostByVendor&Category BRE BES Product X Vendor X Vendor Productinventory X InventoryCost X SumOflnventoryCostBy Category ProductID ProductName IndustryStandardCost - Category Click to Add , Economy Mattress & Box Set $279.50 Furniture 3 Standard Mattress & Box Set $769.25 Furniture + 4 Luxury Mattress Set & Box Set $2,012.00 Furniture 5 Smart Foam & Box Set $3,265.00 Furniture 6 Classic Headboard/Frame $126.50 Furniture 7 Decorative Headboard/Frame $189.75 Furniture + 8 Contemporary Headboard/Frai $189.75 Furniture 9 Rustic Headboard/Frame $158.13 Furniture 10 Artist Designed Headboard/Fri $253.00 Furniture 11 Classic Dresser $126.50 Furniture 12 Decorative Dresser $189.75 Furniture 13 Contemporary Dresser $189.75 Furniture 14 Rustic Dresser $158.13 Furniture 15 Artist Designed Dresser $253.00 Furniture 16 Classic Armoire $253.00 Furniture 17 Decorative Armoire $379.50 Furniture 18 Contemporary Armoire $379.50 Furniture 19 Rustic Armoire $316.25 Furniture 20 Artist Designed Armoire $506.00 Furniture 21 19" Tube Television $158.13 Accessories 22 27" Tube Television $265.65 Accessories 23 26" Flat Panel Television $790.63 Accessories 24 37" Flat Panel Television $595.00 Accessories 25 50" Flat Panel Television $1,428.80 Accessories + All Access Objects 20 FEE Product X Vendor X Vendor ProductInventory VendorID VendorName - FurnitureMargin Illumination, Inc 20 2 Team Supplies 25 3 Webster Distributie 30 4 Grant Sales 40 5 Copper River Manu 50 (New) Tables Product Vendor Vendor ProductInventory Queries InventoryCost SumfinventoryCostBy Category Sum OfInventoryCostByVendor SumOfInventoryCostByVendor&Category EEE X InventoryCost X SumOflnventoryCostBy Category X X SumOfInventoryCostByVendor X Accessory Margin Clothing Margin Linen Margin Shipping Mai - Click to Add 20 20 25 25 25 25 25 30 30 30 25 40 40 40 25 50 50 50 25 BO All Access Objects 0 InventoryCost X SumOflnventoryCostBy Category x SumOflnventoryCostByVendor X Click to Add , 47 102 32 52 Tables E Product E Vendor 3 Vendor ProductInventory Queries InventoryCost SumOfInventoryCostBy Category SumOfInventoryCostByVendor SumOflnventoryCostByVendor&Category Product XII Vendor X BE Vendor Productinventory X Vendorld ProductID QuantityOnHand 11 2 1 3 1 6 1 11 1 16 25 1 21 0 1 22 13 27 1 1 BO 1 31 35 40 19 9 19 19 19 1 1 43 1 45 7 1 47 11 1 47 50 52 1 88 1 54 36 21 1 56 2 2 21 3 7 4 2 2 2 2 2 6 10 36 24 14 7 8 X All Access Objects Tables Product Vendor Vendor ProductInventory Queries Inventory Cost SumOfInventoryCostBy Category SumOfInventoryCostByVendor SumOfInventoryCostBy Vendor&Category B Product X Vendor X. Vendor ProductInventory X InventoryCost ProductName IndustryStandardCost- Category Economy Mattress & Box Set $279.50 Furniture Standard Mattress & Box Set $769.25 Furniture Classic Headboard/Frame $126.50 Furniture Classic Dresser $126.50 Furniture Classic Armoire $253.00 Furniture 19" Tube Television $158.13 Accessories 27" Tube Television $265.65 Accessories Alarm Clocks $18.98 Accessories Basic Home Theater System $531.30 Accessories Classic Lamps $63.25 Accessories Basic Chandelier $227.70 Accessories Basic Iron $18.98 Accessories Basic Hair Blow Dryer $18.98 Accessories Framed Print Pictures $253.00 Accessories Standard Bed sheets $101.20 Linens Standard Towels $94.88 Linens Standard Curtains $126.50 Linens Standard Uniforms $75.90 Clothing Economy Mattress & Box Set $279.50 Furniture Standard Mattress & Box Set $769.25 Furniture Luxury Mattress Set & Box Set $2,012.00 Furniture Classic Headboard/Frame $126.50 Furniture Decorative Headboard/Frame $189.75 Furniture SumOflnventoryCostBy Category X SumOfInventoryCostByVendor QuantityOnHand VendorName - Productinve 47 illumination, Inc $13,136.50 102 illumination, Inc $78,463.50 32 illumination, Inc $4,048.00 52 illumination, Inc $6,578.00 25 illumination, Inc $6,325.00 o illumination, Inc $0.00 13 illumination, Inc $3,453.45 19 Illumination, Inc $360.53 9 Illumination, Inc $4,781.70 19 illumination, Inc $1,201.75 19 Illumination, Inc $4,326.30 19 illumination, Inc $360.53 7 illumination, Inc $132.83 11 illumination, Inc $2,783.00 47 illumination, Inc $4,756.40 88 illumination, Inc $8,349.00 36 Illumination, Inc $4,554.00 21 Illumination, Inc $1,593.90 21 Team Supplies $5,869.50 7 Team Supplies $5,384.75 10 Team Supplies $20,120.00 36 Team Supplies $4,554.00 24 Team Supplies $4,554.00 All Access Objects Tables Product Em Product XT1 Vendor X Vendor ProductInventory X InventoryCost X SumOfInventoryCostByCategory X SumOflnventoryCostByVendor X SumOfInventoryCost Category $370,704.63 Accessories $24,819.30 Clothing $454,416.25 Furniture $95,144.88 Linens Vendor 3 Vendor Productinventory Queries InventoryCost SumOfInventoryCostByCategory SumOfInventoryCostByVendor SumOflnventoryCostByVendor&Category All Access Objects Tables EE Product Product X Vendor X VendorProductInventory x InventoryCost x SumOflnventoryCostBy Category x SumOflnventoryCostByVendor X VendorName SumOfInventory Cost Copper River Manufacturing $331,696.36 Grant Sales $206,036.91 illumination, Inc $145,204.38 Team Supplies $103,238.90 Webster Distribution $158,908.50 FEE Vendor B Vendor ProductInventory Queries A InventoryCost SumOfInventoryCostBy Category Sum OflnventoryCostByVendor SumOfInventoryCostByVendor&Category All Access Objects X SumOfInventoryCostByVendor&Category X Tables Product Vendor 3 Vendor ProductInventory Queries InventoryCost SumOfInventoryCostByCategory SumOflnventoryCostByVendor SumOfInventoryCostByVendor&Category Vendor Productinventory X InventoryCost X SumfinventoryCostBy Category X SumOflnventoryCostByVendor Sumofinventory Cost VendorName Category $190,287.98 Copper River Manufacturing Accessories $8,045.40 Copper River Manufacturing Clothing $109,584.38 Copper River Manufacturing Furniture $23,778.61 Copper River Manufacturing Linens $75,984.48 Grant Sales Accessories $3,453.45 Grant Sales Clothing $110,142.88 Grant Sales Furniture $16,456.11 Grant Sales Linens $17,400.08 illumination, Inc Accessories $1,593.90 illumination, Inc Clothing $108,551.00 illumination, Inc Furniture $17,659.40 Illumination, Inc Linens $10,891.65 Team Supplies Accessories $5,237.10 Team Supplies Clothing $63,821.50 Team Supplies Furniture $23,288.65 Team Supplies Linens $76,140.45 Webster Distribution Accessories $6,489.45 Webster Distribution Clothing $62,316.50 Webster Distribution Furniture $13,962.10 Webster Distribution Linens Please create three queries, and three reports on four items in the template, do this three times. example of one All issues by specific color or brand or type-your choice then the veneer or strings problems then the remarks. Submit the Access three files X SumOflnventoryCostByVendor X All Access Objects Tables B Product Vendor 3 Vendor Productinventory Queries InventoryCost SumfinventoryCostByCategory SumOfInventoryCostByVendor SumOflnventoryCostByVendor&Category BRE BES Product X Vendor X Vendor Productinventory X InventoryCost X SumOflnventoryCostBy Category ProductID ProductName IndustryStandardCost - Category Click to Add , Economy Mattress & Box Set $279.50 Furniture 3 Standard Mattress & Box Set $769.25 Furniture + 4 Luxury Mattress Set & Box Set $2,012.00 Furniture 5 Smart Foam & Box Set $3,265.00 Furniture 6 Classic Headboard/Frame $126.50 Furniture 7 Decorative Headboard/Frame $189.75 Furniture + 8 Contemporary Headboard/Frai $189.75 Furniture 9 Rustic Headboard/Frame $158.13 Furniture 10 Artist Designed Headboard/Fri $253.00 Furniture 11 Classic Dresser $126.50 Furniture 12 Decorative Dresser $189.75 Furniture 13 Contemporary Dresser $189.75 Furniture 14 Rustic Dresser $158.13 Furniture 15 Artist Designed Dresser $253.00 Furniture 16 Classic Armoire $253.00 Furniture 17 Decorative Armoire $379.50 Furniture 18 Contemporary Armoire $379.50 Furniture 19 Rustic Armoire $316.25 Furniture 20 Artist Designed Armoire $506.00 Furniture 21 19" Tube Television $158.13 Accessories 22 27" Tube Television $265.65 Accessories 23 26" Flat Panel Television $790.63 Accessories 24 37" Flat Panel Television $595.00 Accessories 25 50" Flat Panel Television $1,428.80 Accessories + All Access Objects 20 FEE Product X Vendor X Vendor ProductInventory VendorID VendorName - FurnitureMargin Illumination, Inc 20 2 Team Supplies 25 3 Webster Distributie 30 4 Grant Sales 40 5 Copper River Manu 50 (New) Tables Product Vendor Vendor ProductInventory Queries InventoryCost SumfinventoryCostBy Category Sum OfInventoryCostByVendor SumOfInventoryCostByVendor&Category EEE X InventoryCost X SumOflnventoryCostBy Category X X SumOfInventoryCostByVendor X Accessory Margin Clothing Margin Linen Margin Shipping Mai - Click to Add 20 20 25 25 25 25 25 30 30 30 25 40 40 40 25 50 50 50 25 BO All Access Objects 0 InventoryCost X SumOflnventoryCostBy Category x SumOflnventoryCostByVendor X Click to Add , 47 102 32 52 Tables E Product E Vendor 3 Vendor ProductInventory Queries InventoryCost SumOfInventoryCostBy Category SumOfInventoryCostByVendor SumOflnventoryCostByVendor&Category Product XII Vendor X BE Vendor Productinventory X Vendorld ProductID QuantityOnHand 11 2 1 3 1 6 1 11 1 16 25 1 21 0 1 22 13 27 1 1 BO 1 31 35 40 19 9 19 19 19 1 1 43 1 45 7 1 47 11 1 47 50 52 1 88 1 54 36 21 1 56 2 2 21 3 7 4 2 2 2 2 2 6 10 36 24 14 7 8 X All Access Objects Tables Product Vendor Vendor ProductInventory Queries Inventory Cost SumOfInventoryCostBy Category SumOfInventoryCostByVendor SumOfInventoryCostBy Vendor&Category B Product X Vendor X. Vendor ProductInventory X InventoryCost ProductName IndustryStandardCost- Category Economy Mattress & Box Set $279.50 Furniture Standard Mattress & Box Set $769.25 Furniture Classic Headboard/Frame $126.50 Furniture Classic Dresser $126.50 Furniture Classic Armoire $253.00 Furniture 19" Tube Television $158.13 Accessories 27" Tube Television $265.65 Accessories Alarm Clocks $18.98 Accessories Basic Home Theater System $531.30 Accessories Classic Lamps $63.25 Accessories Basic Chandelier $227.70 Accessories Basic Iron $18.98 Accessories Basic Hair Blow Dryer $18.98 Accessories Framed Print Pictures $253.00 Accessories Standard Bed sheets $101.20 Linens Standard Towels $94.88 Linens Standard Curtains $126.50 Linens Standard Uniforms $75.90 Clothing Economy Mattress & Box Set $279.50 Furniture Standard Mattress & Box Set $769.25 Furniture Luxury Mattress Set & Box Set $2,012.00 Furniture Classic Headboard/Frame $126.50 Furniture Decorative Headboard/Frame $189.75 Furniture SumOflnventoryCostBy Category X SumOfInventoryCostByVendor QuantityOnHand VendorName - Productinve 47 illumination, Inc $13,136.50 102 illumination, Inc $78,463.50 32 illumination, Inc $4,048.00 52 illumination, Inc $6,578.00 25 illumination, Inc $6,325.00 o illumination, Inc $0.00 13 illumination, Inc $3,453.45 19 Illumination, Inc $360.53 9 Illumination, Inc $4,781.70 19 illumination, Inc $1,201.75 19 Illumination, Inc $4,326.30 19 illumination, Inc $360.53 7 illumination, Inc $132.83 11 illumination, Inc $2,783.00 47 illumination, Inc $4,756.40 88 illumination, Inc $8,349.00 36 Illumination, Inc $4,554.00 21 Illumination, Inc $1,593.90 21 Team Supplies $5,869.50 7 Team Supplies $5,384.75 10 Team Supplies $20,120.00 36 Team Supplies $4,554.00 24 Team Supplies $4,554.00 All Access Objects Tables Product Em Product XT1 Vendor X Vendor ProductInventory X InventoryCost X SumOfInventoryCostByCategory X SumOflnventoryCostByVendor X SumOfInventoryCost Category $370,704.63 Accessories $24,819.30 Clothing $454,416.25 Furniture $95,144.88 Linens Vendor 3 Vendor Productinventory Queries InventoryCost SumOfInventoryCostByCategory SumOfInventoryCostByVendor SumOflnventoryCostByVendor&Category All Access Objects Tables EE Product Product X Vendor X VendorProductInventory x InventoryCost x SumOflnventoryCostBy Category x SumOflnventoryCostByVendor X VendorName SumOfInventory Cost Copper River Manufacturing $331,696.36 Grant Sales $206,036.91 illumination, Inc $145,204.38 Team Supplies $103,238.90 Webster Distribution $158,908.50 FEE Vendor B Vendor ProductInventory Queries A InventoryCost SumOfInventoryCostBy Category Sum OflnventoryCostByVendor SumOfInventoryCostByVendor&Category All Access Objects X SumOfInventoryCostByVendor&Category X Tables Product Vendor 3 Vendor ProductInventory Queries InventoryCost SumOfInventoryCostByCategory SumOflnventoryCostByVendor SumOfInventoryCostByVendor&Category Vendor Productinventory X InventoryCost X SumfinventoryCostBy Category X SumOflnventoryCostByVendor Sumofinventory Cost VendorName Category $190,287.98 Copper River Manufacturing Accessories $8,045.40 Copper River Manufacturing Clothing $109,584.38 Copper River Manufacturing Furniture $23,778.61 Copper River Manufacturing Linens $75,984.48 Grant Sales Accessories $3,453.45 Grant Sales Clothing $110,142.88 Grant Sales Furniture $16,456.11 Grant Sales Linens $17,400.08 illumination, Inc Accessories $1,593.90 illumination, Inc Clothing $108,551.00 illumination, Inc Furniture $17,659.40 Illumination, Inc Linens $10,891.65 Team Supplies Accessories $5,237.10 Team Supplies Clothing $63,821.50 Team Supplies Furniture $23,288.65 Team Supplies Linens $76,140.45 Webster Distribution Accessories $6,489.45 Webster Distribution Clothing $62,316.50 Webster Distribution Furniture $13,962.10 Webster Distribution Linens