What We Do

Database programmers.
Web developers. Trusted partners.

Our clients depend on us to dive deep into their business issues, re-imagine processes, elucidate strategies, and be totally transparent about costs. They count on us to build reliable systems using the industry’s most bulletproof software. And they fully appreciate that we’re practical innovators who only recommend new technologies when we’re certain they can provide long-term value.

Home

Washington State Housing Finance Commission

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.

Project slideshow

This is a good example of <span class='jstreet'>J Street’s</span> 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. Once the user has drilled down to a specific Project, they can view and edit many areas of information. <span class='jstreet'>J Street</span> 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. 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.