New Database

[Ljffusion1]

Hi

It's been a while since I have worked with access and I need some
advice. My boss asked me to create a database for production.

it will consist of a job code like 10, a desription, Employee Name,
date, start time, end time, total time and quatity. he wants to be
able to generate reports by month and week for let's say boxes cleaned
which would be code 10 with a standard rate of 60 boxes per hour to
determine if employee's are meeting that rate.

First off should I create different tables or just make one table?
Second how do I go abbout generating the reports needed?

Thanks

 

[Al Campagna]

Ljffusion1,
From your brief description, I would think not...
It appears to be a simple (flat) diary of jobs.
Note: make sure you get a StartDateAndTime and a StopDateAndTime for jobs
that might span more than one day.
The only external table you might need would be something like a
tblObjectives, or a tblProductionGoals, which would store the production
"goals"... that you can compare your job performance statistics against.

As far as report generation, that's too broad a question. Get your
tables and forms set up, and then return here if you need specific help to
create the report/s.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Lance]

Good DB design would be to create a table consisting of job information, a
table consisting of employee information ( which you may already have
someplace ), and a table consisting of work times/date/production.

It may seem like a bit of extra work, but it will save you a LOT of work in
the long run, make your data less prone to user input errors, and make it
much easier to add new features which are sure to be requested later.