I have a very simple database I need implemented. It needs to be developed in Access 97 preferably with no VB programming. Here are the table requirements and relationships
I have a table about Assets (contains an Asset ID number)
I have a table about Agreements ( contains AgreementID number). At any one time an asset will only belong to one agreement. An agreement can have many assets in it. An asset over a period of time may belong to different agreements. I need a nice data input form, I need to have power to be able to add additional fields to the table and form design if the requirements change after project completion. I need full documentation the say how the database has been made and how it can be edited if necessary and an explanation of how the relationships work as I am going to need to develop queries and reports at a later date.
(There are a couple of other less important tables such things called stock and disposals. For each asset there is a record of stock and a record of disposals this will be clarified later but the main problem I have is between agreements and assets)
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).
ACCESS 97 VERY IMPORTANT