create vacation time database

[Guest]

I want to create a timesheet database, here's what I want to do in my own
words: Have employees choose projects from a drop-down list (as many as
necessary) and enter the time put into each project. I want this data to
automatically go into a separate database that only I have access to, which
calculates both sick time earned and vacation time earned. Since each
employee will have varying projects in varying order on their timesheets, can
ecel automatically recognize the data and put it into the appropriate place
in the sick/vacation database? Any ideas to this problem will be GREATLY
appreciated

 

[Guest]

Just a thought? You could do the whole thing in Access much more
easily...give your users a form that they can fill out with their info
(project name, time spent) that ties to another database file only you
see...then, in the file only you know of, do a query where you calculate the
accruals.