use microsoft access

s. Jume 202 t Save the Database file by your name and studeat numosr owart chat netes of Suhad and Fereshte via teams Part one: Tables Prepare the table below with title "Products" into the data base correctly (access data base). a- The "Brand" is the primary key, and it should be ia the form: AB-1234. b- Input the appropriate mask for The ficld "supplier" Part 2: Queries According to the table with title "Products", prepare the following queries: 1. Design a query to know how many products have memory capacity less than or equals to 32 with the brand that their prices are less than 300 ), save it with title" memory capacity and price" 2. How many products that have ram (GB) of 1 and 2 , save it with title" Products with ram 1 and 2" 3. Find the average price of brand Huawei, save it with title "The average price of Huawei brand" 4. By designing a query, compute gross profit for apple products only using the formula: gross profit=sell price-cost per unit, save it with title "Gross profit of Apple product" Part 3: FORMS According to the table with title "Products", create form using form design as follows: 1. Add all the fields that exist in the table 2. Add header and footer 3. Write the title "Products" in the header 4. Add the date and time in the header 5. Insert suitable image to set it as background for the form 6. Use the option "Button" from design tools to create "add new record" and another button to create "first record" 7. Use combo box to create drop down list (list of options) for the brand column