Solved

Allocate Work

Posted on 2012-03-13
9
324 Views
Last Modified: 2012-03-20
Hi guys

Do anyone have a sample access database to allocate work to different people.
As we receive some work on each day and looking a way to allocate it by an access database

thanks

Regards

Rahul
0
Comment
Question by:surah79
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
  • 2
9 Comments
 
LVL 4

Expert Comment

by:Paul-B
ID: 37717774
Sounds like you might want something like this...

http://office.microsoft.com/en-us/templates/CT010142603.aspx#ai:TC001018467|
0
 
LVL 9

Expert Comment

by:Orcbighter
ID: 37718744
Or Microsoft Project!
0
 

Author Comment

by:surah79
ID: 37722496
Hi Paul

Apologies for late reply but I am looking for allocation like there is queue where everyone can see unallocated work and then they can transfer to themselve, so when they work on it will come on there name.

Hi Orcbighter

I am looking for access database

Thanks

Rahul
0
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 
LVL 4

Expert Comment

by:Paul-B
ID: 37722738
OK what version of Access are you using now and do you have any examples of what fields in the database you would be needing. Are we talking about something simple like ..

Job Name
Job Date
Job Description
Assigned To

etc. etc..?
0
 

Author Comment

by:surah79
ID: 37722774
Hi
I am using Access 2003 and
Job Number
JobName
JobDate:
Job Type
Job Descritption
RepName
Date Action
Date Allocated
Date Completed or Still working or Followup

Thanks

Rahul
0
 

Author Comment

by:surah79
ID: 37740611
Hi Paul

Are you still looking on this ? If you want me to post it another question

Thanks
0
 
LVL 9

Expert Comment

by:Orcbighter
ID: 37740629
What exactly are you asking for?
Are you asking for a ready-made, out-of-the-box solution (for free) that does exactly what you want? - probably does not exist!
or
Are you asking for experts to design and code the thing for you in just that way that you would like? - probably not going to happen!
or
Are you asking for ideas on how to change a previously suggested free example? - possible
or
Are you asking for ideas on how to proceed with a green-field development of an Access database project by yourself?
0
 

Author Comment

by:surah79
ID: 37740660
Hi Orcbighter

I am looking any one  of the following

Are you asking for ideas on how to proceed with a green-field development of an Access database project by yourself?

Are you asking for ideas on how to change a previously suggested free example?

Thanks
0
 
LVL 9

Accepted Solution

by:
Orcbighter earned 500 total points
ID: 37740704
In a green-field development, just a few quick thoughts:
I would proceed from the following steps

1. Create your database:

Tables: Tasks, Personnel, Allocation

Tasks
-----
Task_ID (Primary key)
Name (secondary key)
Description
Type                - presumably you have a category for different job types
CreationDate        - date entered in system
CompletionDate      - date task was completed (or Null, if not completed)

Personnel
---------
Personnel_ID (or employee number, whatever)
Name
whatever else you need to know about this person

Allocation
----------
TaskID          -
Personnel_ID    - composite primary key
Date Assigned
Status          - open or closed
DateCompleted

2. Create some queries
(a) query on currently assigned task by Personnel_ID
    - query on Allocation table, crossed with Personnel table for person's name, etc, where status is open
   
(b) query on currently pending tasks
    - query the Tasks table for all tasks where CompletionDate is NULL
   
(c) Action - when a task is completed, add a completion date to tasks table and to allocation table for that person and task, and set status on Allocation to closed.

I would not put the last details on the Tasks table because If you have to reopen the task for whatever reason, you will lose history.
Your Allocations table will also be your history, hence the duplication of the completion date (specific to the person, rather than the task).
If the Allocations table gets too big, you could create a copy of this table and call it Archive, and just move all records older that a convenient date from the Allocations table to this Archive table.

3. Reports
Create them as and when you need them
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A theme is a collection of property settings that allow you to define the look of pages and controls, and then apply the look consistently across pages in an application. Themes can be made up of a set of elements: skins, style sheets, images, and o…
The canonical version of this article is on my web site here: http://iconoun.com/articles/collisions/ A companion presentation is available here: http://iconoun.com/articles/collisions/Unicode_Presentation.pdf
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question