The goal of the Technology Application Project, due week 13, is to allow you to develop an Information System to provide information for effective decision making. This project is a team assignment to allow individuals to exchange ideas and learn from each other. You will build an Information System to manage your investment club. So, your job is to build this system in MS Access, and you will use it to store stock and investment information with data downloaded from the Internet and copied from other sources and produce the appropriate information for decision making.
1. Decide which 5 stocks you will purchase as a team and submit your selections on Canvas.
You will purchase your stocks after the closing of the market on 12
th March 2021 (this
way, you all pay the same price for your stocks; no morning purchases). You could use
financial sites like http://finance.yahoo.com or http://moneycentral.msn.com to find the
closing prices and other information for your stocks.
Data Analysis and Data Modeling
2. Import all data from the list of stocks Excel workbook into a new table in your database.
The new table will be named List of Stocks. The primary key for this table is
the Ticker field. After the List of Stocks table has been created, change the size of the
Symbol field to 6 Text characters. Also, use the appropriate data types for all other fields.
Get Free Quote!
436 Experts Online