Technology Application Project -Due 29/04/2021 (CLO. A1, A2, B1, C)
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.
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.
3. Build a new table named Members with the fields shown in Fig. 1 (ERD diagram) below. Is Manager field being a Yes/No field. Choose the appropriate format for the other fields.