"We have been very pleased with the competent, prompt and courteous service they have provided to us."Stu Perlman
Winning Solutions, Inc. (WSI) has worked with a number of clients during our nearly 20 years of existence to help develop a MS Access Application, generate custom reports, integrate their Access system into another system, and wide variety of additional services. Below is a sampling of some of the types of applications that we have built for our customers using MS access.
At WSI we realize that no two clients are exactly the same, and therefore we listen to your needs to deliver to you the solution you desire with the specifications you want. Click Here to view our main Microsoft Access page with more details on our extesive Access experience.
The pension department at Farm Bureau approached WSI with the need to have an Access Database built to track all their employees and the contributions the employees made to plans. During this project some very complex data import, exchange, and update took place through various data entry screens and processes. Also, Advanced Pension Calculators were built into the system to allow the user to generate a series of ad-hoc reports to let the employee know what his current vested benefit is. WSI also built a very complex and detailed reporting system which allowed the user to get various reports for the time period that the user specified. The system helped replace an outdated, manual, paper system and ended up saving the department a large amount of time and effort.
Fox Engineering contacted WSI to help the business maintain and enhance a Customer and Prospect Tracking System that they had built internally. The system had a number of issues, errors, and bugs, which were promptly addressed first. After that, Fox then requested that a number of search and reporting functionalities be built into the system that were not present before. These functionalities have helped the staff of Fox be more efficient in their generating of reports and mailing materials to their existing and prospective customers.
FitSense and WSI have had a long and valuable relationship, and during that relationship, WSI has developed a number of systems for Fitsense. One such system is a Sales Tracking and Shipping Application. FitSense contracted WSI to develop their website, www.fitsense.com , and as part of that project they also wanted WSI to develop an e-commerce solution for selling their product. The next step in the process for WSI was to develop a MS Access system that would tap into their e-commerce database and retrieve all their sales data into the Access Database. Once the data was imported, a number of reports and even a shipping module were developed to help further streamline the process for FitSense.
The Johnston Chamber of Commerce came to us with the problem that were simply spending too much time smoothing and preparing their data for printing in brochures and labels. To help reduce this task, WSI built a Membership Tracking system for the chamber that allowed them to keep track of current membership information and run a series of canned reports off of that data, which has helped efficiency. In addition, an invoice module was added that allowed for the creation of renewal invoices to be created in one large batch again reducing the amount of time spent on that activity.
Polk County Bank came to WSI with an Excel spreadsheet that they used within the bank for balancing tellers, vaults, and all other cash activities. As the data was needed for each day, they had a very cumbersome copy and paste process that always seemed to fail when they moved to a new month and/or year. WSI then developed an Access-based system where the copy and paste functions were automated and also added some controls into place that made human errors easier to isolate and fix. In addition, a number of reports were put into place to help the users know just what needed to be done for the day.
A department of the University of Iowa Hospitals and Clinics needed to replace an outdated record keeping application. WSI built the new application and added several new features including enhanced business logic to reduce data entry errors, simple audit trail information, and the ability to print collected data directly onto official forms provided by the State of Iowa. The new system saved the department substantial time by eliminating the need to fill out paperwork by hand and has increased data accuracy and consistency.
During Y2K WSI was able to work with Custom Hose to tailor an inventory and billing system to replace an aging DOS application. For about the cost of buying a vertical market solution, WSI was able to provide Custom Hose with a program that worked exactly the way they wanted. Finally, their business dictated how the software needed to work instead of the other day around. WSI has continued to work closely with Custom Hose since the program was first installed to update the program to meet their changing needs. When their business grows WSI, is ready and able to move their Access program to Microsoft's more powerful SQL Server. After four years of continuous business use, the Access based system continues to be relied upon everyday to run the business.
In coordination with the Iowa Games, the ACVB was responsible for lining up volunteers for the Iowa Games. WSI was contacted to create an Access Database that would take the registrations that the volunteers made on the ACVB website and allow ACVB to assign or re-assign volunteers as needed. A complex reporting system was then developed that alerted ACVB to areas where more volunteers were needed and also allowed them to send out letters to the volunteers, in a timely and efficient manner, with instructions on what to do.
The IEC came to WSI with an existing Access Database that they wanted to have optimized and streamlined for performance, data entry and reporting. WSI optimized all the tables and code in the database, added some new features including Loan and Grant tracking to enhance reporting and data entry, and helped make the overall efficiency of the system take a step forward.
The ISU Stab Lab came to WSI with a need to simplify the tracking of their grants, projects, and hours associated with those projects along with the budget for this project. WSI developed an intensive data entry process for keeping track of this information and then developed a very complex reporting system that allowed the user to see where a particular project was sitting at any point in time.
Bilbrey Insurance and WSI have had a beneficial ten-year relationship. Bilbrey initially came to WSI with the desire to get their member information into an Access Database. After that initial setup and customization, Bilbrey has continually pushed the envelope forward and over time has developed a complete custom Insurance Underwriting System for the Iowa Communities Assurance Pool. This system has allowed Bilbrey to expand many times over while keeping costs and employees stable. For a more detailed look at our history with Bilbrey, be sure and view the case study located here.
Marion County Abstract contacted WSI to convert a DOS based system into an Access/Visual Basic/SQL Server application. They needed a system that would allow them to quickly and efficiently work with Title Information and a Custom Access Database was developed to help deliver on this need.
The Holiday Inn at Gateway Center needed a guest and events database to better serve their clientele. WSI created an application that tracked guest information along with events occurring during their visits. It also recorded guest personal preferences along with history of visits. The reporting features implemented in the application help the sales and marketing department better serve returning guests and the marketing of new customers. The Events Tracking feature also helps the reservations department plan and schedule for upcoming events.
Mr. Foamy was interested in updating their paper-based price quoting work-ups to a less complicated and more user-friendly system. In the field, salespeople had to call the main office to have quotes put together. WSI was able to create an Access quoting application that implemented their wide range of materials and selections. They are now able to do price quotes on the spot, which has significantly streamlined their business.
The relationship between Triplett Realty and WSI grew from a functional hardware support to application support. Triplett needed a way to automate their leasing creation process for their rental properties. WSI created an Access application that stored rental property information and merged it with the leasee information. Now, leases are printed in a matter of seconds and valuable information is being stored in the process.
First National Bank contacted WSI to help them create run-time versions of a number of databases that they had created internally. WSI worked with the developers at First National Bank to help teach the creation process of databases as well as the installation of the database. In addition, WSI enhanced an Officer Call, Trust Officer Call, and Stock Tracking databases to allow them to be more user-friendly and robust by creating standardized forms, reports, tables, and queries.
The Glen Oaks Owners Association contacted WSI to write a custom application to manage non-resident access to the private, gated community. WSI wrote a stand-alone Access application, called the Guest Management System, to track guests and vendors seeking access to the community. The application allows security personnel to quickly search a database to find approved guests and vendors and log their entry to the property. This log includes the guest's name, time of entry, and license plate information. Guest and vendors not in the database may be added on the spot if approval of their entry is received from a resident. This application replaced a cumbersome paper system that required detailed maintenance.
As the technology provider for the Iowa Games, WSI created an application to keep track of all athlete and event registrations. While most of the data entry was done through a web interface, the Iowa Games had some complex reporting needs. An Access reporting tool was developed to accommodate their needs; the reporting tool allows the user to get numerous reports based on criteria that the user inputs in an easy-to-use, report-menu format. The new application replaced a slow manual system.