MS Access help plz

[kataras]

Hello, basically this is the last year of my A levels after which i "should" be going to uni. So erm to get there i need to get the grades first and to get them i need to pass my exams. Basically guys what i wanted from you is some help regarding my final ICT exam, which is totally base on Access, which tbh i dont get that much. i have been given scenario to work with, no data or other files. So i was thinking if any of you either doing the exam as well or maybe just have some skills which you could share while making this database, that would be awesome.

What i am asked to do is, design a database which will hold information as well as, i assume, will allow bidders to "log in" (by entering correct username and password), then allow bidders to bid, then i assume, will allocate the plots to the successful bidders, and well reading scenario would clear it up a bit:

So i am assuming again that i should be having four tables:

Memebers

Bids

Plots

and Housetypes

i would be using queries and forms to access the data (login, bidding etc) tbh i havent thought of more, but if you kind people could help me out here i would really really really appreciate it

 

[Nick R]

Are you doing ICT in Uni?

 

[RollerCam540]

When you run into a bug, let me know, I'll help you with it.

 

[mrapoc]

iv just finished my database assignment at college and i went through the same "not getting it" phase as you

if u can, mess around with the setup

keep trying and keep a working backup of the database (plus i wouldnt trust cascade delete either!)

your proposed tables do look about what id do too