A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Review Information Database



 
 
Thread Tools Display Modes
  #1  
Old April 13th, 2007, 08:30 PM posted to microsoft.public.access.tablesdbdesign
AccessIM
external usenet poster
 
Posts: 81
Default Review Information Database

I need to create a database that tracks the progress of supervisors on their
performance review requirements.

Each supervisor has their own set of objectives that they need to complete
in the fiscal year. I am trying to create a database that tracks each
supervisors objectives and whether or not they have completed the objective.

I have tried several different design but have not been satisfied with any
of them.

Does anyone have any suggestions on the best way to do this? I have tried
all objectives in one table with a name field to identify the supervisor they
belong to, also tried each supervisor having their own table but am concerned
with this being too much maintenance if new supervisors come or a current
supervisor leaves.

Any thoughts are greatly appreciated. I am really stumped on this one.
  #2  
Old April 13th, 2007, 09:26 PM posted to microsoft.public.access.tablesdbdesign
KARL DEWEY
external usenet poster
 
Posts: 10,767
Default Review Information Database

Have a table for all Supervisors and a table listing all Objectives.
Relate both tables in a one-to-many relationship to a third table SupObj.

SupObj --
SupObjID - primary key - autonumber - integer
SupID - number - long integer - foreign key related to Supervisors primary
key.
ObjID - number - long integer - foreign key related to Objectives primary key.
DueDate - DateTime
CompDate - DateTime
VerifiedBy - text
Remarks - memo

You can use the dates to see if completion goal has been met. If met early.
How much time left to complete. Rollup for percent complete, late, or early.
--
KARL DEWEY
Build a little - Test a little


"AccessIM" wrote:

I need to create a database that tracks the progress of supervisors on their
performance review requirements.

Each supervisor has their own set of objectives that they need to complete
in the fiscal year. I am trying to create a database that tracks each
supervisors objectives and whether or not they have completed the objective.

I have tried several different design but have not been satisfied with any
of them.

Does anyone have any suggestions on the best way to do this? I have tried
all objectives in one table with a name field to identify the supervisor they
belong to, also tried each supervisor having their own table but am concerned
with this being too much maintenance if new supervisors come or a current
supervisor leaves.

Any thoughts are greatly appreciated. I am really stumped on this one.

  #3  
Old April 13th, 2007, 10:09 PM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Review Information Database

On Fri, 13 Apr 2007 12:30:03 -0700, AccessIM
wrote:

Does anyone have any suggestions on the best way to do this? I have tried
all objectives in one table with a name field to identify the supervisor they
belong to, also tried each supervisor having their own table but am concerned
with this being too much maintenance if new supervisors come or a current
supervisor leaves.

Any thoughts are greatly appreciated. I am really stumped on this one.


Well, the one table per supervisor idea is definitely not a good idea, just as
you concluded.

You need THREE tables:

Supervisors
SupervisorID
LastName
FirstName
etc

This table may better be simply a query selecting all Supervisors from your
Employees table, if you have one.

Objectives
ObjectiveID
Description
other info about the objective

ObjectiveAssignments
SupervisorID link to Supervisors, whose objective is this
ObjectiveID link to Objectives, what is this person's objective
fields about THIS objective for THIS supervisor, e.g. due date, completion,
comments

John W. Vinson [MVP]
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:47 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.