Slide Armen Stein - Owner of J Street Technology - Custom Web Application - 98004 Friendly, practical,
business-savvy developers
Yes, we really do exist. SEE WHAT WE DO
Slide 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.
Slide how-we-work A human approach to application development. Let go of that programmer stereotype: introverted, oblivious to budget, and hell-bent on using all the latest gadgets. At J Street, we’re fully plugged in to the human dynamics behind creating successful partnerships and phenomenal solutions. You won’t find anyone that’s better at listening carefully, anticipating issues, and avoiding pitfalls. HOW TO CHOOSE A DEVELOPMENT TEAM Slide our-clients From cruise ships to clogs, we’re into it. Our clients represent an astounding variety of industries. Some have household names; some you’ve never heard of. Some are local; others multinational. There are for-profit businesses, and not-for-profits, too. But they all have one thing in common: Every day, J Street’s solutions help them do what they do even better. WHAT CLIENTS SAY ABOUT J STREET Slide Who We Are - J Street Technology - Custom Web Application - 98004 Engaged. Insightful. Enduring. That’s J Street. We may be some of the most seasoned, business-savvy application developers you’ll ever meet. We also happen to be some of the warmest, most candid, and clear-thinking folks on the planet. Our clients love that about us. We bet you will, too. GET A FREE CONSULTATION

J Street Movie Reviews Case Study

Need:

Track and review the hundreds of movies that the J Street team watches.

Solution:

An Access web application running on Office 365 that keeps all those reviews together.

Technologies used:

Access web application, Office 365

At J Street Technology, we use our skills to build systems for ourselves! We also love to watch movies and discuss them – we even review them at our company meetings. So being database nerds, of course we had to build our very own application to track our movie reviews. Over the years our Movie Reviews application has migrated from Access to SQL Server, ASP, and ASP.NET. This version uses Access 2010 web services with a SharePoint back-end database, running on Office 365.

moviereview1
The entire application runs in any web browser, including IE, Chrome and Firefox. Unlike traditional Access applications, no desktop installation is needed! The first screen allows the user to search and sort movies.
moviereview2
The Movie detail screen is a traditional form and subform architecture. But because the application is running on the web, there are some limitations. Aggregate values (like averages and sums) can’t be calculated using traditional totals queries. Instead, we calculate them into stored fields using Data Macros, which are defined at the table level and are web safe.
moviereview3
Access 2010 includes an intrinsic web browser control that is fully programmable. This makes it easy to display related web content right in the application. In this case, we’ve created a tab on the Movie screen that displays the selected movie’s IMDB page.
moviereview4
It’s easy to maintain the people in the database (these names have been randomized). Again, we use data macros to calculate average scores and review counts. We also use a technique to sort inactive people to the bottom of the list, not only here but also in dropdown lists.