I am using Microsoft Access to solve the following queries. Please help me with step by step for Access Application: Please ensure that all your fields are formatted as needed and that columns are renamed as appropriate.

Products No Sales: Please create a query that shows a list of all the products that are not discontinued that have not been sold. Design a query that displays the product ID$,$ Product Name and Supplier ID for the products that have not been sold and are not discontinued.

Total Freight Charges: Please design a query that shows sales with a total freight charge of over $$100.$ In your query please display Sales Invoice Number, the Shipper ID and Shipper Name, Customer name $($as a single field$),$ Total freight charges, and the postal code and country the items were shipped to$.$

Coffee and Chocolate Products: A customer has called and wants to know what Chocolate and Coffee products the company sells. Design a query showing all products that include $$Chocolate$$ or $$Coffee$$ in the title. In your query please provide the Product name, Supplier name, Unit Price.

Efficiency: Please design a query that displays the employee name combined into one field showing the name as Last name, First name followed by sales id$,$ gross sale total $($no discounts included$),$ shipped date, and required date BUT ONLY for each $2020$ or $2021$ sale that was shipped AFTER its required date.

Orders by Employee Title: Please design a query to show the dollar figure of orders taken by each employee title group and the number of total orders taken for the year ended June $30,2021.$ Please ensure that your query allows the user to input the employee title at the time of the query.