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.

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. We also provide our own custom navigation buttons at the bottom, which 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.