What's th

[FullyFamous]

I'm trying to build a database that I can get a report weekly, then monthly and then by year (calendar and fiscal) of certain tasks done by different employees, from different locations. I want each employee to be able to enter what he/she did for each day.



We currently have an Excel spreadsheet that is manually entered for each task done. Then that data is sent to me to compile a monthly report.

I having trouble understanding how to break down the various parts/type of info I have into parts that can be made into the database. Hopefully I can get the basics on how to best set this up. So here's what I've got to work with:

• There are currently 13 employees (Sandra, Vicky, Steve, Greg, etc) that will be doing various tasks each day.
• There are 6 different types of tasks each may do each day. Those tasks are:
  
  • Contacts
  • Hearings
  • Interviews
  • Phone Calls
  • Correspondence
• Within Contacts, there are these things that could be done:
  
  • A-5 ID
  • A-5 At Risk
  • Interlock
  • Civil
  • Fault Hearings
  • Rehab Hearings
  • ID Hearings
  • Misc Hearings
• Within Hearings, there are these things that could be done:
  
  • AL Limited
  • Non-AL Limited
  • 1st RE
  • 2nd RE
  • 3rd RE
• Within Interviews, there are these things that could be done:
  
  • Fail to Appear
  • No Action
  • Deferred Action
  • Suspension

And so on.

I think once I get the basic concept of what tables and forms I need, I can probably add the other elements I need. It's hard to go from a Excel mentality, to and Access mentality.

Thanks in advance for the assistance.

[June7]

Review 'sticky' thread tutorials at http://forums.aspfree.com/microsoft-access-help-18/