Note: If the yellow Message Bar appears when you open a file, you must click on "Enable Content" button.
Task for the database in access 2003 "Investment of free funds"
Description of the subject area You are the head of the analytical center of the investment company. Your company is engaged in investing money in securities. Your customers are businesses that trust you to manage their free cash for a certain period. You need to choose the type of securities that will make a profit for you and your client. At work with the client for you rather essential is the information on the enterprise - the name, a kind of the property, the address and phone.
Securities (Security Code, Minimum Transaction Amount, Rating, Yield for Last Year, Additional Information).
Investments (Investment code, Security code, Customer code, Quotation, Date of purchase, Sale date).
Clients (Customer code, Name, Property type, Address, Telephone).
The development of the formulation of the problem
When using the database it became clear that it is necessary to keep the history of quotations of each security. In addition, in addition to investing in securities, it is possible to invest money in bank deposits. Add changes to the table structure that take into account these facts, and modify existing queries. Add new queries.
In order to counter copyright infringement and property rights, we ask you to immediately inform us at email@example.com the fact of such violations and to provide us with reliable information confirming your copyrights or rights of ownership. Email must contain your contact information (name, phone number, etc.)