Creating a Database

[Cachita]

Hello!

I need some help in creating a DB. I have an Excel spreadsheet that contains multiple columns of information. This s/s is the log for contract vendors. These contracts gets renew every year depending on the end date. This is it what I would like to see Access do for me:

1. Be able to update the existing data with the new renewal date without eliminating last year information.
2. have the system generate a warning for contracts that are coming up for renewal.

These are the fields that this s/s has:

1. vendor name (this vendor might have multiple products)
2. vendor # (this field is unique, but can have multiple entries because of the # of products)
3. Annual cost
4. Product description
5. Purchase Order #
6. Product owner (the person that manages the product internally)
7. Business Planning
8. Start date
9. End date
and others fields.

Let me know the best way to get this going. Thx

[missinglinq]

Once again, as in your post http://bytes.com/topic/access/answer...bform-creation you're presenting what appears to be a school project, and not asking for help with a particular problem, which is what we do here, but rather asking for us to lead you thru the entire database development process!

To put it simply, as was explained before in the thread cited above, you must show us that you've made some effort toward developing this database before anyone here is going to offer you assistance! I would also suggest, as I did in that thread, that you carefully read the posting guidelines at http://bytes.com/topic/access/answer...-posting-forum

Linq ;0)>

Moderator