Our Projects >> Washington State Housing Finance Commission
Case Study
J Street Technology is proud to be the exclusive provider of database programming services for the Washington State Housing Finance Commission.
J Street responded to a Washington State RFP and was awarded this contract in September 1999. Since then, we have combined their 6 divisions into an integrated set of
client/server database applications, and have provided continuing support and system enhancements. In 2009, we deployed a major web application to allow property managers
across the state to submit compliance reporting to multiple funder agencies.
Technologies include Access, SQL Server, Word, Excel, MapPoint.
This is a good example of J Street’s standardized approach to desktop application design. Users can select, sort and find Project records until they see the projects
they want to work with. Then they can drill down for more details. This approach helps the user get their job done quickly, and uses client/server techniques for fast
response time while not burdening the SQL Server.
Once the user has drilled down to a specific Project, they can view and edit many areas of information. J Street has a standard “panel” interface that we
developed, similar to a left navigation area on a web pages. It allows the user quickly to switch between different types of information about the record they are editing.
These panels are only loaded when they are needed (unlike the default behavior of traditional tabs), so they are very quick. Also, we provide our own custom navigation buttons
at the bottom. Not only are these nicer looking that the default navigation provided by Access, but also use client/server principles by only loading one record at a time
rather than a large updatable recordset.
We can build complex screens! This one has multiple related subforms of data, along with different levels of calculated totals.
We know how to integrate your database records with your electronic documents. On this screen, you can see multiple documents related
to this project. Each one is a link to the location where the document resides on the network, and the documents can be opened, viewed, edited and printed
right from this screen.
Often, critical business data and calculations can be found in Excel spreadsheets. We can link, import and export your data with Excel workbooks.
We do complex Word merges. This is an example of a full IRS tax form that our system can create and populate with all the relevant data,
saving our client many hours each time.
We can automatically generate mailings. This system sends out automated emails to customizable lists based on criteria chosen by the user,
using these powerful selection screens.
In addition, this system can do something that online email management companies don’t – it can send a mix of email and physical mail,
depending on the information you have for your contacts. This ensures that you can contact everyone regardless of method, and reduce your costs as you update
your database with their email addresses..
We build complex databases! This system uses a SQL Server database containing over 150 related tables. We carefully define all the relationships,
and we always enforce referential integrity to ensure that your data is valid with no “orphaned” records.
2005 - 2010 J Street Technology, Inc. All rights reserved
