Access Project :: essays research papers

MS ACCESS PROJECT The MS Access project is class 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 exchange 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 purpose will receive an extra 5 points for each group member. Group Composition Each group will consist of 4 to 5 members of same(p) 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 cast 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 course of action that will reflect your evaluation. This grade can be higher or lower than the group grade. Table Definitions and Table Data Build a rising database instituted MIS175G000.MDB, where 000 is your assigned group number. Import all data from SP100Stocks worksheet in the SP100Stocks.xls 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 sketch. 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. Build a new table named Groups with the following specifications Field Name Data fount Key GroupNumberText (4) Yes GroupName Text (50) GroupMeetingsMemo Create a new record in the Gr oups 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 fount 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.