Group Member O Member Information example essay topic

MS ACCESS PROJECT The MS Access project is group oriented to allow individuals to exchange ideas and learn from each other. You will build an Access database to store stock, student, and investment information with data downloaded from the Internet and copied from other sources. Each group member starts with $10,000 in imaginary money which will be invested after the closing of the market on Friday 2/18/05, and will be sold at the closing bell on Friday 3/11/05. Each group member must invest all the group money in 2 different S&P 100 stocks. You cannot invest less than $1,000 per stock. The group that has earned the most money (or lost the least) at the end of the period will receive an extra 5 points for each group member.

Group Composition Each group will consist of 4 to 5 members of same responsibilities that will equally share the workload. You will create your own groups in class. Each member of the group will be assigned the same grade unless otherwise shown in peer-evaluation. When it comes to peer-evaluation, the total group points will be divided among the members in your group, in which case you will be assigned a grade that will reflect your evaluation. This grade can be higher or lower than the group grade. Table Definitions and Table Data o Build a new database named MIS 175 G 000.

MDB, where 000 is your assigned group number. o Import all data from SP 100 Stocks worksheet in the SP 100 Stocks. xl's Excel workbook into a new table in your database. The new table will be named Stocks. The primary key for this table is the Symbol field. After the Stocks table has been created, change the size of the Symbol field to 6 Text characters, the Stock Name field to 40 characters, and the EPS (Earnings Per Share) field to a currency with 3 decimal places. o Build a new table named Groups with the following specifications: Field Name Data Type Key Group Number Text (4) Yes Group Name Text (50) Group Meetings Memo o Create a new record in the Groups table with your assigned group number, a group name of your choice and, in the Group Meetings field, type the days and hours you have decided to meet. o Build a new table named Members with the following specifications: Field Name Data Type Key Group Number Text (4) MemberID Auto Number Yes First Name Text (15) Last Name Text (18) Email Address Hyperlink Picture OLE Object Major Text (5) Phone Number Text o You must define a mask for the Phone Number field. In other words, Phone Number field should have the appropriate input mask. The Major field only accepts the following values: MIS, AIS, ACCT, FIN, GMT, MKTG, OTHER.

Group Number displays the values from the Group Number field of the Groups table (lookup). It should be mandatory to type data to all the files of the Members table (no blank fields). o Build a new table named Trades with the following specifications: Field Name Data Type Key Trade Number Auto Number Yes MemberID Number Symbol Text (6) Trade Date Date / Time Amount Invested Currency o Trade Date field described above is formatted as short date. Default value is 2/18/05. o Build a new table named Prices with the following specifications: Field Name Data Type Key Symbol Text (6) Yes Date Date / Time Yes Price Currency o Date field described above are formatted as short date. o Each Friday, starting on 2/18/05 until 3/11/05, you must record the closing price for each of your stocks. Enter your closing prices in the Prices table only for the stocks purchased by the group.

Note: You can monitor and record each closing price every week, or download the historical data once on the last week (will show you how to find past closing prices in class). You must also record the purchase prices in this table. Note that the prices of stocks for 2/18/05 should be recorded before the form in Fig 3 can be completed. o Create the Relationships (ER Diagram) for the five tables created up to this point, as shown below (Fig. 1). Fig. 1 Form Definitions o Create one BMP file with the picture of each team member.

Each picture should be less than 100 KB in size. You may use any method to create the graphic files with your pictures (i. e., scanning a paper picture, digital camera, photo collage). You will use this picture in the Picture field of the Members table (see Fig. 2). o Build a form to populate the Members table. Form should be named frmMembers and should look like Fig. 2.

Fig. 2 o Add all the group member information using frmMembers. o Build a form / sub form to display group member information and add your trades data to the Trades table (Fig. 3). o Form should have combo box where the user will select from the available group members and display the group member information and trades (if any) for that group member. o Member information cannot be changed (only displayed). o Subform should display the Date and Price information from the Prices table for each stock typed (Symbol) for each Trade Date. For example, if the member trades the INTC stock on 2/18/2005, the price of that stock for that date should be found in the Prices table and the Price should be displayed in the Price column. o Sub-form should have a column labeled Shares that will show the number of shares purchased (Amount Invested divided by Price). o In Sub-form, the Member ID, Trade Number, Date, and Price fields cannot be edited. o Shares column should show the number of purchased shares with 2 decimal points. o Note the form's title (Stock Trade Form / Subform). Your form should have the same title. Fig. 3 Report Definitions o Build the Gain / Loss Report shown in Fig. 4. o Report name is rptGainLoss. o This detailed report is grouped by MemberID.

The detail part of the report shows the holdings for each member (Symbol column), the Company Name (for each Symbol), the Amount Invested (column should show "$ Invested"), Buy Date, Buy Price, Sell Date (3/11/05), Sell Price, Shares Purchased, and Gain / Loss column (Sell Price minus Buy Price times Shares). o Gain / Loss Report title should appear at the top of each page (one page per Member ID). o Gain / Loss column is formatted as currency. o Report should show the total amount invested and Gain / Loss for each member. o Report should show a grand total at the end of the report (total Gain / Loss for all members). Fig. 4 o You must build appropriate queries that will help you to produce the report above. Note: Do not have any tables, queries, or reports in the database that are not required by this assignment. Assignment Submitting Standards: 1. All assignments are due at the beginning of the class period. 2.

Late assignments will NOT be accepted. 3. All assignments should be submitted in a 9 x 12 manila envelope with the cover letter statement (a form will be given) stapled, glued, or taped to the outside of the envelope. 4. A CD with the group number of the label. This CD should include the Access database and your graphic files (pictures) 5.

One typed statement from each group member describing each member's contribution to the homework.