New Project, need idea to best approach it...

[RompStar]

Ok, here is what I am trying to do, I know how to do most of it, but I
am not sure which way to go about it. I figure I ask here, since many
of you have been doing this the longest, I would get the best ways to
do it..

Here is what I need to do:

Ok, imagine 3 different departments:

In each Department there will be a manager that will fill out a daily
employee roster excel sheet, this sheet will be on a shared drive on
the local network... The sheet will be simple, Date, Employee Name and
Daily Status (tells if they are here or vacation, or whatever)

Then that sheet stays saved on the network, this part seems the easiest
to do... Date validation, Employee drop down-list and another drop-down
list for the Daily Status.

This part blow I am not sure about, what the best way to make this
happen...

-----------

Now, remember that there would be 3 different sheet..

After the data is filled and saved, by say a certain time limit.. I
would like to make a Master Sheet (different one), and I am not sure if
Excel or Access would be best for this, would prefer Excel, because I
know more :- ) of that...

The Master Sheet would be used by say the Operation Manager who
oversees all these 3 different department to give him a better Daily
Work Force View...

So if he wanted to Run a Querie to say...

On Monday 5/2/05 he wants to see all the employees who were Absent..
and of course somehow it would know to go and look into each sheet
since there would be three different ones...

So, GURU's what up!!! Please give me some ideas, thanks.

Which way should I go about it ?

 

[Nick]

You could do this in Excel but would take some VB to accomplish. Access is
by far the best way for this. It's simple and can be shared and all the data
resides in one place so reports are easy.
In my own opinion I would say forget Excel and do it in Access.

Nick

 

[RompStar]

Any ideas or leads on how to do this in Access, examples, I am sure
someone had to do something like this ?

 

[Larry Bud]

You could do this in Excel but would take some VB to accomplish. Access is
by far the best way for this. It's simple and can be shared and all the data
resides in one place so reports are easy.
In my own opinion I would say forget Excel and do it in Access.

I also say forget about Excel, but Access is certainly not the BEST way
to do it. Do it in ASP and put it on a website with a SQL back end.

 

[Nick]

Yes Larry I agree that Access isn't the best per se but in comparison to
Excel it is the best.
ASp and SQL uis far far better but also much more complicated.

Nick