View Full Version : Making an Acess database for bidding houses URGENT


Chelseafc65
05-04-2008, 07:27 AM
I need help for tomorrow so i really hope if someone can help me. Basically, i need to create a database to allocate housing plots to successful bidders. I will be provided with the data but i am stuck on the process.

I think i need to normalize the data, create relationships for the tables. I don't know what tables i need, but i think i need one for the bidders info, housing info, and then now i am lost.

I would also need to create forms for bidders to bid in. That would need me to show the highest bid but i have no idea how to do that.

I also need to make a sign in system where bidders get a user id and pw which takes them to a bidding screen, how do i do this?

Please Help!

doco
05-04-2008, 07:58 AM
Hmmm... A complete system ready to go by tommorrow morning? Interesting.

Rabbie
05-04-2008, 08:16 AM
Hmmm... A complete system ready to go by tommorrow morning? Interesting.
Could it be a class assignment?

Chelseafc65
05-04-2008, 09:05 AM
I need to know how to do it, not complete it tomorrow, so guidance is much appreciated.

georgedwilkinson
05-04-2008, 09:50 AM
You're asking for a lot in a short time. If you already had the skill set (and thus didn't have to ask) I would say that you could have a prototype by tomorrow. Since that is not the case, I'm pretty sure you cannot.

Anyway, here's how to proceed:
Write down all the nouns and events. Those are potential tables. Consider the relationships between those tables/nouns/events...how many of the rows in one table are related to how many of the rows in another table. If the answer is ever many to many, you need another table to act as an associative table. Create the relationships with drag and drop, create the forms with wizard, create the reports with wizards. Viola, a prototype!

Good luck!