Table Relationship Form

[gottaluvit]

Does anyone have a form that they use while they're in the planning stages of a new database? I have a large task ahaed of me and would prefer to map it out on paper first. Any help or advice would be appreciated. Thank you

 

[JoeMiller]

I assume you mean, how do others go about starting a db design. I usually start by putting down all the things that are needed by the database. IE: reports, datasets, organization, things like that.

Then I look at what I need in order to meet those needs. IE: what data, how much, what's necesary, what's not.

Finally I start to look at all the requirements and put them in a logical grouping, these groupings then become the tables. And after the groupings are made you look at how the groups relate, which becomes your relationships.

HTH Joe Miller
joe.miller@flotech.net

 

[gottaluvit]

We are currently under some tight budgetary contraints so getting actual training on this application will not be made available for some time. I appreciate your response. If you are aware of other forums or websites that would be helpful, I would greatly appreciate the information. Take care.

 

[JoeMiller]

A search on books in the Microsoft Access General forum (forum181) will yield many posts on this subject and TLBroadbent has a great FAQ there as well with many links to helpful access sites. Joe Miller
joe.miller@flotech.net