Keith Nichols
Registered User.
- Local time
- Tomorrow, 00:53
- Joined
- Jan 27, 2006
- Messages
- 431
Hi Folks,
I am shortly going to embark on the second database of my career. I haven't seen anthything close to what I want to do so I thought I would ask for some general guidance before I started, rather than heading down a blind alley.
Any thoughts appreciated.
I am shortly going to embark on the second database of my career. I haven't seen anthything close to what I want to do so I thought I would ask for some general guidance before I started, rather than heading down a blind alley.
- Around 100 users will use the database to create weekly activity reports.
- Reports will all use the same date (Wednesday every week).
- The employee id will be referenced from the Employee_details table of the back end of my first database.
- Users will select the projects from the Prj_Details table of the first database.
- Activity descriptions and comments are added for every project worked on.
- There should be a general comment field for the week.
- Users should be able to copy activities over from previous weeks
- The database should report all those who have not completed a report by a certain time (12:00 noon on Wednseday)
- Individuals should be able to get reports of their activities between any 2 dates
- Management should be able to view weekly individual activities, all personnel active on any particular project or a sumarised list of projects with personnel active that week etc etc
- As can be seen, this database should be accessed very heavily in the hours leading up to 12 noon on Wednesday so this needs to be considered in the design.
Any thoughts appreciated.