I need to keep up with employee production daily (piece work)

J

John W. Vinson

Jackie, you're talking to real human beings, not to a search engine. If you
have a question use the big textbox to enter it in a comprehensible way. Do
you already have an Access database? Do you want to design one? What
information do you have that you need to track?

John W. Vinson [MVP]
 
J

jackie

John W. Vinson said:
Jackie, you're talking to real human beings, not to a search engine. If you
have a question use the big textbox to enter it in a comprehensible way. Do
you already have an Access database? Do you want to design one? What
information do you have that you need to track?

John W. Vinson [MVP]
We are a small company that makes grade stakes. I need some type of database to keep up with the daily production of how many stakes are cut. The workers turn tickets in to me at the end of the day.
 
J

John W. Vinson

We are a small company that makes grade stakes. I need some type of database to keep up with the daily production of how many stakes are cut. The workers turn tickets in to me at the end of the day.

And you want one of the unpaid volunteeers here to... what? Create the
database for you? Sorry, doesn't work that way!

You know how your business works; we don't. I have no idea what's on a
"ticket" so I can't suggest how it would be entered into a database. You will
need to identify the real-life Entities (people, things, or events of
importance to your application) and create a table for each class of entity,
then design Forms and Reports to manage those tables.

For some tutorials on how to get started with designing databases, see

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

If you have *specific* questions ("how do I create a table", "how do I
calculate totals per worker") feel free to post - but so far you haven't asked
a question at all, just stated a need.

John W. Vinson [MVP]
 
Top