Results 1 to 3 of 3
  1. #1
    a4131888 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Aug 2012
    Posts
    2

    Exclamation Access Database: I need to assign work out to multiple employees daily. HELP

    Hi Guys, I am pretty new to Access. I have somehow been asked to Automate some processes in my job. Here how it currently works:



    A report is imported into Excel. On a daily basis this has to be put into the correct order, then the work is manually divided amongst 10 employees. A new workbook is created for each employee. As each hour passes, they save the info on their own sheet that they have updated. Then their boss copies the updated info onto the Masterfile and hits save. A new Masterfile is used every day and alot of manual work is involved for the boss.

    They want to Automate the process and improve it by:

    Have the report imported into Access.

    Have it automatically organise the report into the correct order for distributing work

    ASsign out work to each employee from this report. Do i need separate tables on can employyees work off the one table?

    Should I have a workingtbl and an employeetbl?

    The info should update every hour so a report is created containing stats of what the employee completed each hour.

    Once the day is over, can the completed work be saved to somewhere, so that when the following days report is imported, the previous days work is not included? it is important that all previous days work is retreivable?


    Any help on where to start would be great guys!!! Even how I should start it all would be a help I dont want to make a mess of it!! Thanks~!

  2. #2
    a4131888 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Aug 2012
    Posts
    2
    Also each employee would be updating information on the assigned work given out to them

  3. #3
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Generally speaking Access should be able to handle that. Typically one "transaction" table, not tables for each employee. Multiple employees can work in the same table, they just can't edit the same record simultaneously.

    Rather than saving the completed work off somewhere, typically it would stay in that table. A date field would keep yesterday's work separate from today's. That would let you easily query yesterday's work, today's, this week's, last month's, etc.

    As to what tables you need, more knowledge of your requirements would be needed. Generally, relational database design is much different than "spreadsheet" design. We use what's called normalization to lay out table design. More here, among others:

    Fundamentals of Relational Database Design -- r937.com
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Employees Database Management System
    By salsai in forum Database Design
    Replies: 3
    Last Post: 01-22-2012, 12:45 AM
  2. Search employees backup database
    By mademen in forum Access
    Replies: 4
    Last Post: 12-19-2011, 03:30 PM
  3. Access database will not work in .Net 2003
    By Brilene in forum Access
    Replies: 0
    Last Post: 03-18-2011, 03:41 PM
  4. Help starting up a daily entry database
    By sparx in forum Database Design
    Replies: 1
    Last Post: 01-12-2011, 10:56 AM
  5. Add Multiple Employees to a Training
    By Voltzwagon in forum Forms
    Replies: 1
    Last Post: 01-29-2010, 10:53 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums