Project, time, client, contact tracking

[windwardmi]

1st of all, I'm a beginner level Access user even though I have been trying to learn this past year. I can't seem to get the relationships between tables and designing reports and forms after that.



I want to keep track of my small company's projects, employee time, clients, contacts, expenses, employee training, ships in projects and more. Security to have employees input time and expenses and supervisors keep track of projects.

Can I start with 2007 TIME and BILLING downloadable database from Microsoft and bbuild frrom there. Also can this site help me progress step by step or offer leads to contacts that can help.

Where do begin!!!

[ndtownsend]

I used to teach non computer people to think of a database as a very robust rolodex. Each table should contain one subject....like action items....like a shopping or job event or a subject like people or things. The columns are unique characteristics of each subject.

Okay now you need to see the data.....thus you have an Online view called form
or a printed view called report......(you don't actually have to print the report...

Of course I have summarized dramatically...but hopefully you get the idea

[orange]

windwardmi,

Read the first few topics at this site.
Normal Forms,Normalization, Entity relationship Diagramming
http://www.rogersaccesslibrary.com/forum/topic238.html