Hi
I need an Access 2007 Database creted to help me manage IT projects.
It would have the following functions:
1) Issue Management
2) Risk Management
3) Action Items
4) Meeting Minutes
5) Document Library
6) Time Sheets
7) Status Report
cheers
Josh
## Deliverables
Hi
I need an Access 2007 Database creted to help me manage IT projects.
It would have the following functions:
1) Issue Management
- Create, Review, Search and Edit
- Full Auditing based on windows logon to understand the life cycle
- Email Automated Email on Creation (to assigned person), on change (to creator and assigned) and Close (to creator and assigned)
- Full Reporting Suite
- Anyone can enter a Issue Item but once assigned only the PM and Assigned person can change
2) Risk Management
- Create, Review, Search and Edit
- Full Auditing based on windows logon to understand the life cycle
- Email Automated Email on Creation (to assigned person), on change (to creator and assigned) and Close (to creator and assigned)
- Full Reporting Suite
- Anyone can enter a Risk Item but once assigned only the PM and Assigned person can change
3) Action Items
- Create, Review, Search and Edit
- Full Auditing based on windows logon to understand the life cycle
- Email Automated Email on Creation (to assigned person), on change (to creator and assigned) and Close (to creator and assigned)
- Full Reporting Suite
- Anyone can enter a Action Item but once assigned only the PM and Assigned person can change
4) Meeting Minutes
- Create a Meeting with Agenda
- Print/email a Meeting Agenda via Report (PDF)
- Send Invite to Attendees
- Update Meeting Minutes
- Update Actions from teh Meeting
- Create a new meeting from a previous meeting allowing option to transfer action items by status
- Action Items linked to Action Items in section 3
- Print/email a Meeting Minute via Report (pdf)
- Full Reporting Suite
- Anyone can enter a meeting but obce meeting has been conducted and minute sent on PM can change
5) Document Library
- Add Submitted Docements
- Version Control
- Allow Different types of documents (Deliverable, Manuals)
- Full Reporting Suite
- Only PM can Change Document
6) Time Sheets
- Enter Time sheet
- Full Reporting Suite
- Search Timesheets (your own only)
- Full Reporting Suite
- PM has access to view search all time sheets
- Allow for Approval Workflow
- Must be able to Print an Approved timesheet for submission with Invoice
7) Status Report
- Enter Template
- Produce Report with open items (issues, risks...)
- Full Reporting Suite
8) General Requirements
- User Friendly
- Able to be hooked to Sharepoint
- Must be able to lock it down to changes
- Multiuser
- Security - User - Can enter anything but is
- Control Dash Board
- Users
- Open Items (issues, risks, actions, meeting)
- Pie Graph Based on all items but only showing their items
- PM
- Own Items as above Plus
- All Project Items
cheers
Josh