Access Project :: essays research papers

MS ACCESS PROJECT The MS Access parturiency is group oriented to totallyow individuals to exchange ideas and learn from each other. You exit build an Access database to store stock, student, and investment information with data downloaded from the net and copied from other sources. Each group member starts with $10,000 in imaginary specie which leave be invested after the closing of the market on Friday 2/18/05, and will be sold at the closing campana on Friday 3/11/05. Each group member must(prenominal) invest all the group money in 2 contrasting S&P 100 stocks. You cannot invest less than $1,000 per stock. The group that has earn the most money (or lost the least) at the end of the period will receive an extra 5 points for each group member. Group study Each group will consist of 4 to 5 members of homogeneous responsibilities that will equally share the workload. You will create your own groups in class. Each member of the group will be charge the uniform grade unles s 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 information phase a spick-and-span database noticed MIS175G000.MDB, where 000 is your assigned group number. Import all data from SP100Stocks worksheet in the SP100Stocks.xls Excel workbook into a new circuit board in your database. The new table will be named Stocks. The primary key for this table is the Symbol country of view. After the Stocks table has been created, change the size of the Symbol field to 6 textual matter characters, the Stock Name field to 40 characters, and the EPS (Earnings Per Share) field to a currency with 3 decimal places. Build a new table named Groups with the following specifications Field Name selective information Type discern Group come inTex t (4) Yes GroupName Text (50) GroupMeetingsMemo Create a new get into in the Groups table with your assigned group number, a group name of your choice and, in the GroupMeetings field, type the days and hours you have decided to meet. Build a new table named Members with the following specifications Field Name Data Type Key GroupNumberText (4) MemberIDAutoNumber Yes FirstName Text(15) LastNameText(18) EmailAddressHyperlink PictureOLE Object MajorText (5) PhoneNumberText You must define a mask for the Phone Number field.