Mainly Looking for ideas to get this DB started..

[Tejanorey]

I have an excel Sheet that tracks my team's shifts..it reflects everything from holidays to sick leave and so fourth.. I have tabs for each person in the excel workbook and track everybody that way.. the thing is .. I haven't created a db in such a long time I feel like im drawing blank on how to get started..

I can upload a blank sheet and post the link if it helps. Im not looking for anybody to do this for me merely help on getting it started as in ideas or layout and so forth.. thanks guys.. in advance..

Tejanorey

"Do not attack the First Marine Division. Leave the yellowlegs alone. Strike the American Army."
- Orders given to Communist troops in the Korean War; shortly afterward, the Marines were ordered to not wear their khaki leggings to keep the enemy from immediately fleeing

 

[Remou]

There is quite a lot of work involved. You will need a number of tables (employees, airports, time, various look-ups), and a good deal of coding.

You may wish to read

http://www.r937.com/relational.html

and to look at some templates:

http://office.microsoft.com/en-us/templates/results.aspx?qu=time&sc=4&av=ZAC

If you have not already built an application, you will need to consider training.

 

[Tejanorey]

Remou yes I know.. i did a similar db many years ago using office 2k and it took me quite awhile to get it near to what i wanted. I know this is a huge task.. I will check out the links you have posted. Im considering maybe staying in excel and just adding on functionality to it but not sure yet.

Tejanorey

"Do not attack the First Marine Division. Leave the yellowlegs alone. Strike the American Army."
- Orders given to Communist troops in the Korean War; shortly afterward, the Marines were ordered to not wear their khaki leggings to keep the enemy from immediately fleeing