Access idiot..Needs help

[lunchboxfl]

I am trying to create what I would believe to be a simple database. I want workers to be able to cread a new lead(customer). Then myself and another engineer go in and put down how many hours that lead brought the company. Then at the end of the month see which employee brought the most lead hours. Anyone got any ideas on this or if you could help me that would be greatly appreciated. Thanks.

 

[David Eagar]

How far have you got so far and what does it look like?

 

[lunchboxfl]

I have gotten no where. This thing is kicking my butt. I have worked with access before, but this one is kicking my butt where to begin. Any help would be great. Thanks.

 

[checker]

You might be able to use this MS Template of a Contact Management database as a starting point:
http://office.microsoft.com/en-us/templates/TC010178391033.aspx?CategoryID=CT101426031033&av=ZAC000

Then just add fields to the table to capture hours...

 

[David Eagar]

To begin at the beginning then - you will need at least 2 tables, Customers and Employees. Have a good, long think about what data you will need to store in each table. (Data should only be stored ONCE)

Search on Normalisation for best practise