Model Office Work Tracker 1.0

1
Model Office Work Tracker 1.0

• CIS4327 Systems Project
• Angela Vise
• Spring 2007

2
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.

3
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.

4
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.
5
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.
6
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.
7
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.
8
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.