I was involved in two separate projects at the Cheapside, City of London
offices. The first, a Y2K infrastructure project went so well, I
was invited on a second. The first project
required the detailing of existing software and hardware for the 500 London staff.
Access 97 was used to keep track of this. The advanced part of
the application displayed this information and upgrading schedules across the
companies intranet using HTML and ASP pages. This meant users could find out
what the upgrades were and when they would take place.
The second project was to create a reporting front end to a SYBASE database
on a SUN UNIX box, extracting the data using ODBC. Once again Access 97 was used with
the MS Graph module. The Access application had 12 combo boxes that could refine
a data selection and display the result graphically in real time. Once a selection
was made, the criteria could be saved with others to create a batch of reports that
could be produced each week from a single click. For an animated illustration of
how some of the application worked please see below...
Please see below for some illustrations of the reports produced...
I also used the Intranet to host a employee survey using a series of
data entry screens, with ASP and HTX files.
The feedback was collated into Access and SQL SERVER databases.
Please see below for the resulting graphics...