Microsoft Access Scheduling

[mwfischer]

Hello,
I am a "novice/intermediate" user of Access, and I have been assigned to look into a new program to organize my departments' travel schedule. Right now it is only a .xls document that is tedious to read and locate any information, so I was wondering if I could use access to make the "spreadsheet" work better. I have created one db in access about a year ago, and I was wondering if anyone had any sample dbs that I could look at to decide what avenue I should take on this.

Thanks

 

[dhookom]

At the very least, you should have tables:

tblEmployees
============
empEmpID autonumber primarykey
empFirstName
empLastName
empDept
emp...

tblEmpSchedule
===============
escEScID autonumber primarykey
escEmpID link to tblEmployee.empEmpID
escStartDate
escEndDate
escDestination
escComments

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[MichaelRed]

Schedualing" is a broad term with many shades of meaning. If all you need is to maintain a list of employees with their travel itenaries, Duanes' table set up is probably sufficient. Going beyond this depends on the additional detail you need. A different set of tables is necessary if, for instance, you need to coordinate the travels of two or more, or to assure that necessary accomodations are also 'reserved' for the travel (transportation / lodging / space accomodation (re trade shows or the like) / track changes in the itenaries (e.g. re-book the preceeding) / maintain a log of expenses incurred through the above activities ... ... )

Going even further afield, you might need to coordinate travel to assure that a certain "manning level" is maintained in various positions with the travel plans.

So far this only begins to open the subject up for discussion. First trhing I would sugest is to return to the requirements and discuss the current (and possible future) requirements and implementation schedule.



MichaelRed