Schedule A
Free Consultation

OR CALL (425) 679-6206

Washington State Housing Finance Commission Case Study

Need:

Bring six divisions together into a centralized database.

Solution:

A central SQL Server database with separate Access applications for each division. Customized features, shared data.

Technologies used:

SQL Server, Access, Word, Excel, MapPoint

Washington State Housing Finance Commission asked J Street to create a centralized database to support multiple divisions. We created a system that combined their 6 divisions into an integrated database.

wshfc1
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 database.
wshfc2
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 page. 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.
wshfc3
We can build complex screens! This one has multiple related subforms of data, along with different levels of calculated totals.
wshfc4
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.
wshfc5
Often critical business data and calculations can be found in Excel spreadsheets. We can link, import and export your data with Excel workbooks.
wshfc6
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.
wshfc7
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.
wshfc8
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.
wshfc9
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.

Call us any time! (425) 679-6206

J Street Technology
Linkedin Facebook Youtube

16625 Redmond Way Ste M
PMB 463
Redmond, WA 98052
Map and Directions

Quick Links

Developer Center

Services

Articles

Newsletter Signup

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Copyright © 2005-2025 J Street Technology, Inc. All rights reserved.