By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,508 Members | 2,904 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,508 IT Pros & Developers. It's quick & easy.

Creating a Database

P: 4
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
May 4 '10 #1
Share this Question
Share on Google+
1 Reply


missinglinq
Expert 2.5K+
P: 3,532
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
May 4 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.