Please help with step by step

Question 2. Use the Baseball database you created in the first week for this assignment (copy the file). Now by analyzing the baseball inventory data, we know one table design is not a good design because we put item information and supplier information into one table. A better design is to have two tables. Please: (2a). Create a new table for Suppliers, set the primary key, input data (Note: the supplier data are from Week 1 Assignment). (2b). Change the structure of the original baseball inventory table (Note: we don't need supplier information, so remove SupplierName, and SupplierTelephone, but keep SupplierCode as the foreign key) Then create Access GUI queries (not SQL style, please save each query) (2c). Display item id, description, selling price, supplier name for all items. (2d). Display the item id, description, cost, and units on hand of all items supplied by Beverage Holders (We only know this supplier name as the criteria) (2e) Display the average selling price of supplier Beverage Holders' items (We only know this supplier name as the criteria) (2f) For each supplier name, find a count of different types of items of the supplier name. & Baseball X ID Description Cost 1 Baseball Cap $10.15 2 Al Clothes $7.45 3 Beverage Holders $1.85 4 Logo Goods $8.20 5 Jacket $44.75 6 Short $14.95 7 Sport Towel $3.25 8 Sweatshirt $27.45 9 Tee Shirt $9.50 10 Coffee Travel Mug $2.90 (New) $0.00 Units - Selling Price - Code - 30 $18.76 LG 12 $9.00 BH 20 $4.75 BH 8 $10.75 BH 12 $54.95 LG 10 $19.95 AC 24 $6.75 LG 9 $34.95 AC 32 $14.95 AC 11 $3.25 BH 0 $0.00 SupplierName SupplierPhone - Click to Add Logo Goods 517-555-3853 Beverage Holders 317-555-4747 Beverage Holders 317-555-4747 Beverage Holders 317-555-4747 Logo Goods 517-555-3858 Al Clothes 616-555-9228 Logo Goods 517-555-3853 Al Clothes 616-555-9228 Al Clothes 616-555-9228 Beverage Holders 317-555-4747 *