Networks

Programming

Consulting

Security

Home

Contact us
 
Networks
Programming
Security
Data Recovery
Consulting
Repair
Websites
Training
 
References
About Us

 

Microsoft Access and MS SQL Server

 

    Store information of any kind, and get the reports you need. Access is the ideal tool, combining a rich graphical front end with a powerful programming language. We are experts in Microsoft Access and MS SQL Server development projects. From the smallest table and report designs to the most complex front end Access / backend SQL Server application,  we can solve your problems.

  We have written hundreds of programs, from bar coding systems for FDA drug trials to recipe systems for plastic manufacturing. We can probably do yours. Some of our Access work:

   new york Builders Institute needed a database system to track 600 members; not a great matter, you say ? But these builders had scores of  meetings, (and members who  wished to be informed when and where they were, and the main office wanted records )  and contributed to various funds, and printed various books of members and their services , and wished to share some of this data on the web ... All of this was done by us in Access.

  What started out as a simple table grew over 4 years into scores of tables and perhaps 100 reports and queries. Here's a screen shot of a typical Access report from this project, along with a list box giving a choice for the town to draw the data from.

 

  Debticated Consumer Services has thousands of clients, all making payments to get out of debt ... we designed and wrote a system for tracking these clients, their payments, and the support staff servicing them. We then wrote a system for calculating payments. This system drew from a table of thousands of creditors , each with it's own payment rates and discounts. Done in Access, this calculator is used by 5 to 10 staff  on  a network simultaneously, demonstrating the power of MS Access . The system saved tens of thousands of dollars in clerical error, and has  greatly enhanced staff productivity .

  Here's a screen shot of the payment calculation page. Note that we have here a mixture of data and behind the scenes math. The user chooses a creditor, and then enters the amount; the program (driven by our coded instructions) then makes calculations and summations. Nothing very complex here ( though very effective for the client); we could have just as easily done far more complex calculations of a financial, statistical or scientific nature.

 Splash Designs of  Manhattan represents designers and sends out  artist's prints to clothing manufactures, and needs to track which artist produced them, where they were shipped and when they should be returned. This subsystem integrates with a 6000 record database of clients and contacts, along with a proprietary calendar/appointment system. Running on an 11 station LAN, Splash now runs it's business on our software. Here's a screen shot of the main data management page.

  We are experts in data integration; a recent example involved Quickbooks accounting software, UPS shipping software and MS Access as an intermediary. Out client was producing invoices with a web based system and then doing lots of hand data entry work. We automated the system; wrote code and created a program for him; it brought data and invoices  down from the web into Access, allowed him to mark each as shipped via UPS (and we then uploaded it into the UPS application) or the US Mail ( we then printed labels) and then sent the invoices automatically into Quickbooks. "This saved me 5 hours a day in manual data entry" said the client.

 These are 4 out of the hundreds of applications we have written, many not in Access but in one of the many other database environments out there.

 

  We are experts in all aspects of Access; database repair, user training, data conversion, moving a system from one machine or network to another, scaling up to MySQL or SQL Server, and moving your data onto the web. We have supported and enhanced applications written by others, and are pleased to step in to advance older or troubled projects.

  When to go beyond Access ?

 

 Call or email for a free quote.  How can we help organize your business better ?

 

 

Home

   

Contact us