Creating Tables

Hi Mehzabin,

Thank you for your post and welcome to the forum;

To answer your question; you should first consider what you have to work with, make a list of all imput data that you expect to receive and where it is going to be coming from. Then make a list of everything that you want to get out of the database, how people will work with it, what printouts you want, what calculations etc etc. Then you can plan how you are going to manipulate the data to achieve the results from the imput data.

Take as long as you need to work through the planning stage, even though you may feel that you are not getting the database built. It is much better to spend more time on this stage, because it will save time later when you discover some part has been ommited and you have to rebuild the database to include it.

In my case I get a large piece of paper and on one side put what I have got to work with, on the other what I want and then build from there. I once took a month to plan a database, and just over 3 days to build it....

I hope that has helped, regards Pete