need access expert to form queries and forms

3. Create a table to track industry specialists. The table should be named Specialists and contain the following information. Create the following fields in the table: First Name (Text), Last Name (Text), Street (Text), Zip Code (Text), Phone (Text), Industry Expertise (Text), Email (Hyperlink) 4. Next, you will create a form named Specialists (Originally covered in HOA 10, Step 3). The form should be in columnar layout for ease of data entry. Then use the form to enter the list of specialists listed below. 5. Create a query that includes drug companies on the New York Stock Exchange that pay dividends. In addition to the company and exchange code fields, this query should also include the ticker symbol, stock price, industry name, and dividends (Originally covered in HOA 8). Name this query Drug Analysis. (Note: You should have 11 results.) 6. Create a query that will return the companies paying dividends with a stock price over $50. This query should contain the following fields: Company Name, Ticker Symbol, Industry Name, Stock Price, and Dividends. (Hint: You will select companies in which the dividends are greater than $0 in your query.) Name this query Dividend Opportunities. 7. Next, you will create a report for the companies paying dividends using the Report Wizard based on the Dividend Opportunities query. The report should include all of the fields from the original query, be grouped by Industry Name, sorted by Company Name, and use a Stepped layout. Named the report Dividend Opportunities. After the report is initially created, modify the title of the report to ‘Companies with Dividends’. Change the Industry Name header and Industry Name field background to Text 2, Lighter 80%. The whole industry header should be a single color after changing both background properties. (Note: If this exact color is not available, then use any light blue color available to you for your background color.) In the report body, you should modify the report so that it has a solid white background. To accomplish this, you may need to change the Back Color and Alternate Back Color options in the Property Sheet. Change the Industry Name font size to 14.