Description

MIS 204 Final Exam Activity: Creating a Database for Stock Analysis Overview As you have progressed through MIS 204, you have added several skills to your educational “tool belt” that will help you analyze data. In today’s business environment, analytical skills are in high demand because companies have large volumes of data to work with. In the past, such skills were limited to the finance and accounting departments within organizations. However, departments such as marketing, sales, production, logistics, and virtually every corner of a modern business is looking to analyze large data sets. 

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 Start Microsoft Access and create a new database.

 You should title the database LastName_FirstInitial_Final. 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. 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) 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.