Reference no: EM13748706
Creating a Database for Stock Analysis
In this scenario, you will act in the role of analyst working for a company that helps people find adequate investments. You are charged with creating a Microsoft Access Database that will utilize the database skills you developed in Hands-On Activities 8, 10, and 11 to develop a system that analyzes businesses and helps identify opportunities for prospective investments. In fact, you have already worked with the file you will be using earlier this semester. In Hands-On Activity 3 you used a text file called Stocks. You will use that file again for this assignment.
You will find references throughout this assessment to the original Homework Assignment Activity in the event you need to review the original material.
Build a Microsoft Access Database
1. Start Microsoft Access and create a new database. You should title the database LastName_FirstInitial_Final.
2. Import the data from the Stocks text file into a new table in your database (Originally covered in HOA 8, Populating the Tables with Data). Do not create the table. Allow Microsoft Access to create the table when you import the data. When importing, do not add a primary key. As a reminder, this file has 5,890 rows of data that contain information for publicly traded companies. This table must be named Stocks.
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 specialistslisted below.
![1745_stock analysis.png](https://secure.expertsmind.com/CMSImages/1745_stock%20analysis.png)
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 queryDrugAnalysis. (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 reportDividend Opportunities.
Attachment:- stocks database.xlsx
Write book review of book chocolate war by robert cormier
: Write book review of book The Chocolate War by Robert Cormier. Describes the situation with enough detail to convey the basic plot and identified values, virtues or morals.
|
Evaluate marketing mix strategies adopted by company
: Mode of entry - selection of market entry strategies to enter into various countries and evaluate the marketing mix strategies adopted by the company.
|
Kind of investment alternatives
: To keep your portfolio diversified beyond just a mix of stocks and bonds, what kind of investment alternatives could be introduced into a portfolio?
|
Determine the appropriate mix of investments
: Select stocks, bonds, mutual funds, ETFs, and so on that you feel are right for Alice. Determine the appropriate mix of investments. Give an explanation as to why you think the investments will meet the needs of the client along with your projecti..
|
Creating a database for stock analysis
: Creating a Database for Stock Analysis, In this scenario, you will act in the role of analyst working for a company that helps people find adequate investments
|
Write report of sebastiano ricci italian
: Write a report of Perseus Confronting Phineus with the Head of Medusa About 17O5- 10 and Sebastiano Ricci Italian, 1659-1734.
|
Statistical thinking in health care
: Ben Davis had just completed an intensive course in Statistical Thinking for Business Improvement, which was offered to all employees of a large health maintenance organization.
|
Horizontal organizational structure type
: Discuss the pros and cons of each horizontal organizational structure type. Incorporate the video's discussion of Functional structures.
|
Ethical cost allocations and price determination
: Did Abby compute the cost of the Breeland Ltd. special order correctly before the weekend get-together? If not, how was her cost estimate and/or price determination flawed?
|