Nathan said:
I want to create on project using access for time sheet management in
construction side but i dont have any idea in access can before this is first
time can you help for me?
The best advice I can offer is to give you a sense of what's involved.
Access is powerful and rewarding to use, but it takes quite a bit of
study to master. Noone should expect simply to pick it up and use it -
you do need some introductory training. Microsoft have a good
introduction at:
http://office.microsoft.com/en-us/training/CR101582831033.aspx
... and there are good introductory videos (monthly fee) at lynda.com.
The most important thing by far to get your head around is table design
and "normalisation" - get that right and everything falls into place
more easily. Access is a "relational database", with forms, reports and
VBA modules bolted on. It's important to understand what a "key" is,
and to know how to represent a one-to-one, a one-to-many and a
many-to-many relationship between tables representing "entities".
There are also templates you can explore, adapt and use:
http://office.microsoft.com/en-us/templates/CT101527321033.aspx?av=ZAC
... and many resources on the web. If you add "MPV" to a web query
you'll pick up sites run by "Most Valuable Professionals" a number of
whom provide free advice here.
How's that for starters?
Phil, London
