CIS4327 – Systems Project
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.
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.
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.
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.
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.
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.
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.