Material Tracking Database. Maintains
information on hazardous building materials for all corporate
buildings. Facilities management users can print reports of materials by building area,
view or print-out floor plans with sampling locations, store photos of
hazard locations, and search regulatory paperwork in PDF and document
Versions have been released in both Windows.NET
(Windows-based application) and in ASP.NET (Data-driven Web
application) using MS SQL Server. PDF files and reports
created using Crystal Reports. Another version uses SQL Server Reporting Services (SSRS)
and Repairs Database. Tracks
all products manufactured and subsequent returns for
maintenance. Allows company to track history for each piece of
equipment. Produces reports showing trends in failure types which
helps them target problem areas. Creates Excel workbooks for further
graphical and specialized analysis. Took a paper-based system and
computerized it, allowing access by users and management. We
imported 20 years of history from Excel spreadsheets and combined with
hand-entered data. Microsoft Access and Excel.
and Inspection Tracking Database. Tracks
all recurring and one-time Inspections and Tests for the more than one
hundred buildings in the organization. Notifies the coordinator
of upcoming inspections. Stores cost and remediation data and provides
status reports based on building or inspection. This database now allows
one person to administer a program which previously required 3 different administrators,
was paper-based and often incurred fines due missed
deadlines for mandated tests and inspections. Access Data Project
using Microsoft Access and Microsoft SQL Server.
Scheduling Database. Schedules
nurses at temporary clinics at multiple locations. Notifies nurses and
customers of schedules, tracks inventory and sales, forecasts
supplies, includes a media notification module, and includes extensive
reporting capabilities. Microsoft Access.
Programs Scheduling database.
Schedules programs, creates invoices and other financial reports.
Helps schedule the instructors, and can print out a calendar of monthly assignments. Capable of emailing invoices and
instructions to teachers. Microsoft Access.
Inventory and Billing
System for a parts distributor.
paper-based system to a database. Client now has the
ability to track inventory, order parts from suppliers as soon as products
are sold, ship orders instantly, and report sales information.
Industrial Training database.
Schedules classes, creates certificates, invoices and other reports.
Notifies administrators when it is time for students to take their
annual training courses and tracks their history. This project reduced
by half the time it
takes to register and process a student. Versions in Microsoft Access
Microsoft Access Data Project with ADO and Microsoft SQL Server.
Survey and Reporting Database.
Maintains building material data,
tracks abatement removal projects, imports data from other sources,
retrieves information for construction, maintenance and remodeling
projects, and allows client to maintain compliance. MS Access.
Marketing Projects Database.
projects using descriptions, project types, fees,
client type, project photos for use in creating targeted marketing and
proposal documents. Client can search for projects based on type of
work or location and pull that information into Microsoft Word. MS Access.
Laboratory Database. Converted an inventory, analysis, and report system for a building
material laboratory to
Access, which also interfaces with an Microsoft SQL-based Accounting System.