Sep 3 2007, 12:36 AM
I'm designing a very big database for every aspect of work in a group of companies
now, i reached the financial design part, and i think that this part is a critical one
because a small mistake, and u will lose millions of dollars (or derhams in my country)
i have some ideas on how to design it, but still i want some resources: tutorials, samples, books...etc
that can help me in designing the database (making the model and algorithms)
Sep 3 2007, 10:23 AM
sabaa el khair, Ahmed !
for starters, read this:
Access Basics http://www.utteraccess.com/forums/showflat...;Number=1220772
30-page Word document on Access Basics (for Programming) -- it doesn't cover VBA, but prepares you for it because it covers essentials in Access
Sep 3 2007, 01:43 PM
well, i designed most of the database
i'm not a beginner
but, i want a general idea about designing the financial part, because i thought that this part is common
and i just need help regarding the modeling of this part
and, thank u for ur help..
Sep 3 2007, 02:04 PM
YOU are the best one to determine what you need as it is your business... we can help you refine your structure once you decide what you need to track ...
the best way to determine what needs to be tracked is this:
go around to all the people that keep track of this sort of information. Ask to see samples of the forms and other paperwork they fill out. Ask to see what reports need to be generated. And, with a paper and pen, ask them to describe what they do -- and take notes!
From this information, decide what you need to keep track of. Read the link I gave you and break the information into tables as best you can -- and set them up. Once you get to this point, post the structure that you have and we can make comments.
It would also be a good idea to evaluate packages that are already on the market ready to be used. Since you know Access, if you decide on a market solution, pick one that has ODBC capabiity so that you can easily share data with Access.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here