80 likes | 514 Vues
Model Office Work Tracker 1.0. CIS4327 – Systems Project Angela Vise Spring 2007. What is Model Office?.
E N D
Model Office Work Tracker 1.0 CIS4327 – Systems Project Angela Vise Spring 2007
What is Model Office? Model Office is responsible for handling the set up of new business and new clients for CHCS Services Inc. They were tracking their projects using spreadsheets, but they had outgrown this method and needed something better. Model Office Work Tracker 1.0 is the something to fill this need.
What is Model Office Work Tracker 1.0? Model Office Work Tracker 1.0 allows the people in Model Office to track their projects as well as their companies, departments, employees, and locations. The database also allows them to easily run reports, which were almost impossible to get from their spreadsheets.
Main Switchboard Here the users can interface many of the tables of this database. They can choose to search for a project, enter new information into any table, or run reports.
Search Projects Form Here the user can search for an existing project. They can search by employee, company, department, or status. This form uses a search function written in Visual Basic.
Input Projects Form Here the user can enter information about a project. This form also uses a sub-form for creating notes about the project, which was very cumbersome with their spreadsheets.
Reports Form Here the user can choose reports to run. Most of the reports are simple select queries, but some are actual reports. These reports were not possible with their old system of spreadsheets.
What is Model Office? Overall, this project was very educational, and I was able to see quite a few aspects of project development that I had not seen before in other courses taken here at the university. The client was extremely happy with the product, which was also very rewarding.