Thursday, September 19, 2019
Access Project :: essays research papers
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 †¢Ã‚     Build a new database named 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 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. †¢Ã‚     Build a new table named Groups with the following specifications: Field Name      Data Type      Key GroupNumber     Text (4)      Yes GroupName      Text (50)      GroupMeetings     Memo      †¢Ã‚     Create a new record 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 GroupNumber     Text (4)      MemberID     AutoNumber      Yes FirstName      Text(15)     LastName     Text(18)     EmailAddress     Hyperlink     Picture     OLE Object     Major     Text (5)     PhoneNumber     Text     †¢Ã‚     You must define a mask for the Phone Number field.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.