| |
| |
 |
| |
 |
| |
Electronic Time and Billing System (ETABS) Overhaul (Access 2003, SQL Server 2005) SCA employees use ETABS throughout the day to document billable hours spent working for their clients. The Emerge Group optimized the SQL database via table indexing and the creation of views and stored procedures in order to improve back end processing time. It also redesigned the front end in order to make functions more readily accessible and to minimize data entry. The UI was redone to more closely resemble SCA's web site in order to maintain a consistent corporate identity. |
| |
| Click here to view a sample of the ETABS welcome screen. |
 |
| |
Student Accommodation System (Access 2003) Sara's New York Homestay helps foreign exchange students locate temporary housing. Prior to hiring The Emerge Group, Sara's maintained their growing list of students and accommodation providers in a variety of Excel spreadsheets. The system became unmanageable as their business grew. We designed a database where students can be electronically matched with housing providers based on their particular needs (price, neighborhood, proximity to school and transportation, area amenities, etc.). Staff has ready access to an online availability calendar, so they can view graphically when rooms are booked vs. available for occupancy.
|
| |
| Click here to view a sample calendar displaying booked and available days. |
 |
| |
| Warehousing / Inventory (Access 2003/2007) Pyramid was maintaining its inventory for its Northern and Southern California facilities in two separate Access databases. There was no way for management at one site to view the data of the other location. In addition, the database was designed in such a way that retrieving information typically meant clicking through dozens of records in order to locate the needed data. First, we consolidated the data for the two warehouses into a single SQL database physically residing in the NorCal office. SoCal users connect to it via a secure VPN connection. Now management can report on both locations, and staff can view inventory detail at both locations. Next, we redesigned the interface so that users could quickly filter and sort on key criteria, enabling them to quickly locate critical business information.
|
| |
| Click here to view a sample inventory screen with sort and filter capabilties. |
 |
| |
| Access Backend Tuning TVS created a database for a client that ran over a remote connection. As the database grew, it became slow to launch. Reports that used to run in seconds were taking minutes to display. The Emerge Group tuned the backend database and rewrote the underlying query for the slow reports. We were able to achieve a 90% improvement in database launch time and reporting speed.
|
| |
|
| |
|
|
;void('');){kind=link}
;void('');){kind=link}
;void('');){kind=link}